Geek Sync Webcast : Practical Performance Tuning with SQL Wait Stats

About this webcast:

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.

Topics :

Products :

Pinal Dave

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).

Try SQL Workload Analysis FREE for 14 days

SQL Workload Analysis

  • Granular wait state monitoring
  • Continuous SQL sampling
  • Intuitive drill down to view top activity
  • Query plan tuning and recommendations
  • Lock and latch resolutions
  • Storage visibility and contention resolution

Start for Free