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 registering, you confirm that you agree to the processing of your personal data by Idera, Inc. as described in the Privacy Statement.
Idera, Inc. is part of the Idera group and may share your information with its parent company Idera, Inc., and its affiliates. For further details on how your data is used, stored, and shared, please review our Privacy Statement.