Results 1 to 6 of 6

Thread: CPU usage history

  1. 12-10-2003, 01:00 PM #1
    ravi
    ravi is offline Registered User
    Join Date
    Nov 2002
    Posts
    231

    CPU usage history

    Hi,
    Is it possible to see the CPU usage history other than running performance monitor?.
    Reply With Quote Reply With Quote
  2. 12-10-2003, 01:14 PM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    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?
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  3. 12-10-2003, 01:26 PM #3
    ravi
    ravi is offline Registered User
    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
    Reply With Quote Reply With Quote
  4. 12-10-2003, 01:32 PM #4
    MAK's Avatar
    MAK
    MAK is offline Registered User
    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
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  5. 04-16-2021, 11:22 AM #5
    mikaha21
    mikaha21 is offline Registered User
    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.
    Reply With Quote Reply With Quote
  6. 04-16-2021, 04:43 PM #6
    SpywareDr
    SpywareDr is offline Registered User
    Join Date
    Feb 2014
    Location
    Riviera Beach, Maryland, USA
    Posts
    86
    Ummm, things were a bit different 17 years, 4 months and 6 days ago ... when this thread was created.
    -- Doc
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules