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
hrc
Old Hand
Points: 323
More actions
November 17, 2010 at 3:18 am
#1251757
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.