Please note that this website will be temporarily unavailable during the period 5:00 PM PST on Friday, Dec. 19 and 11:59 PM PST on Saturday, Dec. 20 due to a planned server migration. PASS apologizes for any inconvenience.

Calgary Events

Performance Troubleshooting Using Wait Statistics


When: Wednesday, January 21, 2015

Where: Microsoft Calgary

Time: 4:30pm to 6:30pm

Presenter: Paul S. Randal

Tickets: Available from Eventbrite


One of the first things you should check when investigating performance issues are wait statistics - as these can often point you in the direction for further analysis.

Unfortunately many people misinterpret what SQL Server is telling them and jump to conclusions about how to solve the problem - what is often called 'knee-jerk performance tuning'.

In this session, you will learn what waits are, how to analyze them, and potential solutions to common problem patterns.

About the Presenter

Paul is a Microsoft SQL Server MVP and a Microsoft Regional Director. He spent 9 years working on the SQL Server team, writing DBCC CHECKDB, and ultimately responsible for the entire Storage Engine.

In 2007 Paul left Microsoft to co-own and run SQLskills.com, and is a world-renowned author, consultant, and top-rated speaker on SQL Server performance tuning, administration, internals, and HA/DR.

When he's not tweeting, blogging, or helping someone recover from a disaster, he's likely to be underwater somewhere in the world with his wife, Kimberly L. Tripp.

 
Sponsors
Microsoft     Microsoft SQL Server     Telerik
    CA Technologies
    MaximunASP
                 
        SSWUG.org