InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 16:47:51 GMT20http://www.sqlservercentral.com/Forums/Topic542845-65-1.aspxThanks for suggestion. But, I don't want to tax trading production system for rare occurrence by continuously running profiler due to (4% - 18%) overheads.Wed, 30 Jul 2008 10:53:12 GMTNeeraj Mittalhttp://www.sqlservercentral.com/Forums/Topic542845-65-1.aspxHow about the Profiler in SQL Server? Do not forget applying filter on it if use it.Wed, 30 Jul 2008 10:43:54 GMTSQL ORACLEhttp://www.sqlservercentral.com/Forums/Topic542845-65-1.aspxI have SQL Server 2000 SP4. There is trading application running on it. System is some time behaves very slowly. The occurrence is not fixed and happening rarely/once a month. There is no pattern which leads to the problem area. I want to gather data from syspocess table based on values CPU, physical_io, Memusage, waitresource, waittime....etc? So problem can be pinpoint later. Do we have any benchmark set for these value so I can filter out based on that criteria? Or is there any script available which will do that.The objective is to pinpoint the problem reason based on these values. Any help/pointer in this regard is highly appreciated.Thanks in advance for assistanceTue, 29 Jul 2008 10:25:16 GMTNeeraj Mittal