PluralSight – Query Performance and Optimization in SQL Server
English | Tutorial | Size: 243.00 MB
Upgrading SQL Server can change performance behavior in unexpected ways. This course will teach you how to evaluate, validate, and optimize SQL Server 2025 performance using Query Store, Intelligent Query Processing, and structured tuning workflows.
What you’ll learn
Upgrading to a new SQL Server version can introduce performance uncertainty when optimizer behavior, Intelligent Query Processing features, and concurrency refinements change how workloads execute.
In this course, Query Performance and Optimization in SQL Server 2025, you’ll gain the ability to evaluate, validate, and optimize performance safely after upgrading.
First, you’ll explore the key performance themes in SQL Server 2025, including optimizer evolution, concurrency improvements, and Query Store enhancements.
Next, you’ll discover how to detect and correct regressions using structured Query Store workflows and controlled validation techniques.
Finally, you’ll learn how to apply engine improvements and build a disciplined observability and rollout strategy.
When you’re finished with this course, you’ll have the skills and knowledge of SQL Server 2025 performance optimization needed to stabilize and improve production workloads with confidence.
DOWNLOAD: