Geek Sync Webcast : How to Catch SQL Server Performance Troublemakers

Presenter: Pinal Dave

SQL Server applications can be huge and complex. Finding performance problems from such a huge application is often very difficult. There are many different performance troublemakers in SQL Server, and as a DBA, it is your responsibility to catch them. Once you catch performance troublemakers, you can decide how to resolve them.

Join IDERA and Pinal Dave as he demonstrates simple tricks to identify SQL Server Performance Troublemakers. Pinal’s presentation will be focused on finding CPU intensive queries, I/O optimization with index tuning, identifying and resolving performance bottlenecks with wait stats, and more. At the end of the session, attendees will have the understanding and the scripts to identify their own performance troublemakers.

About Pinal:
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 Monitoring,Database Performance,Powershell,SQL Query Performance,

Products : SQL Diagnostic Manager for SQL Server,

Register for Free Webcast

Note: By filling and submitting this form you understand and agree that the use of IDERA’s website is subject to the General Website Terms of Use. Additional details regarding IDERA’s collection and use of your personal information, including information about access, retention, rectification, deletion, security, cross-border transfers and other topics, is available in the Privacy Policy.