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

    Unanswered: Performance Issues

    Hi guys,

    I have a 16gb main production database (SQL server 2000 standard ed) and it has started running a slow........

    I have created steps in the backup jobs to re-index and update stats,

    but it is still running slow......

    Is there anything else I can do to improve performance?

    Is this a case for Enterprise edition?

    Any help would be greatly appreciated as this is my first DBA job.

  2. #2
    Join Date
    Jan 2003
    Location
    India
    Posts
    523

    Re: Performance Issues

    Originally posted by SQLSlammer
    Hi guys,

    I have a 16gb main production database (SQL server 2000 standard ed) and it has started running a slow........

    I have created steps in the backup jobs to re-index and update stats,

    but it is still running slow......

    Is there anything else I can do to improve performance?

    Is this a case for Enterprise edition?

    Any help would be greatly appreciated as this is my first DBA job.
    I think the first step would be to put up a profiler and check what is the exact cause of it, whether there are long running queries etc.
    and do u have sp3 installed?

  3. #3
    Join Date
    Feb 2002
    Location
    Sweden
    Posts
    34
    Could use some hardware specs.. use performance monitor to first of all find out if itīs Proc, IO or memory thatīs having a hard time.
    The server has just began to slow down without warning? not more users added or some modification done to the server?
    - Jonte

  4. #4
    Join Date
    Nov 2003
    Location
    London
    Posts
    169
    Hi,

    Hardware is a dual zeon thingy with plenty of ram and raid 10 array.

    There have been some more users added recently, but there is a save service that connects to the database and executes a number of SP, this is the thing that is running slow.

    How do I use performance monitor, to tell which SP is giving the problem?

  5. #5
    Join Date
    Feb 2002
    Location
    Sweden
    Posts
    34
    You canīt use perf monitor to find out exactly wich sp is causing you trouble but it can tell you if your hard drives are running like mad in order to scan all records in order to execute statements wich can tell you that memory could be an issue because of all the swap Or that a table or two needs more/better indexes Or maybe some sql rewriting.. puh..

    I think the only way to find out wich sp thatīs causing the trouble is to run each sp in QA and then examine the execution plan generated.

    Itīs a long running transaction then? from what type of system?
    - Jonte

Posting Permissions

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