How to troubleshoot 1000 sql queries every day?

Question

What would be the best way to get rid of thousands of sql queries every day? Troubleshooting may include

• search for blocked requests
• Improving query performance
• Requests that delay the maximum processing time.

Answer 1

• See Locking Analysis with SQL Server Profiler

• SQL Server Query Performance Optimization, SQL Server Performance Improvement , Index Shell Enhances SQL Server Query Performance

Inventory growth in query performance is more an art than a science. This will be a query for query-based exercises, and may vary depending on many factors.

You should try to learn the basics of improving query performance so that you can easily identify the bottleneck in the query.

Answer 2

You can run SQL Profiler , but this will have a negative impact on performance.

The best option would be to look at the performance counters for the server and try to recognize the template.

Regardless, I started by reviewing the MSDN documentation titled " " Troubleshooting Performance in SQL Server 2005 "

Answer 3

Well, the query record, the type of problem and the number of occurrences will quickly tell you where it is best to spend the effort, with select troubletype,count(*) from database group by troubletype . Then, it may be drilled into the most common queries causing the problem.

If requests are generated ad hoc, then perhaps you will get some useful, debugged requests for users. Thus, fewer mistakes are made.