Next Meeting: Thu, Apr 23 2015
Performance Troubleshooting Using Wait Statistics - Paul Randal
Event Type: In-Person & Online
Online Meeting URL: None
Join us Thursday, April 23rd at 6pm to learn about monitoring SQL Server with wait stats.
Many thanks to Red Gate and TEKsystems for sponsoring our group meetings, and to New Horizons at Logical Operations for hosting our meeting.
UTC : Thu, Apr 23 2015 22:00 - 00:30
Event Time : Thu, Apr 23 2015 18:00 - 20:30 Eastern Daylight Time
Your Local Time: Thu, Apr 23 2015 22:00 - 00:30
3535 Winton Place
Rochester, New York
Performance Troubleshooting Using Wait Statistics
Paul Randal, CEO and Owner SQLskills.com
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.
Paul Randal is the CEO and co-owner (with his wife, Kimberly Tripp) of SQLskills.com, a world-renowned training and consulting company. He worked on the SQL Server team for 9 years, most notably rewriting DBCC CHECKDB, and since then has been a SQL Server MVP and Microsoft Regional Director. Paul is an accomplished writer and presenter, with numerous books, articles, whitepapers, and conference top-speaker awards over the years. You can read more about Paul at www.SQLskills.com/about/paul-s-rand