Post reply

performance

  • March 1, 2007 at 11:27 am

    #62354

    Hi everyone,

    Does anyone of you has ever  experimented performance degradation, which disappears as soon as you restart the SQL service. we are using SQL 2000 service pack 3.

    Thanks

     

  • March 2, 2007 at 12:09 am

    #692763

    Hi, this is clearly a memory issue and there are a number of things that can lead to performance degradation.

    1. Check if your applications often run cursors. Check your programability. Cursors are a no go area for fast optimum databases and they should be used with care especially for long running queries.

    2. It could be that you're experiencing memory leaks. Update your instance from SP3 to service pack 4.

    If the two options I have given you do not improve your performance then your server will need thorough analysis.

    Get in touch and I can help.

    Chris M. (Snr. DBA, +256 77 2212285)

  • March 2, 2007 at 5:54 am

    #692812

    the question is too vague and as such does not indicate any particular issue. The o/s , sql edition, setup and hardware might be useful to know. Also exactly what the perceived performance degredation is and how it manifests to users would be useful too.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • March 2, 2007 at 11:45 am

    #692912

    Thanks Chris. I got my answer from you. Its a memory leak only.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply