Speeding up

  • 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 )

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply