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