SQL Server Performance Tuning – Fast Track (Online)

SQL Server Performance Tuning – Fast Track (Online)

Original price was: $198.00.Current price is: $99.00.

 

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 filling your inbox, or perhaps your boss assigned this to you after realizing that SQL Server performance troubleshooting is not his area of expertise. Regardless of the reason, the challenge is yours to identify, diagnose, and fix a variety of performance issues 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 less fire-fighting 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, 8-hour 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 six modules comprising more than 50 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 a PDF version of the content.

Category:

Description

Friendly TitleSQL Server Performance Tuning – Fast Track
Class TitleSQL Server Performance Tuning – Fast Track
TrainerAmit Bansal
Delivery TypeOnline. Read about our online delivery model.
Delivery FormatTotal 8 hours. 4 hours each day. Two consecutive days.
DateJanuary 28 & 29, 2026
Time8.30 am to 12.30 pm ET
(1.30 pm to 5.50 pm GMT | 7.00 pm to 11.00 pm IST)
RecordingsFull class recordings will be made available to the trainees (On-Demand Streaming). Lifetime access.Click Here.–>
Hands-OnTrainees can practice labs/demos along with the instructor or later, whatever is convenient. Training material will be shared with the participants closer to the class start date.
Price
Super Early Bird (until Dec 31): USD $79 (all inclusive)
Early Bird (Jan 1 to Jan 11): USD $89 (all inclusive)
Regular (Jan 12 to Jan 29): USD $99 (all inclusive)* Prices are subject to change without prior notice.
* No taxes. No payment gateway fees.
Cancellation PolicyA full refund will be made in case the Master Class is canceled by SQLMaestros. In case the trainee wishes to cancel their enrollment, 18% (GST Tax) + 5% internet fess will be forfeited and the remaining will be refunded. Refunds will be processed within ten working days.
Level
Pre-requisitesAt least one year of genuine working experience with SQL Server
Key Highlights
  • Most critical topics covered
  • 8 hours of deep practical content
  • LIVE attendance + Lifetime access to the recordings
  • Gain real-world knowledge, get real-world exposure.
  • Get your own copy of SQLMaestros course material + Scripts.
  • Packed with real-world demos and examples.
  • Apply your learning into production right away.
  • Course Completion Certificate (Digital).
  • Practice Labs/Demos at your own pace
CertificateRegistrants will receive a course completion certificate upon the conclusion of the class.
Course OutlineModule 1: Core Concepts

  • Query Lifecycle
  • Connections -> Sessions -> Requests -> Tasks -> Workers -> Threads
  • Common Wait Types in SQL Server, identification & diagnosis

MModule 2: The Foursome – CPU, Memory, IO & Tempdb

  • Identifying, troubleshooting & tuning workload patterns that cause excessive CPU
  • Identifying, troubleshooting & tuning workload patterns that cause excessive Memory Usage
  • Identifying, troubleshooting & tuning workload patterns that cause excessive IO
  • Identifying, troubleshooting & tuning workload patterns that cause excessive Tempdb usage

Module 3: Query Execution & Query Plan Analysis

  • Statistics & Cardinality Estimation
  • Reading & Analysing Execution Plans
  • Important Iterators

Module 4: Index Tuning

  • Demystifying Common Myths with Indexes
  • Indexing Strategies
  • Index Fragmentation
  • Real-World Index Tuning Examples

Module 5: Query Tuning

  • Rewriting Transact-SQL
  • Dealing with Implicit Conversions
  • Sargability
  • Solving Parameter Sniffing Issues
  • Parametrization Best Practices

Module 6: Dealing with Deadlocks

  • Common Deadlock Types
  • Deadlock Best Practices
  • Practical Deadlock Troubleshooting & Diagnosis

PS: The course content focuses on the core database engine concepts applicable to SQL Server versions from 2005 to 2025.

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.

Content missing

Title

Go to Top