- Course
Query Performance and Optimization in SQL Server 2025
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.
Intermediate
- Course
Query Performance and Optimization in SQL Server 2025
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.
Intermediate
Get started today
Access this course and other top-rated tech content with one of our business plans.
Try this course for free
Access this course and other top-rated tech content with one of our individual plans.
This course is included in the libraries shown below:
- Data
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.
Query Performance and Optimization in SQL Server 2025
Intermediate
Table of contents
Pinal Dave is a Pluralsight Developer Evangelist.
