July 26, 2005 at 8:55 am
Do you know any alert that we can set-up in a sql server instance to monitor the CPU utilization
July 26, 2005 at 10:20 am
It's probably easier to do this using an Alert in Performance Monitor.
K. Brian Kelley
@kbriankelley
July 26, 2005 at 11:58 am
Do you know any alert in SQL Server that I can set-up in a sql server instance to monitor the CPU utilization?
July 26, 2005 at 12:08 pm
Without resorting to some sort of scripting, no. SQL Server doesn't keep track of any performance counters except those related directly to SQL Server (which you'll find in the sysperfinfo system table). Using WMI you can get to the counters so it may be possible through a linked server connection. However, it's simpler to do this outside of SQL Server. Is there a reason it must come from within SQL Server itself?
K. Brian Kelley
@kbriankelley
July 26, 2005 at 12:13 pm
There is no reason why it must come from SQL server. Do you know of any tool that can do outside the sql server?
July 26, 2005 at 2:05 pm
Performance Monitor aka PerfMon
K. Brian Kelley
@kbriankelley
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply