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

(this is an on-demand video)

Sponsored by - IDERA

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.

  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.




More SQL Server Solutions












download





get free sql tips

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.



Learn more about SQL Server tools