Webcast : SQL Server Performance Tuning – Advanced Techniques

Presenter: Andy Warren

Often all it takes to fix a slow query is adding an index, but sometimes the problems are tougher than that and you have to move to more specialized approaches. In this presentation Andy Warren shows you how to use hints, indexed views, plan guides, and the query store to solve some not so common performance problems. Plus we’ll look at a bonus trick for when you have many tenants with wildly varying amounts of data. Andy also shows examples of problems that you should take back to your developers – it’s not always something the DBA can fix (though we often Band-Aid things to make a fix). You might not use all of this stuff we’ll cover every day or every week, but you will definitely find uses for many of the items we will cover to improve SQL Server performance.

Speaker:

Andy Warren is a SQL Server consultant based in Orlando. Andy was a founding principal of SQLServerCentral.com, is the former President of the Orlando SQL Server Users Group, and one of the founders of SQLSaturday. He has been an MVP since 2009 and has written and presented extensively SQL Server. Andy blogs at www.sqlandy.com, is on LinkedIn at www.linkedin.com/in/sqlandy, and is occasionally on Twitter as @SQLAndy.

Topics : Database Administration,Database Performance,SQL Query Performance,

Products : SQL Diagnostic Manager for SQL Server,

Register for Free Webcast

Note: By registering, you confirm that you agree to the processing of your personal data by Idera, Inc. as described in the Privacy Statement.
Idera, Inc. is part of the Idera group and may share your information with its parent company Idera, Inc., and its affiliates. For further details on how your data is used, stored, and shared, please review our Privacy Statement.