Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2002
    Posts
    3

    Unanswered: What is causing SQL7 high CPU usage

    Hi

    As a novice sql administrator, I am having troubles identifying what is causing the mssql 7 service to use >99% CPU usage.

    It is happening on a semi-regular basis, where it skyrockets from anywhere between 10+ minutes to a couple of hours. Since it goes up and down, I don't think it is due to a software bug.

    May I know what sort of steps I can take to determine the user, database, sql procedure/statement that could be causing the problem?

    Thanks for any advice.

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    The best bet to use PERFMON provided from Windows, and gather counters for PRocess, Processor, Memory, Physical disk, sql serve related. Refer to this link for PERFMON tips and tricks, also other information.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Feb 2004
    Posts
    1

    Question High Physical memory

    I am looking at my Perf Mon and see that the buffer cache is 99% and the total server memory is 87%. What is telling me please?

Posting Permissions

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