July 28, 2008 at 1:40 am
Hi,
I have several SQL Servers, all with SQL agent running, and while looking at the log I was wondering what kind of actions dbas schedule when the cpu is idle. Maybe index maintenance? What if while this is running there's a peak in the server?
I would like to know if you think this is a useful option or it can cause more problems than benefits, and some of your experiences.
July 31, 2008 at 2:23 am
Index maintenance is a good idea to fill in the idle CPU.
You need to be careful not to rely on log alone in determining whether the CPU is idle.
Check with Performance Monitor logs for pattern (when the CPU always idle during the day, how long the CPU idle, and so on) and check with the user pattern and workload as well.
Index maintenance will take some time to finish (depending on your database size and whether it is a defrag or rebuild). With the rebuild, it is much safer to do it when the server really has no input. Since during the rebuild, the index is inaccessible for the queries to use.
Ivan Budiono
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply