Sql-server – Allocate space for object ‘dbo.SORT temporary run storage

dbcc-checkdbsql serversql-server-2008tempdb

DBCC CHECKDB returns:

Could not allocate space for object 'dbo.SORT temporary run storage:
140737951236096' in database 'tempdb' because the 'PRIMARY' filegroup
is full.

Create disk space by deleting unneeded files, dropping
objects in the filegroup, adding additional files to the filegroup, or
setting autogrowth on for existing files in the filegroup.

Msg 9002,
Level 17, State 4, Line 1

Best Answer

This is pretty self explanatory - your tempdb is full, and can't be grown to perform the operation it needs tempdb for.

As indicated, either the disk where it is located is full, or you haven't got suitable autogrowth settings (see this earlier post for information about that), if it's not autogrowth, you'll have to either delete other files from the disk that your tempdb is on, or locate your tempdb on a bigger disk.

This sqlservercentral post is similar to yours and might take be worth a look. This video by Brent Ozar might be worth a look too, covering tempdb performance and config.

Related Question