Appropriate tempdb size?

by jack   Last Updated October 09, 2019 16:06 PM

DBCC CHECKDB is failing on a particular database because of

Could not allocate space for object 'dbo.SORT temporary run storage: 143479689576448' 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.

Tempdb is currently 5GB. The database in question is 56GB. The biggest table in that db is 15GB.

How big shall I make tempdb?

Thanks



Answers 1


You can use the "WITH ESTIMATEONLY" with your dbcc command.

DBCC CHECKDB WITH ESTIMATEONLY

This should give you an aprox. space in tempdb to run it. .

dbamex
dbamex
October 09, 2019 15:27 PM

Related Questions


Updated May 15, 2015 21:02 PM

Updated February 13, 2018 17:06 PM

Updated December 19, 2017 03:06 AM

Updated July 07, 2015 12:41 PM

Updated April 15, 2019 15:06 PM