SQL Server Performance Tuning Master Class Recordings

SQL Server Performance Tuning Master Class RecordingsSQLMaestros Admin2026-03-26T10:46:23+05:30

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

Recording duration: 40 hours
On-demand lifetime streaming access

Friendly Title	SQL Server Performance Tuning Master Class
Class Title	SQL Server Query Internals, Troubleshooting & Performance Tuning
Trainer	Amit Bansal
Price	Regular Price USD ~~1499~~ (New price USD 649) * Group discounts available (write to contact@SQLMaestros.com) * Prices are subject to change without prior notice
Access	On-demand lifetime streaming access
Level	Advanced to Expert (Level 300 to 400)
Pre-requisites	At 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 Outline	Module 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 Bio	Amit 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 Details	classes@SQLMaestros.com
Testimonials (Dec 2023 Batch)	Click Here
Video Testimonial (Dec 2023 Batch)
General Testimonials	Click Here
Additional Info	SQL Server Internals, Troubleshooting & Performance Tuning Master Class Recordings (40 hours) is not part of any bundle/package. It is an exclusive offering.

Title