dbcc checkdb - how to work out the resources needed?
0
votes
0
answers
58
views
Integrity checks are important on a regular basis to find out errors .
Even on servers involved in availability groups .
we can normally find out how long it took to run?
It is a known fact that dbcc checkdb use a great deal of resources .
So I have run it to one of my databases - 170 Gb size.
with estimate only :
dbcc checkdb(DEV_My_Database) with estimateonly
It came out:
> DBCC results for 'DEV_My_Database'. Estimated TEMPDB space (in KB)
> needed for CHECKDB on database DEV_My_Database = 44320313. DBCC
> execution completed. If DBCC printed error messages, contact your
> system administrator.
However, I never saw any extra usage of tempdb
as everything seemed to fit in there for this purpose.
How can I work out the right usage of resources, including tempdb, for my dbcc ?
Asked by Marcello Miorelli
(17274 rep)
Feb 13, 2025, 02:26 PM
Last activity: Feb 13, 2025, 05:44 PM
Last activity: Feb 13, 2025, 05:44 PM