We provide course about MasterClass: SQL Server Performance Tuning And Optimization in english. This course provides in-depth knowledge and techniques for improving the performance of Microsoft SQL Server databases.
Course description:
Participants learn how to identify bottlenecks, optimize queries, configure SQL Server for peak performance, and monitor workloads to ensure efficiency and stability. Performance tuning is a critical skill for database administrators and developers who need to ensure their SQL Server systems are fast, reliable, and scalable.
This course takes you through the entire performance optimization lifecycle, from understanding execution plans to indexing strategies, resource management, and proactive monitoring. Through a combination of theory and hands-on labs, you’ll learn how to diagnose performance issues and apply best practices used in real enterprise environments.
Technical level: 400
The difficulty level is consistent with the widely accepted scale of technical difficulty of training on Microsoft Corp.
Key takeaways:
After completing this course, participants will be able to:
• Analyze and interpret SQL Server execution plans
• Identify performance bottlenecks in queries and indexes
• Implement effective indexing strategies
• Optimize T-SQL performance
• Configure server and database settings for performance
• Use monitoring tools to track performance metrics
• Understand memory, CPU, and I/O implications on performance
• Apply performance troubleshooting methodologies
Course outline:
Module 1 - Performance fundamentals:
• Participants start by gaining an understanding of key performance concepts and how SQL Server processes queries. This sets the foundation for optimization techniques.
Module 2 - Execution plan analysis:
• This section focuses on how to read and interpret execution plans to find inefficiencies and costly operations
Module 3 - Indexing strategies:
• Participants learn how to design and implement indexes that improve query performance while balancing storage and maintenance overhead.
Module 4 - Query optimization:
• This topic covers techniques to optimize T-SQL queries through rewriting, plan hints, and understanding cardinality estimates
Module 5 - Server and database configuration:
• Participants explore settings that affect SQL Server performance, including memory, CPU affinity, MAXDOP, and database-level options.
Module 6 - Monitoring and troubleshooting performance:
• This section focuses on using built-in tools like Performance Monitor, Dynamic Management Views (DMVs), Extended Events, and Wait Statistics to monitor performance and diagnose issues.
Module 7 - Advanced topics: memory, I/O, and CPU:
• Participants gain deeper insight into how memory allocation, I/O patterns, and processor usage impact SQL Server performance and how to tune these subsystems.
Module 8 - Workload optimization and baselining:
• This topic covers how to establish performance baselines, compare workloads over time, and use that information to plan tuning activities.
Instructor: Magi Naumova
Margarita Naumova is a very well-known SQL Expert. Magi holds the highest possible SQL Server Technical Certification in the field – Microsoft Certified Master, making her one of the best SQL Server Experts Worldwide. Magi is also a Microsoft Data Platform MVP (Most Valuable Professional). She has more than 20 years of SQL Server and BI technologies consulting and training experience and is a trusted advisor for many large companies in SQL Server Platform Area.
Currently she works as a Managing Partner and Chief SQL Architect of Inspir-it AS, her own newly established Consulting Company in Norway. Margarita is a regular speaker at the largest IT events, SQLBits, SQL Saturday in Europe.
Target audience:
This course is suitable for:
• SQL Server Database Administrators
• SQL Developers
• Performance and Optimization Engineers
• IT professionals responsible for high-performance database environments
• Systems Engineers
Prerequisites:
Recommended:
• Experience with SQL Server administration or development
• Knowledge of T-SQL and database structures
• Familiarity with basic SQL Server configuration
Language:
• English course material and english speaking instructor
Course material:
The course fee includes course documentation and labs. Lunch and refreshments for in class events only.