SQL Server Performance Tuning Part 1

Detail building blocks of SQL performance tuning

4.47 (5321 reviews)

Udemy

platform

English

language

Databases

What you will learn

At the end of this course, the student will have extensive knowledge in the following areas: Types of indexes that can affect performance, ability to read and understand the execution plans, determine the causes of wait stats, views deeply into statistics, comprehend the cause of the fill factor and page splits, view various execution modes and much much more

Loading charts...

Comidoc Review

Our Verdict

SQL Server Performance Tuning Part 1 provides extensive knowledge for DBAs and developers looking to learn fundamental principles and improve system performance. Despite minor criticisms regarding presentation style and dated materials, the course delivers valuable insights on SQL Server performance analysis tools. A follow-up advanced version addressing real-world challenges in cloud platforms like AWS and Azure is highly desirable.

What We Liked

Comprehensive coverage of SQL Server performance tuning fundamentals with extensive knowledge in various areas such as indexes, execution plans, wait stats, statistics, fill factor, and page splits.
Highly-rated course with an overall rating of 4.47, reflecting a positive learning experience for the majority of learners.
Actionable insights provided through real-world examples, SQL scripts, and case studies help developers improve their coding style for better system performance.
Dedicated course helping DBA's and developers understand performance tuning concepts with clear explanations and practical visual demonstrations.

Potential Drawbacks

Several students have remarked on the rushed presentation, suggesting that the instructor should slow down and provide more preparation before recording.
Some users noted a tendency to read from slides verbatim in later parts of the course, which affects engagement.
Course material is somewhat dated (created in 2017), potentially causing confusion whether to use outdated versions or remain up-to-date with modern technology.
A few students pointed out incorrect information provided throughout the course without appropriate updates reflecting these corrections.