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

Join this demo-filled, full-day class, 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
Learn how to benchmark and baseline (and also take away a framework, ready-to-use)
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 6 query tuning techniques that will solve 75% of performance issues (real-world query tuning)
Top 3 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 five modules comprising of more than 55 demos, all from the real-world. Yes, a lot of content and the class will be fast-paced. The pre-con will focus on recent versions of SQL Server. All demos will be shown on SQL Server 2019. You will walk away with all the demo scripts, most of them being production-ready. You will also get PDF version of the content.

The class will end with a “Performance Tuning Online Quiz” and will help you measure yourself. The ones who score 100% will receive one-year complimentary access to Amit Bansal’s SQL Server Performance Tuning Fast Track Video Course.

Pre-requisite: You need to have at least two years of genuine SQL Server experience to gain maximum from this pre-con

Length of the workshop:

Full day (8 hours)

Key takeaways

Summary
Join the demo-filled, full-day class, to learn SQL Server performance troubleshooting & tuning, the practical way, with 55 demos from the real world.

Goal 1
Learn to develop a performance troubleshooting methodology for the real-world along with benchmarking and baselining (and also take away a framework, ready-to-use scripts with sample data).

Goal 2
Learn proactive, reactive and real-time troubleshooting techniques to fix performance issues related to CPU, Memory, IO, Tempdb & Blocking. Learn to make a perfect blend of tools at your disposal including DMVs, Perfmon Counters & Extended Events.

Goal 3
Learn query and index tuning techniques by understanding what kind of code is loved by SQL Server Optimizer and the choices it makes while selecting an index to speed up data access.

Aby włączyć obsługę czytnika ekranu, naciśnij Ctrl+Alt+Z. Aby uzyskać informacje o skrótach klawiszowych, naciśnij Ctrl+ukośnik.

Form of the workshop

Lecture (slides + demos)

What attendees need to prepare?

NA

Level

300