Appropriate tempdb size?

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

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


Chaning tempdb settings on production database

Updated May 15, 2015 21:02 PM

How to know exactly when my Database / Log files grew?

Updated February 13, 2018 17:06 PM



Why does `ls -lh` on the data directory show 4kb?

Updated April 15, 2019 15:06 PM