Geek Sync Webcast : How to Catch SQL Server Performance Troublemakers

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.


Here is your download link for SQL Diagnostic Manager for SQL Server!

Please choose the file that meets your system requirements:

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 Uptime Infrastructure Monitor FREE for 30 days


Uptime

Unify IT Performance Monitoring and Optimization

  • Server, network, and application monitoring on a single dashboard
  • View historic data for server capacity planning
  • Track service-level trends for SLA compliance

Start for FREE