SQL Server Performance Tuning Fast Track – Video Course

Description

One fine day you realize that you have to start tuning SQL Server for better performance. The need might have arisen from a recent performance issue, or the barrage of support tickets that are filling your inbox, or maybe your boss assigned this to you after realizing that SQL Server performance troubleshooting is not his cup of tea. Irrespective of the reason, the challenge is upon you to identify, diagnose and fix a variety of performance issue that is plaguing your SQL Server environment.

Performance troubleshooting can be categorized as proactive, real-time & reactive. If a well-defined methodology is followed during the proactive phase, you will have to fire-fight less during the real-time troubleshooting phase and you will have a lot of meaningful performance data to work within the reactive phase, which will further help you in preventing performance cases.

Subscribe to this demo-packed video course, where you will learn the three approaches of SQL Server performance troubleshooting & tuning. You will learn the practical way, exactly like how you would troubleshoot in the real world with lots of code and scripts. Amongst many takeaways, here are some interesting ones:

• Develop a performance troubleshooting methodology for the real-world
• Analyzing and troubleshooting common wait types
• Proactive, reactive and real-time CPU troubleshooting
• Troubleshooting IO performance bottlenecks
• Tracking SQL Server memory consumption and fixing OOM errors
• Dealing with Tempdb madness
• Top six query tuning techniques that will solve 75% of performance issues (real-world query tuning)
• Top six indexing strategies that will fix 60% indexing woes
• Get rid of deadlocks (yes, you hear it right)
• SQL Server 2019 performance enhancements

In total, there will be six modules comprising of close to 50 demos, all from the real-world. Yes, a lot of content and well-paced. You will get all the demo scripts, most of them being production-ready. You will also get PDF version of the content.

Instructor: Amit R S Bansal

Total Duration: 15 hours 12 Mins

Total Lecture Time: 5 hrs 43 mins

Total Demo Time: 9 hrs 29 mins

Level: Intermediate to Advanced (Level 200 to 300)

Delivery Format: Video Course. Stream anywhere, anytime, any device, as many times.

Pre-Requisite: You need to have at least one year of genuine SQL Server experience to gain maximum from this course

Course Outline

Module 0: Introduction

• Before You Begin
• Modules
• Demo Setup
• What Not To Expect
• What To Expect
• How To Get The Best Out Of This Course

Module 1: Performance Troubleshooting Methodology

• Where Shall I Begin?
• An Ocean Within An Ocean
• Installation & Configuration Best Practices
• Performance Monitoring, Benchmarking & Baselining
• Developing a Performance Troubleshooting Methodology
• Tools & Utilities
• Demos
• Summary

Module 2: Wait Statistics

• Query Execution
• Waiting & Queuing
• Putting It Together
• Working With Wait Stats
• Common Wait Types
• System Wait Types
• PAGEIOLATCH Wait Type
• CXPACKET Wait Type
• ASYNC_NETWORK_IO Wait Type
• RESOURCE_SEMAPHORE Wait Type
• Demos
• Summary

Module 3: The Awesome Foursome – CPU, Memory, IO, Tempdb

• A Classic Example
• CPU Troubleshooting
• Memory Troubleshooting
• IO Troubleshooting
• Tempdb Troubleshooting
• Demos
• Summary

Module 4: Query Tuning

• Understanding Execution Plan
• Statistics & Cardinality Estimation
• Query Tuning
• The Bad Bookmark Lookups
• Expensive Sorts
• Implicit Conversion
• Non-SARGability
• Stale Statistics
• Parameter Sniffing
• Re-Writing T-SQL
• Query Store (SQL 2016)
• Automatic Query Tuning (SQL 2017)
• Intelligent Query Processing (SQL 2017 & 2019)
• Demos
• Summary

Module 5: Index Tuning

• Indexing Architecture
• Index Fragmentation
• Indexing Guidelines
• Index Tuning
• Identifying Missing Indexes
• Identifying Unused Indexes
• Demos
• Summary

Module 6: Concurrency Troubleshooting

• Data Modification & Concurrency Architecture
• Isolation Levels
• Troubleshooting Blocking
• Best Practices
• Troubleshooting Deadlocks
• Best Practices
• Demos
• Summary

Module 7: Wrap Up