Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Performance benchmarkes ? Expand / Collapse
Author
Message
Posted Tuesday, July 29, 2008 10:25 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 7:27 PM
Points: 54, Visits: 705
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
Post #542845
Posted Wednesday, July 30, 2008 10:43 AM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Friday, April 05, 2013 4:43 PM
Points: 1,473, Visits: 1,314
How about the Profiler in SQL Server? Do not forget applying filter on it if use it.
Post #543705
Posted Wednesday, July 30, 2008 10:53 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 7:27 PM
Points: 54, Visits: 705
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.
Post #543711
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse