Results 1 to 2 of 2

Thread: Slow SQL Server

  1. #1
    Join Date
    Aug 2010
    Posts
    1

    Question Unanswered: Slow SQL Server

    How do you troubleshoot SQL Server if its running very slow? I am running MS SQL Server 2005.

    Thanks!

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Has anything changed just before the slowness? Application upgrades, or maybe something new going live?

    First thing to check is whether the box itself is the bottleneck. Check perfmon to see if the CPU is railed, or if you have disk queues, or if the hardware is not in fact the bottleneck.

Posting Permissions

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