How to shrink tempdb when Event ID 1101 Could not allocate a new page for database 'TEMPDB' because of insufficient disk space in filegroup 'DEFAULT'

17 February,2017 by Jack Vamvas

Question: An analyst was completing some reconciliation checks and some of the queries required to complete the reconciliation forced the SQL Server TempDB to grow and fill the drive hosting the TempDB.The error message appearing was :

Event ID 1101Could not allocate a new page for database 'TEMPDB' because of insufficient disk space in filegroup 'DEFAULT'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

What tactics are available to the DBA for dealing with this temporary problem?

Answer: Even with the best capacity planning – there will be times where users run queries requiring resources beyond the limits. Event ID 1101 means the disk is full.

Depending the situation there are a number of possibilities .

Related Posts

TempDB performance and strategy checklist

 


Author: Jack Vamvas (http://www.sqlserver-dba.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on How to shrink tempdb when Event ID 1101 Could not allocate a new page for database 'TEMPDB' because of insufficient disk space in filegroup 'DEFAULT'


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer