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

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)