SQL Server Waits and Queues can reveal your past, explain your present and predict your future. SQL Server Performance Tuning uses the Waits and Queues as a proven method to identify the best opportunities to improve performance. In this webcast, we will focus on the practical approach of SQL Wait Stats and learn how the resource of two of the major performance bottlenecks related to I/O and CPU.
Towards the end of the webinar we will share the scripts so you can do it on your own in the future.
Pinal Dave is a technology enthusiast and independent consultant with over thirteen years of experience in the information technology sector. He has successfully authored 11 SQL Server database books, 18 Pluralsight courses and written over 3200 articles on database technology via his blog http://blog.sqlauthority.com. Rounding out his professional career, Pinal has held key positions as Sr. Consultant for SolidQ and as a Technology Evangelist for Pluralist and Microsoft. Pinal holds a Master of Science from the University of Southern California, and numerous professional certifications, including MCTS, MCDBA and MCAD (.NET).
Topics: Database Performance, Database Diagnostics, SQL Query Performance Products: SQL Diagnostic Manager for SQL Server