Home Forums Article Discussions Article Discussions by Author Discuss content posted by Geoff Albin How to Monitor for High CPU utilization in SQL Server RE: How to Monitor for High CPU utilization in SQL Server

  • November 17, 2010 at 3:59 am

    #1251785

    hrc (11/17/2010)

    What about @@CPU_BUSY and @@IO_BUSY

    if you checked those two values e.g. every 10 seconds and the @CPU_BUSY had increased 8 seconds I would assume that it was running on 80%, that without the VBA and the security issues it imposes.

    might be possible, but i never found a good way to do that with either @@CPU_BUSY or sp_monitor.

    by using the Win32_PerfRawData_PerfOS_Processor object, the data is coming from the same place that perfmon uses. I find that to be highly accurate.

    Thanks