SQL Server Performance Tuning - Advanced Techniques


IDERA sponsored on-demand webinar

Webcast Abstract

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 I'll show 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. I'll also show 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

To access materials please fill out the form below.

  I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.





download











get free sql tips
agree to terms