Performance Tuning

Slover Library

Can we have a conference without a discussion on performance tuning?

Wait statistics are one of commonly overlooked ways to quickly find out what is causing your SQL Server to be slow. One of the reasons that they are commonly overlooked is that without a monitoring tool, or your own custom monitoring tools, it is difficult to see how they are trending over time.

When someone reports that the database was slow yesterday at 2:00pm, do you know how to determine what was causing it to be slow? You can check the logs, you can look at the history of running jobs, and you might even ask around to see if anyone was doing anything unusual at that time. If you are tracking wait statistics, it is quick and easy to zoom in on a point in time and see exactly what queries were slow and why they were slow.  This session will guide you through the process of monitoring and responding to SQL Server waits.

What I will take home: A tool with the ability to capture waits and provide better information to your organization.

 

Performance Basics