Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Speeding up Expand / Collapse
Author
Message
Posted Tuesday, January 24, 2012 7:44 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 1:26 AM
Points: 33, Visits: 296
I think is a good idea .
We have a very large DB and there is no chance to run a DBCC Checkdb in reasonable time.
If you want to speed up the process, 2 hints
1) Process all databases in parallel, for example using a SSIS package
2) In a single database, the control runs in sequence, is possible to run it in parallel using the DBMS by something like
declare @cmd varchar(max) = ' select -9 o union all ' 
select @cmd = @cmd+ ' select count_big(*) as '+name+ ' from '+name + ' with index(1) '
from sys.tables
exec ( @cmd )

Post #1240884
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse