8 factors that SQL Server affects DBCC CHECKDB

The first type:

The size of the database.

The second type:

The speed of the IO system.

The third type:

The current CPU load.

The fourth type:

The higher the concurrent modification of the current database, the greater the cost of maintaining the database snapshot because of the concurrency modification, and the process of creating a snapshot during DBCC, so.

The fifth type:

The speed at which the tempdb database hard disk is stored. There are some intermediate results in the DBCC process, and it is not appropriate or impossible to put all these results in memory. So there are

Use the space in tempdb.

The sixth type:

The type of object in the database, and the time it takes for different types of objects to be inspected is not the same. Time-consuming has nonclustered indexes, computed columns, off_row_lob,server_broker,xml indexes.

The seventh type:

The parameters used by DBCC CHECKDB, such as with NOINDEX, tell SQL Server not to look at nonclustered indexes,

With physical_only you can tell SQL Server to check only the physical structure.

The eighth type:

The number of errors in the database because SQL Server uses the algorithm to evaluate the error level for each error.

8 factors that SQL Server affects DBCC CHECKDB