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.
Here is your download link for SQL Diagnostic Manager for SQL Server!
Please choose the file that meets your system requirements:
You’ll also receive a confirmation email with a download link for your product. To ensure email delivery, please whitelist [email protected]. If you do not receive your email, please be sure to check both your inbox and filters for a message from [email protected].
Here is your download link for SQL Diagnostic Manager for SQL Server!
Please choose the file that meets your system requirements:
Topics :
Products :
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”
Monitor, audit and alert on SQL Server changes
- Audit sensitive data to see who did what, when, where, and how
- Monitor and alert on suspicious activity to detect and track problems
- Satisfy audits for multiple industry regulatory requirements
- Select from over 25 pre-defined compliance reports and create custom views
- Lightweight data collection agent minimizes server impact