How to troubleshoot SQL Server performance issues with simple tools (Part 3: The Profiler)

  This week we will show how you can use another simple tool to capture useful data for doing a performance analysis of SQL Server. This tool is included in the SQL Server installation and it is called the Profiler tool. It is very useful in troubleshooting Performance issues, because you can identify which queries…

0

How to troubleshoot SQL Server performance issues with simple tools (Part 2: How to analyze the Perfmon trace and detect SQL Server performance issues)

We have already shown how we can detect IO bottlenecks inside a Perfmon trace. Now it is time to see how we can detect SQL Server issues inside the same trace. We will use these Objects/Counters:   – SQLServer:Access Methods: Forwarded Records/sec These should be below 10% of the Batch Requests/Sec. If not, this means…

2

How to troubleshoot SQL Server performance issues with simple tools (Part 1: How to analyze the Perfmon trace and detect IO bottlenecks)

So you have finally collected the Perfmon trace. Good job! Now, how can you analyze and evaluate this data? It is easier than it seems:   1. Open Perfmon and go to the Performance Monitor tab. 2. Right click on the graph and choose to Remove All Counters 3. Right click on the graph and choose…

0