Identifying and Solving Common SQL Server Performance Problems

Identifying and Solving Common SQL Server Performance Problems

Sponsored by: IDERA

View On Demand

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

Register Now!

If you have already registered, click here to access

Speakers:

Michael Otey, senior contributing editor for Windows IT Pro and SQL Server Pro, is president of TECA, a software-development and consulting company in Portland, Oregon. Michael has covered the topic of virtualization extensively for Windows IT Pro, having written several features articles showing how to take advantage of virtualization in the enterprise as well as reviewing all of the major virtualization products. He also previously served as technical director for Windows IT Pro and SQL Server Pro. Email him at [email protected]

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.