July 29, 2008 at 10:25 am
I 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 assistance
July 30, 2008 at 10:43 am
How about the Profiler in SQL Server? Do not forget applying filter on it if use it.
July 30, 2008 at 10:53 am
Thanks for suggestion. But, I don't want to tax trading production system for rare occurrence by continuously running profiler due to (4% - 18%) overheads.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply