Results 1 to 6 of 6

Thread: CPU usage history

  1. #1
    Join Date
    Nov 2002
    Posts
    231

    CPU usage history

    Hi,
    Is it possible to see the CPU usage history other than running performance monitor?.

  2. #2
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    you can download some third party tools if you don’t like perfmon.

    you can store a snapshot of sysperfinfo table every min and then analyze the usage. It will not capture all kind of CPU usage.

    You can store the values of sysprocesses or output of sp_who2 in a table (every min) and then analyze it.

    BTW. Why not perfmon?

  3. #3
    Join Date
    Nov 2002
    Posts
    231
    As we know if we are using Performance monitor system perfromace will be decrease. So I don't want affect the existing system performance.
    Thanks,
    Ravi

  4. #4
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    it depends on how often you collect the information and what are the junks you want to collect.


    Check this link.


    http://www.sql-server-performance.co...utor_part1.asp

  5. #5
    Join Date
    Jan 2021
    Posts
    7
    Quote Originally Posted by ravi View Post
    As we know if we are using Performance monitor system perfromace will be decrease. So I don't want affect the existing system performance.
    Thanks,
    Ravi
    No to resolve that
    you can download an overclocking software which has the capability to overclock and fine-tune your CPU and even it won't strain your processor.

  6. #6
    Join Date
    Feb 2014
    Location
    Riviera Beach, Maryland, USA
    Posts
    86

Posting Permissions

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