Contents
How much database space do I need?
What to do next
| Database size | Minimum temporary-space requirement |
|---|---|
| ≥ 1 TB and < 1.5 TB | 150 GB |
| ≥ 1.5 and < 2 TB | 200 GB |
| ≥ 2 and < 3 TB | 250 – 300 GB |
| ≥ 3 and < 4 TB | 350 – 400 GB |
How much space do you need for SQL Server?
SQL Server requires a minimum of 6 GB of available hard-disk space. Disk space requirements will vary with the SQL Server components you install.
Is DBCC Checkdb necessary?
The shorter the period of time you keep backups, the more often you need to run DBCC CHECKDB. If you keep data for two weeks, weekly is a good starting point. If you take weekly fulls, you should consider running your DBCC checks before those happen. A corrupt backup doesn’t help you worth a lick.
How long does a DBCC Checkdb take?
On the same server, CheckDB on a 10 gig database completes in about 4 minutes.
Is there excessive tempdb space required for DBCC checkdb?
Runnign DBCC CHECKDB with estimate only states it would require 1.3TB of tempdb space! Yet we have a 4TB database on another instance that would only require 23MB! Whats the deal?! Do you have a small number of large tables in this databases, whereas in your other databases, the data is more evenly distributed between tables?
Can a DBCC checkdb be run on a resource database?
Because the Resource database is modifiable only in single-user mode, the DBCC CHECKDB command cannot be run on it directly. However, when DBCC CHECKDB is executed against the master database, a second CHECKDB is also run internally on the Resource database.
How can I tell how much space I need for checkdb?
You can check in advance how much (estimated) space will be needed by DBCC CHECKDB by running it using the WITH ESTIMATEONLY option (broken in 2008 R2, fixed in 2012 SP2 and 2014) and then making sure that tempdb is sized accordingly to accommodate the DBCC CHECKDB requirements AND the regular tempdb space requirements.
Why do I need so much disk space for DBCC?
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. I find this odd because we have many multi-terabyte databases that can run DBCC CHECKDB with 200GB or less tempdb space.