Displaying posts tagged with

“TempDB”

Jun
18
2009
SQL Administration By Vivek | No comments yet

Could 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

The error happens when your disk space is full on TempDB.Check the space on the Drive where the TempDb is located .
Solutions
a.Review the Query and check if it can be better optimised. Some of the Queries’ intermediate heavy datasets are stored in tempdb before returning the results.
b.The most easiest way I found is to restart [...]