Perth Microsoft Data and Analytics User Group

Event

Next Meeting: Thu, Sep 25 2014

Performance Troubleshooting Using Wait Statistics

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: https://www.eventbrite.com/e/pssug-performance-troubleshooting-using-wait-statistics-paul-randal-tickets-13058806241

Performance Troubleshooting Using Wait Statistics 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.

When

iCal
UTC : Thu, Sep 25 2014 09:00 - 11:00
Event Time : Thu, Sep 25 2014 17:00 - 19:00 (UTC+08:00) Perth
Your Local Time: Thu, Sep 25 2014 09:00 - 11:00

Where

Level 3, 100 St George's Terrace
Perth , WA

Direction: None

Featured Presentation

Performance Troubleshooting Using Wait Statistics

Speaker: Paul Randal, CEO and Owner SQLskills.com

Summary: 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 Paul: Paul’s an author, consultant, and top-rated speaker having spoken at PASS, TechEd, SQLintersection, and numerous other events around the world. 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 has been a SQL Server MVP ever since. 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. Full bio at http://www.sqlskills.com/about/paul-s-randal/

Attachments

PASSChapterLogo100.jpg 

PASS provides the Perth SQL Server User Group with this website and other resources.

Microsoft provides us with a venue in which to host our meetings once a month.

OnCall DBA provides us with complimentary refreshments each month.

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids