SQL Server Performance Tuning Part 2 (Udemy.com)
Resolving SQL Server performance tuning issues
Created by: Raphael Asghar
Last updated May 2018
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.
How it compares
Against the other 388 rated Udemy courses in SQL on CourseDuck:
- Rating4.6 out of 5higher than 69% of them
- Reviews2,801#72 of 389 by number of reviews
- Length7.6 hourslonger than 58% of them
- Last updatedMay 2018earlier than 79% of them
Course Description
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.
Instructor Details
- 4.6 Rating
2,801 Reviews
Raphael Asghar
Worked as a Production SQL Database Administrator and developer for over 15 years for various companies such as Neutrogena, BakeMark, Solutions2Go and NextGen. Want to help those students that want more that the basic SQL Language. Creating real life courses for those students who want a simple path to becoming a SQL DBA. I love SQL Administration and all that is involved in managing and creating a stable SQL architecture environment. I want to pass that experience and information to my students.
More courses by Raphael Asghar
Learn T-SQL From Scratch For SQL Server Administrator (2020)
4.6 (2,904 Reviews)
Provider: Udemy
Time: 8.7h
$10.99
SQL Server Reporting Services Part 1 (SSRS) (2017)
4.6 (2,497 Reviews)
Provider: Udemy
Time: 6.1h
$69.99
Reviews
By Paul Williams on 4/12/2026
Course was good coverage. I wish for a more advanced one that when deeper into a few of the subjects, like waits is a preview of sorts, so would like a more advance version covering some of this course in much greater detail. Overall though, I got a lot out of this, and everything worked. Also, rather than going through all the hassle of setting up SQL on your local machine, you would be better off creating a VM in Azure or AWS and using that instead. You can configure the VMs to shut down after a period of inactivity or at a certain time of day to prevent you from racking up a bill and save money by having the VM turn off when you are not using it. You can use the Developer Edition of SQL Server which is free and will help keep the costs down and has all the features of Enterprise Edition. Recommendation is to do the whole course (including Part 1) on with 2017 or later.
By Mustafa Safielnuor Mohamed Hassan on 12/3/2025
Mr Rafa is always amazing in teaching and explainations and he is the my go-to when it comes to MS SQL server. three requests wish to be added as update for performance tuning and migration: 1-as a regular student i wish to get the link to your website as I couldn't get it from goggle page. 2-more examples in perf tuning in figure out what causing slowness 3- migrate with Always on availability groups
By Matu Saye on 10/13/2025
Great, really well-organized course with valuable information. My only concern is the font size in the videos—it’s a bit small and a little difficult to read when I have the video window and my work window open side by side. I wish the font were a bit larger. Other than that, an excellent course.
By Jamshed Puyyakara on 7/15/2025
Comprehensive course that covers major database performance issues and troubleshooting techniques. Simple, easy-to-understand examples that demonstrate real-world scenarios.
By Jay Pedersen on 9/25/2020
Bottom line: at the end of the course, you will have a very solid idea of the available performance analysis tools provided by MS for SQL Server and will have seen solid descriptions of them and demonstrations on how to use all of them. You are also given tips that help you go beyond what is explicitly taught to take yourself to the expert level. Thanks!
By Silas Fernando da Silva on 3/2/2020
It's a awesome course. It's full of solid content. It's easy to understand because the teacher apply a lot of examples. I did some courses of this teacher and I will do the others. It's very very very helpfull. I recommend this course. Teacher, thanks for share your knowlegde.
By sayed Hoque on 8/31/2019
Wonderful explanation. Since Power Shell is an integral part of SQL Server, it is imperative to learn Power Shell. Lots of courses on Power Shell on Udemy but nothing from Raphael Asghar. Hopefully he will upload a tutorial on Power Shell immediately.
By Vikas on 9/26/2018
Good thing about Raphael Asghar is that he is very practical and doesn't really try to hide something which he would not know and tries to make the course understandable for beginner to mid level DBA's. The course is not so advanced, probably good for beginners or mid level DBA's.
By Piotr Panczyk on 8/18/2018
As always great job Raf. I really enjoyed the course. I really like the parts regarding: Solving complilation 1 and 2, page splitting, blocking issues. Really good job with TempDB and especially with Wait Stats. I have learnt a lot Yes, you are right. We need to practice and practice !!!
By Sukhroop Singh on 5/29/2018
I took Raphael all the courses and learned a lot . I am now a certified SQL-Server dba and I was able to crack interview comfortably. All you need to do is watch and practice. The practice is key for your success but Raphael is the best for SQL-Server.
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 92 / 100









