Webcast : Managing SQL Server Upgrades using the Query Store and Compatibility Level Settings
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.
Joey D’Antoni is an Senior Consultant and SQL Server MVP with over a decade of experience working in both Fortune 500 and smaller firms. He is a Principal Architect for Denny Cherry and Associates and lives in Malvern, PA. He is a frequent speaker at major tech events, and blogger about all topics technology. He believes that no single platform is the answer to all technology problems. He holds a BS in Computer Information Systems from Louisiana Tech University and an MBA from North Carolina State University, and is the co-author of the Microsoft white paper “Using Power BI in a Hybrid Environment”
24X7 SQL performance monitoring, alerting and diagnostics
- Monitor performance for physical, virtual, and cloud environments.
- Monitor queries and query plans to see the causes of blocks and deadlocks.
- Monitor application transactions with SQL Workload Analysis add-on.
- View expert recommendations from SQL Doctor to optimize performance.
- Alert predictively with settings to avoid false alerts.
- View summary of top issues and alerts with the web console add-on.