Upcoming Master Classes
SQL Server Performance Tuning – Fast Track (Online)
8 hours. 4 hours per day. 2 Days. Online.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 issues that are 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.
| Friendly Title | SQL Server Performance Tuning – Fast Track |
| Class Title | SQL Server Performance Tuning – Fast Track |
| Trainer | Amit Bansal |
| Delivery Type | Online. Read about our online delivery model. |
| Delivery Format | Total Total 8 hours. 4 hours each day. Two consecutive days. |
| Date | 16 & 17 November (Tuesday & Wednesday) |
| Time | 09.30 am to 1.30 pm (EST). View in your own time zone. |
| Recordings | Full class recordings will be made available to the trainees (On-Demand Streaming). |
| Hands-On | Trainees can practice labs/demos along with the instructor or later, whatever is convenient. Training material will be shared with the participants beforehand. |
| Price | USD 149 USD 179 USD 199 * Group discounts available (write to classes@SQLMaestros.com) * Prices are subject to change without prior notice |
| Level | Intermediate to Advanced (Level 200 to 300) |
| Pre-requisites | At least two years of genuine working experience with SQL Server |
| Key Highlights |
|
| Course Outline | Module 1: Core Concepts
Connections -> Sessions -> Requests -> Tasks -> Workers -> Threads Common Wait Types in SQL Server, identification & diagnosis Module 2: The Foursome – CPU, Memory, IO & Tempdb
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
Reading & Analysing Execution Plans Important Iterators Module 4: Index Tuning
Indexing Strategies Index Fragmentation Real-World Index Tuning Examples Module 5: Query Tuning
Dealing with Implicit Conversions Sargability Solving Parameter Sniffing Issues Parametrization Best Practices Module 6: Dealing with Deadlocks
Deadlock Best Practices Practical Deadlock Troubleshooting & Diagnosis |
| 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 |
| FAQ | Click Here |
| Testimonials | Click Here |
SQL Server Performance Tuning Master Class (Online)
40 hours. 4 hours per day. 10 Days. Mon-Fri. Online.Have you ever been to Army-Training? When was the last time you had a brain-melting experience? Welcome to the most rigorous SQL training you ever had. This 40-hour course is designed to give you the right amount of internals and loads of practical tuning & optimization techniques that you can put into production right away. The course will be taught by Amit Bansal, Microsoft Certified Master of SQL Server. As part of the class, all participants will get a 1-year FREE subscription to SQLMaestros Video Courses.
| Friendly Title | SQL Server Performance Tuning |
| Class Title | SQL Server Internals, Troubleshooting & Performance Tuning |
| Trainer | Amit Bansal |
| Delivery Type | Online. Read about our online delivery model. |
| Delivery Format | Total 40 hours. 4 hours each day. Monday to Friday. Two consecutive weeks. |
| Date | 29 Nov to 03 Dec 2021
06 Dec to 10 Dec 2021 |
| Time | 10.30 am to 2.30 pm (Eastern Time US). View in your own time zone. |
| Recordings | Full class recordings will be made available to the trainees (On-Demand Streaming). |
| Hands-On | Trainees can practice labs/demos along with the instructor or later, whatever is convenient. Training material will be shared with the participants beforehand. |
| Price | USD 1499 USD 1699 USD 1899 USD 2099 * Group discounts available (write to classes@SQLMaestros.com) * Prices are subject to change without prior notice |
| Level | Advanced to Expert (Level 300 to 400) |
| Pre-requisites | At least two years of genuine working experience with SQL Server |
| Key Highlights |
|
| Course Outline | Module 1: SQL Server Architecture, Scheduling & Waits
Module 2: CPU Performance Monitoring & Tuning
Module 3: SQL Server Tempdb Internals & Tuning
Module 4: SQL Server I/O Internals & Tuning
Module 5: SQL Server Memory Internals & Troubleshooting
Module 6: Concurrency and Transactions
Module 7: Query Execution and Query Plan Analysis
Module 8: Statistics and Index Internals
Module 9: Query Tuning
Module 10: Index Tuning
Module 11: Plan Caching and Recompilation
Module 12: Extended Events
Module 13: Monitoring, Tracing and Baselining
Module 14: SQL Server New Features
|
| 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 |
| FAQ | Click Here |
| Testimonials | Click Here |
Master Class Recordings
SQL Server Performance Tuning – Fast Track (Class Recordings)
Recording duration: 8 hours12-months on-demand streaming access
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 issues that are 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.
| Friendly Title | SQL Server Performance Tuning – Fast Track |
| Class Title | SQL Server Performance Tuning – Fast Track |
| Trainer | Amit Bansal |
| Price | USD 99 * Group discounts available (write to classes@SQLMaestros.com) * Prices are subject to change without prior notice |
| Level | Intermediate to Advanced (Level 200 to 300) |
| Pre-requisites | At least two years of genuine working experience with SQL Server |
| Key Highlights |
|
| Course Outline | Module 1: Core Concepts
Connections -> Sessions -> Requests -> Tasks -> Workers -> Threads Common Wait Types in SQL Server, identification & diagnosis Module 2: The Foursome – CPU, Memory, IO & Tempdb
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
Reading & Analysing Execution Plans Important Iterators Module 4: Index Tuning
Indexing Strategies Index Fragmentation Real-World Index Tuning Examples Module 5: Query Tuning
Dealing with Implicit Conversions Sargability Solving Parameter Sniffing Issues Parametrization Best Practices Module 6: Dealing with Deadlocks
Deadlock Best Practices Practical Deadlock Troubleshooting & Diagnosis |
| 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 |
| FAQ | Click Here |
| Testimonials | Click Here |