SQL Server Performance Forum – Threads Archive

Understend Current activity

there are very big nubers for cpu,memeory,i/o in current activity.
Where can i read what those numbers acctually meens

About Profiler?
Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
Bertrand Russell

From BOL: CPU:
Cumulative CPU time for the process. The entry is updated only for processes performed on behalf of Transact-SQL statements executed when SET STATISTICS TIME ON has been activated in the same session. The CPU column is updated when a query has been executed with SET STATISTICS TIME ON. When zero is returned, SET STATISTICS TIME is OFF. Physical IO:
Cumulative disk reads and writes for the process. Memory Usage:
Number of pages in the procedure cache that are currently allocated to this process. A negative number indicates that the process is freeing memory allocated by another process.

Actually what i am asking what is cpu=1020288 in Current Activity->&gt<img src=’/community/emoticons/emotion-4.gif’ alt=’;p’ />rocess information? As far as i know CPU can go from 0 to 100 what 1000000 meeans?

Cumulative CPU time for the process in milliseconds. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

From BOL Cumulative CPU time for the process. The entry is updated only for processes performed on behalf of Transact-SQL statements executed when SET STATISTICS TIME ON has been activated in the same session. The CPU column is updated when a query has been executed with SET STATISTICS TIME ON. When zero is returned, SET STATISTICS TIME is OFF. Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
Bertrand Russell

In your example, the process was using 1020 Sec. of CPU time since it’s login. Normally, if you see heavy CPU usage on you server and you want to identify which particular process is using more CPU, you can use this information from current activity to get a clue. The process with high CPU time with most recent login time could be the culprit. <blockquote id="quote">quote:<hr height="1" noshade id="quote">Originally posted by NewDBA Actually what i am asking what is cpu=1020288 in Current Activity->&gt<img src=’/community/emoticons/emotion-4.gif’ alt=’;p’ />rocess information? As far as i know CPU can go from 0 to 100 what 1000000 meeans? <hr height="1" noshade id="quote"></blockquote id="quote">

Refer thru this Q&Ahttp://www.sql-server-performance.com/q&a107.asp link by Brad. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

thank you .

]]>