SQL Server Performance Tuning Part 2

SQL Server Performance Tuning Part 2, available at $59.99, has an average rating of 4.51, with 41 lectures, based on 2172 reviews, and has 11836 subscribers.

You will learn about 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 course is ideal for individuals who are 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 It is particularly useful 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.

Enroll now: SQL Server Performance Tuning Part 2

Summary

Title: SQL Server Performance Tuning Part 2

Price: $59.99

Average Rating: 4.51

Number of Lectures: 41

Number of Published Lectures: 41

Number of Curriculum Items: 41

Number of Published Curriculum Objects: 41

Original Price: $19.99

Quality Status: approved

Status: Live

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.

Who Should Attend

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

Target Audiences

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

Course Curriculum

Chapter 1: Introduction

Lecture 1: PRE REQUISTES TO SQL SERVER PERFORMANCE TUNING PART 2

Lecture 2: DOWNLOADING THE APPLICATIONS

Lecture 3: CREATING VM AND INSTALLING WINDOWS 2016 OS

Lecture 4: INSTALLING SQL 2017

Lecture 5: INSTALLING SQL 2017 PART 2

Lecture 6: SQL SERVER VERSION COMPARISON

Lecture 7: PERFMOM

Lecture 8: PERFORMANCE COUNTERS

Lecture 9: SAVING PERMON COUNTERS

Lecture 10: DATA COLLECTION SET

Lecture 11: DATA COLLECTION SET PART 2

Lecture 12: ADDING ADVENTUREWORKS 2017

Lecture 13: ANALYSIS OF METRICS

Lecture 14: BASELINE CPU

Lecture 15: SQL PROFILER

Lecture 16: LIMIT PROFILER DATA

Lecture 17: PERFMON AND PROFILER

Lecture 18: EXTENDED EVENTS PART 1

Lecture 19: EXTENDED EVENTS PART 2

Lecture 20: EXTENDED EVENTS SESSION SCRIPT

Lecture 21: FIND LONGEST RUNNING QUERY

Lecture 22: DMVS

Lecture 23: SETTING UP QUERY STORE

Lecture 24: QUERY STORE

Lecture 25: QUERY STORE PART 2

Lecture 26: FORCED PLAN

Lecture 27: FORCED PLAN PART 2

Lecture 28: INDEXING AND FRAGMETATION

Lecture 29: SQL AGENT JOB FOR INDEX AND OLA

Lecture 30: SQL AGENT JOB FOR INDEX AND OLA PART 2

Lecture 31: DTA INDEXING AND QUERY STORE

Lecture 32: SOLVING RECOMPILATION

Lecture 33: SOLVING COMPILATION PART 2

Lecture 34: RESOVLING PAGE SPLITS PART 1

Lecture 35: RESOVLING PAGE SPLITS PART 2

Lecture 36: VIEWING PAGE SPLITS VIA EXTENDED EVENTS

Lecture 37: RESOLVING BLOCKING ISSUES

Lecture 38: TEMPDB PERFORMANCE

Lecture 39: TEMPDB PERFORMANCE PART 2

Lecture 40: DATABASE BACKUPS

Lecture 41: WAIT STATS

Instructors

Raphael Asghar
Production SQL Database Administrator

Rating Distribution

1 stars: 24 votes
2 stars: 36 votes
3 stars: 240 votes
4 stars: 832 votes
5 stars: 1042 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu