How to evaluate your database performance and diagnose problems

Many people use stress testing tools like Database hammer to test the Database performance. This is mainly applied pressure.

How can we determine the database performance and key applications that affect the performance of the test results? For example, devparter in Dotnet can count the methods that have been executed for a long time and the deadlocks that have occurred...

At this time, many people may use SQL Profiler. What are the comments on the test results of profiler?

The article mentioned several important indicators of observation and wrote four stored procedures to analyze the test results.

Http://vyaskn.tripod.com/analyzing_profiler_output.htm

The stored procedure and instance test data can be downloaded.