Managing SQL Server Upgrades using the Query Store and Compatibility Level Settings

IDERA sponsored on-demand webinar

Webcast Abstract

Microsoft continues to release new versions of SQL Server which means we need to perform upgrades to stay current. In addition, with SQL Server 2008 and 2008R2 going off of support, many DBAs and developers find themselves facing the need to upgrade these servers as well. While SQL Server upgrades offer the benefit of exciting new features, they also carry the risk of performance degradation, courtesy of SQL Server optimizer changes.

In this webinar, you will learn about how to use the Query Store, Microsoft’s flight data recorder for SQL Server to identify query plans that have changed for the worst after an upgrade. You will learn about query patterns that are most likely to be affected by recent optimizer changes. Finally, you will learn about Microsoft’s new support policy for SQL Server that lets you use older compatibility modes forever.

Speaker - Joey DAntoni

To access materials please fill out the form below.