InstantForum.NET v4.1.4SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 20 Mar 2010 05:45:04 GMT20http://www.sqlservercentral.com/Forums/Topic348600-5-1.aspxThanks Chris. I got my answer from you. Its a memory leak only.Fri, 02 Mar 2007 11:45:00 GMTkarina kapurhttp://www.sqlservercentral.com/Forums/Topic348600-5-1.aspxthe 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.Fri, 02 Mar 2007 05:54:00 GMTcolin.Leversuch-Robertshttp://www.sqlservercentral.com/Forums/Topic348600-5-1.aspx<P>Hi, this is clearly a memory issue and there are a number of things that can lead to performance degradation.</P><P>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.</P><P>2. It could be that you're experiencing memory leaks. Update your instance from SP3 to service pack 4.</P><P>If the two options I have given you do not improve your performance then your server will need thorough analysis.</P><P>Get in touch and I can help.</P><P>Chris M. (Snr. DBA, +256 77 2212285)</P>Fri, 02 Mar 2007 00:09:00 GMTChris Musasizihttp://www.sqlservercentral.com/Forums/Topic348600-5-1.aspx<P>Hi everyone,</P><P>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.</P><P>Thanks</P><PRE style="MARGIN-LEFT: 0.5in"><?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> </PRE>Thu, 01 Mar 2007 11:27:00 GMTkarina kapur