Identifying and Solving Common SQL Server Performance Problems
Sponsored by: IDERA
May 1, 2017
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.
About the Author
You May Also Like