Sql Server Performance Tuning Part 2

  1. Home
  2. Sql-server
  3. Sql Server Performance Tuning Part 2

Tags: SQL Server

Resolving SQL Server performance tuning issues

Last updated 2022-01-10 | 4.5

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

What you'll 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.

* Requirements

* SQL performance tuning part 2 requires that you MUST have SQL performance tuning part 1 course and SQL administration part 1
* 2
* 3 as well as Learn T-SQL courses. All SQL Server application
* Virtual Box application and Windows 2016 operating system will be available as a trail period for 6 months via downloads

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.

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

Course content

1 sections • 41 lectures

Introduction 41 lectures

PRE REQUISTES TO SQL SERVER PERFORMANCE TUNING PART 2 Preview 03:20

DOWNLOADING THE APPLICATIONS Preview 13:32

CREATING VM AND INSTALLING WINDOWS 2016 OS Preview 12:33

INSTALLING SQL 2017 Preview 10:00

INSTALLING SQL 2017 PART 2 Preview 12:04

SQL SERVER VERSION COMPARISON Preview 06:28

PERFMOM Preview 05:14

PERFORMANCE COUNTERS Preview 19:12

SAVING PERMON COUNTERS Preview 08:05

DATA COLLECTION SET Preview 10:00

DATA COLLECTION SET PART 2 Preview 12:47

ADDING ADVENTUREWORKS 2017 Preview 05:57

ANALYSIS OF METRICS Preview 16:45

BASELINE CPU Preview 14:33

SQL PROFILER Preview 06:51

LIMIT PROFILER DATA Preview 08:19

PERFMON AND PROFILER Preview 08:56

EXTENDED EVENTS PART 1 Preview 10:00

EXTENDED EVENTS PART 2 Preview 10:36

EXTENDED EVENTS SESSION SCRIPT Preview 09:45

FIND LONGEST RUNNING QUERY Preview 08:17

DMVS Preview 12:15

SETTING UP QUERY STORE Preview 04:34

QUERY STORE Preview 10:00

QUERY STORE PART 2 Preview 16:49

FORCED PLAN Preview 10:00

FORCED PLAN PART 2 Preview 11:00

INDEXING AND FRAGMETATION Preview 13:35

SQL AGENT JOB FOR INDEX AND OLA Preview 10:00

SQL AGENT JOB FOR INDEX AND OLA PART 2 Preview 11:06

DTA INDEXING AND QUERY STORE Preview 18:24

SOLVING RECOMPILATION Preview 10:00

SOLVING COMPILATION PART 2 Preview 15:25

RESOVLING PAGE SPLITS PART 1 Preview 10:00

RESOVLING PAGE SPLITS PART 2 Preview 16:27

VIEWING PAGE SPLITS VIA EXTENDED EVENTS Preview 08:46

RESOLVING BLOCKING ISSUES Preview 16:13

TEMPDB PERFORMANCE Preview 10:00

TEMPDB PERFORMANCE PART 2 Preview 10:41

DATABASE BACKUPS Preview 09:17

WAIT STATS Preview 18:02