Post reply

How can I calculate CPU % per processes in SQL 2000 ?

  • March 7, 2006 at 11:11 pm

    #168610

    Hi,

    Is there a way that I can calculate what cpu % a spid in SQL 2000 or 2005 is using ? I can  get the CPU time , but dont know how to calculate the CPU %

    Has anyone every tried this ?

     

    Cheers,

    Esckay

  • March 10, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • March 13, 2006 at 7:31 am

    #626206

    You could trace the events using SQL Profiler. It reports the CPU time for every database action, but it doen't give you CPU %. Maybe it could help you.

    Diego

     

  • March 15, 2006 at 5:33 am

    #626721

    There is a stored proc sp_monitor, but this gives the total cpu %. I have checked numerous places on the web, but I still haven't found a answer.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply