November 7, 2005 at 5:38 am
I have a monitor/notify requirement on a large production system. It needs to run just about non-stop 24/7, and is scheduled to fire once a minute.
There are a few very quick tasks it needs to perform (so no problem there), and then one task which could potentially eat a chunk of the CPU time (which is the bit I'm worried about). Since this IS a busy production environment, it would be preferable if the hefty task is fired ONLY when the CPU usage is currently low.
The question is: HOW do I determine (with a storedproc) how busy the server is?
All thoughts much appreciated.
November 10, 2005 at 8:00 am
This was removed by the editor as SPAM
November 10, 2005 at 9:48 am
Try using an "SQL Server Performance Condition Alert" from the Alert section in Enterprise Manager, this is found under "management" - "SQL Server Agent" - "Alert". In here you can specify that once the CPU usage as dropped below X you can then tell the alert to fire a job. If you need further info please advise.
November 13, 2005 at 12:11 pm
That's a great idea, Mark. Thanks lots.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply