SQL Server Performance Tuning Part 2 (Udemy.com)

Resolving SQL Server performance tuning issues

( 29 Reviews )

Created by: Raphael Asghar

Produced in 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.

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 86 / 100

Course Description

This course is designed for any student who has knowledge ofSQL Administration and wants to learn about SQL Server performance tuning theirSQL servers. You must have the prerequisiteSQL performance tuning part 1 course.
This is the second part of SQL Server performance tuningcourse; at the end of this course the student will be able to resolve and troubleshootissues related index tuning, page splitting, tempb database sizing,recompilation of stored procedures, and much more with the use of tools andutilities such the performance monitor, DTA, DMVs, extended events, profilerand other tools. This will allow you tohave an optimum running SQL Server and an extensive knowledge of how to troubleshoot and resolve the more pressing issues you may face in your environment.
Who this course is 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

Time: 7.5h

Instructor Details

Raphael Asghar

4.3 Rating
29 Reviews

Worked as a Production SQL Database Administrator for over 12 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.

SQL in Motion (2017)

0.0 (0 Reviews)

Provider: Manning Publications
Time: 4h

$59.99

Introduction to SQL (2015)

4.7 (6 Reviews)

Provider: SQLBolt

Free

Intro to SQL: Querying and managing data

Intro to SQL: Querying and managing data (2015)

0.0 (0 Reviews)

Provider: Khan Academy
Time: 1h

Free

More Courses

More courses by Raphael Asghar

SQL Server Administration Part1 (2021)
4.6 (351 Reviews)

- Provider: Udemy
- Time: 10h

$11.99

Learn T-SQL From Scratch For SQL Server Administrator

Learn T-SQL From Scratch For SQL Server Administrator (2018)
4.6 (337 Reviews)

- Provider: Udemy
- Time: 7.5h

$11.99

SQL Server Performance Tuning Part 1 (2017)
4.4 (265 Reviews)

- Provider: Udemy
- Time: 6h

$11.99

SQL Server Migration and Upgrade Process

SQL Server Migration and Upgrade Process (2017)
4.5 (33 Reviews)

- Provider: Udemy
- Time: 7h

$11.99

SQL Server 2016 Administration (2017)
4.7 (28 Reviews)

- Provider: Udemy
- Time: 6.5h

$11.99

All courses by Raphael Asghar

Reviews

4.3

29 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Gaurav Shrivastava

Awesome

By Alex Sharifian

Great Tutorial

By Rajesh Singh

Excellent one. Looking for SQL Server 2017.

By Joshua Ehiguese

great info

By Qc It

All are basic details..

By Naman Pratyush

Perfect course for me, fan of the tutor.

By Jayasree k

every nice info

By Chandan Gupta

The content and explaination is really beneficial.

By Ricardo Brillembourg

It covers a lot of topics and provides a solid foundation for SQL performance tuning.

By Newbie Agbon

Very helpful in understanding some complex issues in Performance Tuning and solutions in resolving them.

By Orlando Fabian Brea

Dividing the course in 2 parts was useless. The second part is almost the same as the first, with just a couple of extras (but the same concepts and some explanations are made in both parts). Many examples are biased, the way indexes are created (for example).

By Prayag Rao Dhaple

Course is nicely designed, having lot of information applicable to real world.

But it would be great if Raphael will add more details about wait stats and how to resolve them.