Post reply

How can I calculate CPU usage in SQL as a percentage ?

  • March 3, 2006 at 1:16 am

    #168600

    Hi,

    Is there a way in SQL 2000 to calculate the cpu usage per process in SQL as a percentage?

    I can get the CPU time but not the CPU usage. I would like a similiar output that task manager would give for processes, but I would like this of the processes running within SQL.

    Thanks,

    Esckay

  • March 3, 2006 at 10:03 am

    #624663

      You're shooting at a moving target.  The total CPU time a process uses is measurable.  But the CPU % usage is a state of something at a particular point in time.  A process could start off pegging the CPU at 100%, then sit around waiting for data for the next step (0% usage), then get some of the data and process streams as they arrive (25-50%).  Which number would you need?  An average would be misleading at best due to the wait time in the middle.

      Note that task manager does not provide a single value for % CPU usage.  It constantly updates it.

    (Obligatory SQL Server 2005 remark goes here mentioning the graphical matching of performance logs and SQL traces in 2005)

    -Eddie

    Eddie Wuerch
    MCM: SQL

Viewing 2 posts - 1 through 1 (of 1 total)

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