Results 1 to 2 of 2

Thread: CPU Utilization

  1. #1
    Join Date
    Nov 2001
    Posts
    36

    Lightbulb Unanswered: CPU Utilization

    Hi All,

    I want to keep track of the CPU utilization & number of users connected for each database on our production box. I chose to get the data from sysprocesses table from master database.

    But I realised that for some reason the master..sysprocesses.CPU column stays static or just keeps on adding to existing values.

    Is there any ways thru which I can clear this data ( cpu column in sysprocesses table) after I have captured it in a table ?

    Any help is appreciated.

    Thanks.

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    You may be better off using perfmon with those two counters. yOu can put the output to a .csv, for later import into databases. This will not give you CPU usage per connection, however, so it is somewhat useless if you want to do chargebacks of some sort.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •