Geek Sync Webcast : SQL Server Performance Made Easy

Every DBA hates to wake up at midnight just to learn there is an emergency with their database. Sometimes, even though their hardware specifications are above par and they know everything was working fine earlier that day, DBAs are still faced with a slow server. Luckily, there are always some early indicators which can help DBAs predict upcoming issues. Proactively monitoring their database and keeping a vigilant eye on the database key areas are mandatory tasks for all DBAs.

Join IDERA and Pinal Dave as he walks through common performance issues and best practices to solve them. This session will include how to identify inefficient queries, how to recognize queries causing blocking and deadlocks, how to resolve wait statistics, and how to analyze wait statistics and resolutions. Pinal will also walk through how to isolate performance root cause with Workload Analysis and how to review predictive performance alerts. This is an interactive Geek Sync you will not want to miss!

Topics :

Products :

Pinal Dave

Pinal Dave is a Developer Evangelist. He has authored 11 SQL Server database books, 14 Pluralsight courses and over 2900 articles on the database technology on his blog at http://blog.sqlauthority.com. Along with 10+ years of hands-on experience, he holds a Masters of Science degree and a number of certifications, including MCTS, MCDBA and MCAD (.NET). His past work experiences include Technology Evangelist at Microsoft and Sr. Consultant at SolidQ.

Try SQL Diagnostic Manager for SQL Server FREE for 14 days


SQL Diagnostic Manager Repository dashboard

24X7 SQL performance monitoring, alerting and diagnostics

  • Monitor performance for physical, virtual, and cloud environments.
  • Monitor queries and query plans to see the causes of blocks and deadlocks.
  • Monitor application transactions with SQL Workload Analysis add-on.
  • View expert recommendations from SQL Doctor to optimize performance.
  • Alert predictively with settings to avoid false alerts.
  • View summary of top issues and alerts with the web console add-on.

Start for Free