Webcast : Identifying and Solving Common SQL Server Performance Problems

About this webcast:

Performance is always one of the DBA’s top priorities. The one thing that you know for certain is that if SQL Server isn’t performing up to the user’s expectations, you’ll hear about it. SQL Server is a complex system and there are a lot of factors that go into making it perform well and keeping it performing well. In this webcast, join Michael Otey, senior contributing editor at SQLServerPro, as he dives into some of the performance problems that a lot of SQL Server instances run into as well as the recommended industry best practices from Microsoft, MVPs and other database experts on how to handle them. Some of the main areas that he will cover include:

  • Keeping the wrong default configuration values
  • Monitoring SQL Server instances in Azure and AWS
  • Handling Tempdb contention
  • Indexing mistakes
  • Identifying problem queries
  • Dealing with CPXPACKET waits
  • Detecting SQL Server memory pressure

Subsequently, Tep Chantra from IDERA will discuss IDERA’s powerful solution for performance tuning with expert commentations for SQL Server in the hybrid cloud. SQL Doctor retrieves all of the necessary information, analyzes the results, pinpoints potential problems, and determines the resolution in minutes rather than hours. SQL Doctor leverages proven industry best practices to analyze the performance and provide expert recommendations plus executable scripts. It targets SQL Server (on premise and cloud virtual machines), Azure SQL Database, and Amazon RDS. SQL Doctor makes daily tasks easier for novices and experts at performance tuning.

Topics :

Products :

Michael Otey & Tep Chantra

Tep Chantra has worked in the IT industry for 10+ years taking on various roles such as Customer Support. His current role is the Product Manager for the SQL Doctor product at IDERA.

Try SQL Doctor FREE for 14 days

Complete SQL performance tuning and recommendations

  • Easily monitor and improve the performance of SQL Server, Azure and AWS instances.
  • Instantly locate real-time performance issues with Quick Findings.
  • Improve performance with updated recommendations for SQL Server 2016 and 2017, Azure SQL Database, and Amazon RDS.
  • Generate executable scripts to optimize performance.
  • View trends from history of analysis recommendations.

Start for Free