SQL Server Performance Tuning Part 2
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.
Course content
- Preview03:20
- Preview13:32
- 12:33CREATING VM AND INSTALLING WINDOWS 2016 OS
- 10:00INSTALLING SQL 2017
- 12:04INSTALLING SQL 2017 PART 2
- 06:28SQL SERVER VERSION COMPARISON
- 05:14PERFMOM
- 19:12PERFORMANCE COUNTERS
- 08:05SAVING PERMON COUNTERS
- 10:00DATA COLLECTION SET
- 12:47DATA COLLECTION SET PART 2
- 05:57ADDING ADVENTUREWORKS 2017
- 16:45ANALYSIS OF METRICS
- 14:33BASELINE CPU
- 06:51SQL PROFILER
- 08:19LIMIT PROFILER DATA
- 08:56PERFMON AND PROFILER
- 10:00EXTENDED EVENTS PART 1
- 10:36EXTENDED EVENTS PART 2
- 09:45EXTENDED EVENTS SESSION SCRIPT
- 08:17FIND LONGEST RUNNING QUERY
- 12:15DMVS
- 04:34SETTING UP QUERY STORE
- 10:00QUERY STORE
- 16:49QUERY STORE PART 2
- 10:00FORCED PLAN
- 11:00FORCED PLAN PART 2
- 13:35INDEXING AND FRAGMETATION
- 10:00SQL AGENT JOB FOR INDEX AND OLA
- 11:06SQL AGENT JOB FOR INDEX AND OLA PART 2
- 18:24DTA INDEXING AND QUERY STORE
- 10:00SOLVING RECOMPILATION
- 15:25SOLVING COMPILATION PART 2
- 10:00RESOVLING PAGE SPLITS PART 1
- 16:27RESOVLING PAGE SPLITS PART 2
- 08:46VIEWING PAGE SPLITS VIA EXTENDED EVENTS
- 16:13RESOLVING BLOCKING ISSUES
- 10:00TEMPDB PERFORMANCE
- 10:41TEMPDB PERFORMANCE PART 2
- 09:17DATABASE BACKUPS
- 18:02WAIT STATS
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
Instructor
![Raphael Asghar](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.5 Instructor Rating
- 18,751 Reviews
- 111,764 Students
- 25 Courses
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.