Home Forums SQL Server 2008 SQL Server 2008 Administration Very High CPU Usage by CHECKDB RE: Very High CPU Usage by CHECKDB
apat
SSCertifiable
Points: 5929
More actions
March 22, 2013 at 11:32 am
#1599924
I did run dbcc through completion and not really faster compared to old server (SQL 2005, less hardware).
Parallelism is set to 0. I can try changing to see the effect on CPU performance but its default to 0 now.
LPIM is not set.