Groups > comp.databases.ms-sqlserver > #1614

Re: is there any way to make DBCC checkDB faster?

Newsgroups	comp.databases.ms-sqlserver
Date	2013-11-10 15:14 -0800
References	<f50088b8-6499-4403-98fa-992ef5731556@googlegroups.com>
Message-ID	<47ca06a6-c806-4986-9d13-cc0442652c78@googlegroups.com> (permalink)
Subject	Re: is there any way to make DBCC checkDB faster?
From	kedar@techsql.net

Show all headers | View raw

On Sunday, November 10, 2013 5:13:03 PM UTC-6, dbaon...@gmail.com wrote:
> is there any way to make DBCC checkDB faster?

I think yes ...

How can you make DBCC CHECKDB faster?
• Do one database a night. Either round robin equally or do more important ones more frequently.
• Check individual tables with CHECKTABLE and don't do them all at once (and frequently
do the other database level checks that are included in CHECKDB - CHECKALLOC and
CHECKCATALOG).

• Check one partition (assuming each is on a separate filegroup) at a time with
CHECKFILEGROUP.

You can refer below article for more info.
http://www.techsql.com/MSSQLServerDatabaseCorruption-CHECKDB.htm

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

is there any way to make DBCC checkDB faster? dbaonline99@gmail.com - 2013-11-10 15:13 -0800
  Re: is there any way to make DBCC checkDB faster? kedar@techsql.net - 2013-11-10 15:14 -0800

csiph-web