Tuesday, May 20th at 2:00pm ET
There are a handful of wait types that almost all SQL Server instances will see on a regular basis and it is very important to understand what they are and how to troubleshoot them. We will first see how to identify the top waits and discuss in some detail what each one actually means in relation to your SQL Server performance and overall operation. We will then identify some of the core techniques you can use to troubleshoot the bottleneck and discuss what options you may have to minimize the impact they are having on your system. Properly understanding wait stats will go a long way towards ensuring you have a good handle on how your system is performing at any given time.
If you have already registered, click here to access
Andrew J. Kelly is a contributing editor for SQL Server Pro, a SQL Server MVP, and the practice manager for performance and scalability at SolidQ. He has 20 years of experience with relational databases and application development. He is a regular speaker at conferences and user groups.Andrew J. Kelly is a contributing editor for SQL Server Pro, a SQL Server MVP and the practice manager for performance and scalability at SolidQ. He has 20 years of experience with relational databases and application development. He is a regular speaker at conferences and user groups.
Peter O Connell is the product manager of SQL Server database tools with DELL Software. Has spent 20 years in the software industry. He qualified as a computer engineer in 1994 and worked as developer specializing on Microsoft development technologies. During his time as an engineer he designed and built large enterprise and web applications based on the Microsoft stack with SQL Server as the database of choice. He went on to manage teams and run a business before coming to DELL software where today he manages a portfolio of tools that cover performance monitoring, diagnostics, tuning, development and administration.