Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Location
    London
    Posts
    169

    Unanswered: sql server running slow

    Hi,

    Our main production server has started running slow, it is a dual zeon thingy with plenty of ram so hardware is not an issue.

    Basically a service connects to the database and executes a few stored procs, the only way I can get the system up to speed again is to recompile one of the SPs but that is only a temporary fix.

    Anyone had a similar thing?

    Can anyone give me help on performance tuning in SQL server 2000.

    Thanks

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    How about reindexing on involved tables?
    Try to update stats manually and see any performance gain, if so then schedule a job to update stats depending upon the data updation on those tables involved.

    HTH
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Just to get things straight, you have a service that connects to SQL Server, and runs a few procedures. Is this nightly? Hourly? How long does the service take to get through it's routine?

    Once the service is done, then users (presumably connecting another way) are complaining that the system is slow? How slow is slow? Next time this happens, take a look at the query plan for this stored procedure you recompile both before you recompile, and after, and see what changes in the execution plan. If there are no changes, you may have a different problem on your hands.

Posting Permissions

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