SQL Server Performance Tuning Part 2

Resolving SQL Server performance tuning issues

4.42 (1977 reviews)

Udemy

platform

English

language

Databases

What you will learn

This is the second part of SQL Server performance tuning course; at the end of this course the student will be able to resolve and troubleshoot issues related index tuning, page splitting, tempb database sizing, recompilation of stored procedures, and much more with the use of tools and utilities such the performance monitor, DTA, DMVs, extended events, profiler and other tools.

Why take this course?

This course is designed for any student who has knowledge of SQL Administration and wants to learn about SQL Server performance tuning their SQL servers. You must have the prerequisite SQL performance tuning part 1 course.

This is the second part of SQL Server performance tuning course; at the end of this course the student will be able to resolve and troubleshoot issues related index tuning, page splitting, tempb database sizing, recompilation of stored procedures, and much more with the use of tools and utilities such the performance monitor, DTA, DMVs, extended events, profiler and other tools. This will allow you to have an optimum running SQL Server and an extensive knowledge of how to trouble shoot and resolve the more pressing issues you may face in your environment.

Reviews

Gertrude

January 16, 2024

The Course was well structured with all the needed information. it was insightful, informative, and well presented.

Shivesh

October 15, 2023

Good course for understanding the performance issues and how to monitor & resolve them for better performance.

Rajesh

June 27, 2023

demos should be more depth to get better understanding, i personally feel these videos are what is what but need more depth.

Mohamed

May 22, 2023

I enjoyed the course and learned a lot from it. The content is well organized and focused on practical examples and well-explained slides.

Felipe

May 10, 2023

Great course, a lot of practical examples. You can tell the instructor has a lot of knowledge in the subject. Probably the scripts should be tied to each video to make it easy, but not big deal.

Jeff

January 23, 2023

So far the instruction is easy to follow, take notes and test for. Having taken part one, I know what to expect from the course. The Instructor uses clear, easy to understand language for explaining topics.

Sonali

January 7, 2023

he needs to elaborate more on dmv,dbcc command used for performance tuning. need to get information long running query how to save in log file. how to release log file

Opendb

October 20, 2022

I like the way he teaches but the installation part of windows and sql server could have been excluded from this training as this should have been focused only on the performance

Lwanga

October 3, 2022

Too light concepts in each video. It's good if he merged these two into one and explained all in one video. It's useless splitting PLUS SOME OF THE RECOMMENDATIONS ARE MISSING!! Where are in-memory tables??

Venkannababu

September 16, 2022

Great explanation and examples...He gave Amazing teaching skills and techniques while explaining. .....it's really good for every dba's

Carlos

July 10, 2022

I would have liked the course to have more practical cases of solving problems that arise on sql server, it would be very useful

Rahul

February 9, 2022

Quite detailed explanation on all topics. Had Mr. Asghar suggested some of the websites for continuous upgrading knowledge it would have been even more amazing

Ashish

January 27, 2022

It was alright but I was hoping real time production scenarios and that would have made course Legendary.

Itumeleng

August 30, 2021

Better than getting a lecture from a book, however, lots of topics are not covered in detail and I sense that the provider doesn't have that deep knowledge, this is not to say the course is bad, but, there's few inconsistencies in lots of topics and if you have solid experience on sum of them, you'll pick up the inconsistencies quickly. If you are new to SQL Admin then this is a great course. I think its also beneficial to Intermediate DBA, just as a setup to explore the topics in greater detail. Thanks

Alberto

June 18, 2021

El curso esta genial ... se tocan los puntos realmente importantes de los problemas corporativos. Me esta gustando mucho. Hay topicos nuevos que sabia que existian pero no tenia idea. The course is great. Really awesome !!! Thanks, Raf.

Charts

Price

Rating

Enrollment distribution

SQL Server Performance Tuning Part 2 - Distribution chart