SQL Server Performance Tuning - Advanced Techniques
IDERA sponsored on-demand webinar
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.