Course Overview
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.
FAQ
FAQ area empty
Course curriculum
Chương 1 Introduction 41 bài · 7 giờ 36 phút
- PRE REQUISTES TO SQL SERVER PERFORMANCE TUNING PART 2 Học thử 3:20
- DOWNLOADING THE APPLICATIONS Học thử 13:32
- CREATING VM AND INSTALLING WINDOWS 2016 OS Học thử 12:33
- INSTALLING SQL 2017 Học thử 10:00
- INSTALLING SQL 2017 PART 2 Học thử 12:04
-
SQL SERVER VERSION COMPARISON 6:28
- PERFMOM Học thử 5:14
- PERFORMANCE COUNTERS Học thử 19:12
-
SAVING PERMON COUNTERS 8:05
-
DATA COLLECTION SET 10:00
-
DATA COLLECTION SET PART 2 12:47
-
ADDING ADVENTUREWORKS 2017 5:57
-
ANALYSIS OF METRICS 16:45
-
BASELINE CPU 14:33
-
SQL PROFILER 6:51
-
LIMIT PROFILER DATA 8:19
-
PERFMON AND PROFILER 8:56
-
EXTENDED EVENTS PART 1 10:00
-
EXTENDED EVENTS PART 2 10:36
-
EXTENDED EVENTS SESSION SCRIPT 9:45
-
FIND LONGEST RUNNING QUERY 8:17
-
DMVS 12:15
-
SETTING UP QUERY STORE 4:34
-
QUERY STORE 10:00
-
QUERY STORE PART 2 16:49
-
FORCED PLAN 10:00
-
FORCED PLAN PART 2 11:00
-
INDEXING AND FRAGMETATION 13:35
-
SQL AGENT JOB FOR INDEX AND OLA 10:00
-
SQL AGENT JOB FOR INDEX AND OLA PART 2 11:06
-
DTA INDEXING AND QUERY STORE 18:24
-
SOLVING RECOMPILATION 10:00
-
SOLVING COMPILATION PART 2 15:25
-
RESOVLING PAGE SPLITS PART 1 10:00
-
RESOVLING PAGE SPLITS PART 2 16:27
-
VIEWING PAGE SPLITS VIA EXTENDED EVENTS 8:46
-
RESOLVING BLOCKING ISSUES 16:13
-
TEMPDB PERFORMANCE 10:00
-
TEMPDB PERFORMANCE PART 2 10:41
-
DATABASE BACKUPS 9:17
-
WAIT STATS 18:02
Requirment
-
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
Outcomes
-
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.
0 Student
1 Course
0 review