Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Transact-SQL (2005)  sp_monitor

Author  Topic  clo Starting Member 10 Posts Posted - 2010-09-24 : 03:42:03 Hi All, I cannot understand the percentage (3rd figure) of cpu_busy and idle after running sp_monitor. As I understand from (http://msdn.microsoft.com/en-us/library/aa238856(SQL.80).aspx), the percentage is the percentage of time since sp_monitor was last run. May I know what is the meaning of 0% and >100% at cpu busy and idle as below? For cpu busy, the number in parentheses refers to the number of seconds or total number since the last time sp_monitor was run, since the number in parentheses is '1515' in this case, i assume the percentage is non-zero. Please advice. CPU Busy Idle 27379(1515)-0% 14113308(100)-769%