January 16, 2015 at 4:18 am
Hello Team,
I have an integrity job running on a 3 tb db, which runs for 7 hours. however the window given is only for 2-3 hrs.
any idea on how to optimize this
Thanks
Atulyan
January 16, 2015 at 4:53 am
If you mean DBCC, the options are limited. You can run a PHYSICAL_ONLY check that will just check the external storage of the data and not the internal storage. That check is a lot faster. You can then run the internal storage check on a restored copy of your database. Although, with a database of your size, it's unlikely you have very many copies laying around.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 16, 2015 at 6:19 am
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 16, 2015 at 7:20 am
Thanks for your help
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply