65318A - Advanced SQL Server Performance Tuning
This 2-day course builds on the SQL Server 2025 query analysis skills taught in 65317A and focuses on real-world troubleshooting techniques. Students will be taught to tune and optimize queries using native SQL Server features, SSMS 22 and other tools for SQL Server 2025.
What's included?
-
6 Modules
-
6 Reviews
-
6 Labs
Audience
The primary audience for this course is individuals who already have basic querying and query optimization skills taught in course 65317A. The advanced query tuning skills taught in this course will be reinforced through practical labs that focus on the necessary troubleshooting skills for busy DBAs.
At course completion
After completing this instructor-led / bootcamp course, students will be able to:
* Analyze query execution plans to identify performance bottlenecks in SQL Server 2025
* Analyze query execution plans to identify performance bottlenecks in SQL Server 2025
* Apply real-world tuning techniques using SSMS 22 and advanced diagnostic tools
* Optimize query performance through index strategy and execution plan optimization
* Optimize query performance through index strategy and execution plan optimization
* Troubleshoot and resolve performance issues in production SQL Server environments
* Leverage SQL Server 2025 new features and Microsoft tools for continuous performance monitoring
Course Lessons