Sample Header Ad - 728x90

Overhead associated with DBCC CHECKTABLE?

0 votes
1 answer
226 views
Have a logshipped VLDB and don't run **DBCC CHECKDB** on primary due to the long running periods of high CPU and tempdb usage. Have read about **DBCC CHECKTABLE** as a possibility for a more granular data integrity checking option. Does **DBCC CHECKTABLE** have overhead levels similar to **DBCC CHECKDB**? Can it be run during business hours without adversely affecting server CPU and TempDB performance?
Asked by user2368632 (1133 rep)
Dec 13, 2020, 11:47 PM
Last activity: Dec 14, 2020, 10:54 AM