Tuesday, October 21, 2008

Run Job During IDLE CPU Condition

Have you ever tried this option?

SQL Server Agent has an option to schedule a job to run when CPU(s) become idle, this can be a good choice for jobs which need more resources!

For example, You Server may be fully busy during USA and UK business hours and may be idle during the remaining time, so in that case we cannot define the exact period for the job but if we choose this option then SQL Server will automatically run the job when CPU become's IDLE.

On the other side you may get doubt that "incase CPU's are idle for just 2 mins during peak time, this schedule will start and may add to the utilization!"... Don't worry, Explan Enterprise Manager --> Go to SQL Server Agent --> Right click --> Select Properties --> Select Advanced Tab you will find below option

Here you can specify your own criteria for what is so called "IDLE" condition and only if this criteria is met then SQL Server Agent will run those jobs scheduled for IDLE CPU condition!
Test it and implement on exact fit situation!

No comments:

Post a Comment

Please do not spam!