Performance benchmarkes ?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Performance Tuning » Performance benchmarkes ?

Performance benchmarkes ?

Rate Topic

Display Mode

Topic Options

Author

Message

Neeraj Mittal

Posted Tuesday, July 29, 2008 10:25 AM

Valued Member

Group: General Forum Members
Last Login: Yesterday @ 6:56 AM
Points: 54, Visits: 648

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

SQL ORACLE

Posted Wednesday, July 30, 2008 10:43 AM

UDP 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

Neeraj Mittal

Posted Wednesday, July 30, 2008 10:53 AM

Valued Member

Group: General Forum Members
Last Login: Yesterday @ 6:56 AM
Points: 54, Visits: 648

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 »

Permissions