SQL Server Internals, Troubleshooting & Performance Tuning (Class Recordings) (Dec 2023 Batch)

Recording duration: 40 hours
On-demand lifetime streaming access


Friendly TitleSQL Server Performance Tuning Master Class
Class TitleSQL Server Query Internals, Troubleshooting & Performance Tuning
TrainerAmit Bansal
PriceRegular Price USD 1299
Want discounts?
Use HAPPY60 discount code to get 60% off. New price: USD 519.
(this is an introductory price offer available only for the first few bookings)
(apply the coupon code in the cart)

* GST + Internet Transaction Fee additional

* Group discounts available (write to classes@SQLMaestros.com)

* Prices are subject to change without prior notice

AccessOn-demand lifetime streaming access
LevelAdvanced to Expert (Level 300 to 400)
Pre-requisitesAt least two years of genuine working experience with SQL Server
Key Highlights
  • On-demand lifetime streaming access.
  • Comprehensive coverage with deep-dive content (Breadth & Depth).
  • 40 hours of real-world, practical learning.
  • True level 300-400 content.
  • 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.
  • Practice Labs/Demos at your own pace
Course OutlineModule 1: SQL Server Architecture, Scheduling & Waits

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

Module 2: CPU Performance Monitoring & Tuning

  • Troubleshooting CPU Performance
  • Identifying, troubleshooting & tuning workload patterns that cause excessive CPU

Module 3: SQL Server Tempdb Internals & Tuning

  • Tempdb Internals
  • Identifying, troubleshooting & tuning workload patterns that cause excessive Tempdb usage

Module 4: SQL Server I/O Internals & Tuning

  • Core Concepts
  • IO Setup and Testing
  • SQL Server IO Patterns
  • Identifying, troubleshooting & tuning workload patterns that cause excessive IO

Module 5: SQL Server Memory Internals & Troubleshooting

  • Windows Memory Internals
  • SQL Server Memory Internals & Troubleshooting
  • Identifying, troubleshooting & tuning workload patterns that cause excessive Memory Usage

Module 6: Concurrency and Transactions

  • Concurrency and Transactions
  • Locking Internals
  • Troubleshooting Blocking Scenarios
  • Troubleshooting Deadlocks

Module 7: Query Execution and Query Plan Analysis

  • Query Execution and Optimizer Internals
  • Analyzing Query Plans

Module 8: Statistics and Index Internals

  • Statistics Internals
  • Cardinality Estimation Internals
  • Index Internals

Module 9: Query Tuning

  • Understanding common patterns & antipatterns
  • Troubleshooting Slow Running Queries
  • Identify Plan Quality Issues
  • Optimizing T-SQL code/Rewriting
  • Optimizing Stored Procedures
  • Real-World Query Tuning Examples

Module 10: Index Tuning

  • Indexing Techniques
  • Indexing Strategies
  • Real World Index Tuning Examples

Module 11: Plan Caching and Recompilation

  • Plan Cache Internals
  • Troubleshooting Plan Cache Issues

Module 12: Extended Events

  • Extended Events core concepts
  • Implementing Extended Events

Module 13: Monitoring, Tracing and Baselining

  • Tools & Techniques
  • Monitoring and Tracing
  • Baselining and Benchmarking

Module 14: SQL Server New Features

  • New Tuning Features in Latest Versions of SQL Server
Sample Content
Trainer’s BioAmit R S Bansal is a SQL Server Specialist at SQLMaestros (brand of eDominer Systems). He leads the SQL and BI practice with a much-focused team providing consulting, training and content development services to more than 160+ SQL customers globally. He frequently speaks at international conferences including Data Platform Summit, MS Ignite (US), SQLBits (UK), PASS Summit (US) & SQL Saturday events across the globe. Amit is also honored with Microsoft Regional Director status, MVP award and Microsoft Certified Master of SQL Server credential. Amit has been working with SQL Server since 1999 and has been part of countless mission critical SQL deployments. Performance Tuning in SQL Server is his core area of expertise. His videos are available on YouTube. To learn more about Amit, Click Here
SQLMaestros Contact Detailsclasses@SQLMaestros.com
Testimonials (Dec 2023 Batch)Click Here
Video Testimonial (Dec 2023 Batch)
General TestimonialsClick Here