May 5, 2004 at 4:50 am
What is the best way to run dbcc checkdb on a server which has more number of databases sothat CPU overhaed should not be too high?
I need to run it daily at present. I am using cursor but it utilizes more cpu overhead.
Thanks in advance
--sntiwary
May 5, 2004 at 5:51 am
There is an option in job schedule Start whenever the CPU(s) become idle. It also
depends how long the job runs.
May 5, 2004 at 9:23 am
the jobs takes 5-10 mintutes but simultaneoulsy it should run daily at particular time. Any suggestions will be appreciated.
--sntiwary
May 6, 2004 at 3:16 am
Hi,
This is an abstract from the BOL:
Recommendations for Good DBCC Performance
1. Run CHECKDB when the system usage is low.
2. Be sure that you are not performing other disk I/O operations, such as disk backups.
3. Place tempdb on a separate disk system or a fast disk subsystem.
4. Allow enough room for tempdb to expand on the drive. Use DBCC with ESTIMATE ONLY to estimate how much space will be needed for tempdb.
5. Avoid running CPU-intensive queries or batch jobs.
6. Reduce active transactions while a DBCC command is running.
7. Use the NO_INFOMSGS option to reduce processing and tempdb usage significantly.
Hope this helps
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply