SQL Server Performance Tuning Course

Boost Your SQL Server Performance with Expert Guidance!

In this video, Steve Stedman from Stedman Solutions introduces his comprehensive SQL Server Performance Tuning course. Learn essential techniques to optimize your SQL Server, enhance query performance, and ensure efficient database management. Perfect for DBAs and IT professionals, this course covers everything from indexing strategies to performance monitoring. Enroll today and transform your SQL Server skills: https://stedman.us/performance-class.

Watch this video by Steve Stedman to find out more.

For additional informative videos, visit my YouTube channel at https://www.youtube.com/@SteveStedman. There, you’ll find a wide range of content covering various topics, all designed to provide valuable insights and help you stay informed.

Course Overview:

This comprehensive SQL Server Performance Tuning course is tailored to equip database professionals with the knowledge and tools necessary to optimize SQL Server performance.

Significance of Performance Tuning:

The course kicks off by emphasizing the significance of performance tuning, not only for enhancing system efficiency but also as a means to reduce licensing costs. Participants will delve deep into the intricacies of query optimization, exploring the nuances of execution plans, sargability, and identifying code ‘smells’ that hinder performance.

Course Instructor – Steve Stedman:

With over 34 years of SQL Server experience, Steve Stedman leads this course with contributions from other team members. Steve shares his extensive expertise, ensuring that students can reach out through his Mentoring program for additional help or details. The course is filled with practical insights Steve has gathered from real-world performance tuning issues.

Key Topics Covered:

Database Design Principles: Learn about data type selection, normalization, denormalization, and table partitioning.
Indexing Strategies: Discover best practices for index types, design, and maintenance.
Performance Monitoring Techniques: Gain insights into using Database Health Monitor, DMVs, and analyzing wait and query execution statistics.
Isolation Levels: Understand the various isolation strategies in SQL Server, their applications, and implications.

Example Curriculum:

Course Introduction:
- Welcome and Overview
- Why Performance Tuning is Important
- Reducing Licensing Costs with Performance Tuning
Query Optimization:
- Execution Plan Overview
- Introduction to Execution Plans Presentation
- Viewing Execution Plans
- Execution Plan Operator Details
- Statistics IO and Statistics Time
Sargability:
- What is Sargability?
- Sargability Demo