Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2003
    Posts
    268

    Unanswered: Diagnosing Performance Problem?

    I have a database server that has is acting very sluggish. Using the performance monitor, I can see that disk use is steadily at 100% usage.

    The system is so overburdened that attempting to do even basic tasks (open folders, look in Enterprise Manager, get screen repaints) has become impractical.

    Even if I could get to the Enterprise Manager "Process Info" display, what would I look for to tell me what is wrong?

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    From a remote PC, use Profiler to monitor all queries with over say 1000 reads. Copy those queries out to Query Analyzer, and see if you can get some indexes on the underlying tables to speed them up.

    Another thing to check is how much memory is in the box? SQL Server will default to taking all it wants, but if you have only 64MB in your box, then you are in for a world-o-hurt.

  3. #3
    Join Date
    Oct 2003
    Posts
    268
    Originally posted by MCrowley
    From a remote PC, use Profiler to monitor all queries with over say 1000 reads.
    How do I do this? What is Profiler?

    thanks for the feedback!

  4. #4
    Join Date
    Oct 2003
    Posts
    268
    Originally posted by RogerWilco
    How do I do this? What is Profiler?

    thanks for the feedback!
    Found it. This is definitely helping.

    Thankfully, we just hired a real DBA who starts Thursday.

    Thanks again!

Posting Permissions

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