Exclusive Master Classes – For Organizations

Want these classes for a group of people? Drop an email to classes@SQLMaestros.com

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 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 Total 8 hours. 4 hours each day. Two consecutive days.
DateFor a corporate delivery of this class, drop an email to classes@SQLMaestros.com.
TimeFor a corporate delivery of this class, drop an email to classes@SQLMaestros.com.
RecordingsFull class recordings will be made available to the trainees (On-Demand Streaming).
Hands-OnTrainees can practice labs/demos along with the instructor or later, whatever is convenient. Training material will be shared with the participants beforehand.
Price

For a corporate delivery of this class, drop an email to classes@SQLMaestros.com.

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

* Prices are subject to change without prior notice

LevelBasic to Intermediate (Level 100 to 200)
Pre-requisitesAt least two years of genuine working experience with SQL Server
Key Highlights
  • Most critical topics covered.
  • 8 hours of deep practical content.
  • True level 200-300 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.
  • Course Completion Certificate (Digital).
  • Full Class Recordings will be available for 12 months on-demand subscription.
  • Practice Labs/Demos at your own pace
Course OutlineModule 1: Core Concepts

    Query Lifecycle
    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 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
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
FAQClick Here
TestimonialsClick 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 TitleSQL Server Performance Tuning
Class TitleSQL Server Internals, Troubleshooting & Performance Tuning
TrainerAmit Bansal
Delivery TypeOnline. Read about our online delivery model.
Delivery FormatTotal 40 hours. 4 hours each day. Monday to Friday. Two consecutive weeks.
DateFor a corporate delivery of this class, drop an email to classes@SQLMaestros.com.
TimeFor a corporate delivery of this class, drop an email to classes@SQLMaestros.com.
RecordingsFull class recordings will be made available to the trainees (On-Demand Streaming).
Hands-OnTrainees can practice labs/demos along with the instructor or later, whatever is convenient. Training material will be shared with the participants beforehand.
Price For a corporate delivery of this class, drop an email to classes@SQLMaestros.com.

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

* Prices are subject to change without prior notice

LevelAdvanced to Expert (Level 300 to 400)
Pre-requisitesAt least two years of genuine working experience with SQL Server
Key Highlights
  • Comprehensive & Advanced covering most important areas.
  • 40 hours of deep dive 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.
  • Course Completion Certificate (Digital).
  • Full Class Recordings will be available for 12 months on-demand subscription.
  • 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
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
FAQClick Here
TestimonialsClick Here

                                        

Master Class Recordings (For Individuals & Organizations)

SQL Server Query Tuning & Optimization (Class Recordings)

Recording duration: 28 hours
12-months on-demand streaming access

           Subscribe            
 

Friendly TitleSQL Server Query Tuning & Optimization
Class TitleSQL Server Query Tuning & Optimization
TrainerAmit Bansal
PriceUSD 399 799

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

* Prices are subject to change without prior notice

LevelIntermediate to Advanced (Level 200 to 300)
Pre-requisitesAt least two years of genuine working experience with SQL Server
Key Highlights
  • 12-months on-demand streaming access.
  • Most critical topics covered.
  • 28 hours of deep practical content.
  • True level 200-300 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
  1. SQL Server Execution Engine
  2. Query Lifecycle
  3. Plan Cache Internals
  4. Query Optimizer & Execution Plan
  5. Better TSQL – Query Tuning Fundamentals
  6. Better TSQL – Fixing Implicit Conversion
  7. Better TSQL – Sargability
  8. Better TSQL – Rewriting Subqueries
  9. Better TSQL – OVER clause
  10. Better TSQL – Temp Tables vs Table Variables
  11. Better TSQL – Working with NULLs
  12. Better TSQL – Common Table Expression
  13. Better TSQL – Rewriting Scalar UDFs
  14. Better TSQL – TVFs Basics
  15. Better TSQL – TVFs with APPLY
  16. Better TSQL – Ranking Functions
  17. Better TSQL – Dealing with SORTs
  18. Better TSQL – Optimizing OR
  19. Better TSQL – Fixing Bookmark Lookups
  20. Better TSQL – Cardinality Fix
  21. Better TSQL – Pivoting
  22. Better TSQL – Stats
  23. Better TSQL – Aggregations
  24. Better TSQL – Joins
  25. Better TSQL – NOLOCK
  26. Better TSQL – INEQUALITY
  27. Better TSQL – Complex Expressions
  28. Better TSQL – Fuzzy String Matching
  29. Better TSQL – Things you may not know
  30. Index Tuning – Index Basics
  31. Index Tuning – Page Splits
  32. Index Tuning – Fragmentation
  33. Index Tuning – Dynamic Index Seek
  34. Index Tuning – Index Union
  35. Index Tuning – Index Intersection
  36. Index Tuning – Fragmentation Part 2
  37. Index Tuning – Indexing for AND & OR
  38. Index Tuning – Index Aggregates
  39. Index Tuning – Indexing for Joins
  40. Index Tuning – SARGability
  41. Index Tuning – Multi Column Seek
  42. Index Tuning – Multi Column Indexes
  43. Index Tuning – Missing and Unused Indexes
  44. Index Tuning – Redundant Indexes
  45. Index Tuning – Clustering Key Choices
  46. Stored Procedures – Parameter Sniffing
  47. Dynamic SQL
  48. Waits and Queues – Introduction
  49. Waits and Queues – PAGEIOLATCH
  50. Waits and Queues – CXPACKET and PARALLELISM
  51. Waits and Queues – RESOURCE SEMAPHORE
  52. Waits and Queues – THREADPOOL
  53. Waits and Queues – BUFFERLATCH
  54. Waits and Queues – SOS_SCHEDULER_YIELD
  55. Concurrency
  56. Deadlocks
  57. Waits and Queues – EXTENDED Events
  58. Automatic Tuning
  59. Intelligent Query Processing – Adaptive Joins
  60. Intelligent Query Processing – Batch Mode On Row Store
  61. Intelligent Query Processing – Interleaved Execution
  62. Intelligent Query Processing – Memory Grant Feedback
  63. Intelligent Query Processing – Scalar UDF Lining
  64. Intelligent Query Processing – Table Variable Deferred Compilation
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
FAQClick Here
TestimonialsClick Here

                                        

             Subscribe             

SQL Server Performance Tuning – Fast Track (Class Recordings)

Recording duration: 8 hours
12-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.

           Subscribe            
 

Friendly TitleSQL Server Performance Tuning – Fast Track
Class TitleSQL Server Performance Tuning – Fast Track
TrainerAmit Bansal
PriceUSD 99 199 (use Discount Code: RECORD50)

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

* Prices are subject to change without prior notice

LevelIntermediate to Advanced (Level 200 to 300)
Pre-requisitesAt least two years of genuine working experience with SQL Server
Key Highlights
  • 12-months on-demand streaming access.
  • Most critical topics covered.
  • 8 hours of deep practical content.
  • True level 200-300 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: Core Concepts

    Query Lifecycle
    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 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
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
FAQClick Here
TestimonialsClick Here

                                        

             Subscribe