SQL Server Performance Tuning Master Class (Online)
Trainer(s): Amit Bansal
Provider: SQLMaestros
Duration: 40 Hours
Subtitles: No
Price: USD 249 (Click Here for More Discount)
Date: 14 – 25 March
Type: Master Class
Subscription Period: Lifetime Access
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.
Modules
-
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
- Troubleshooting CPU Performance
- Identifying, troubleshooting & tuning workload patterns that cause excessive CPU
- Tempdb Internals
- Identifying, troubleshooting & tuning workload patterns that cause excessive Tempdb usage
- Core Concepts
- IO Setup and Testing
- SQL Server IO Patterns
- Identifying, troubleshooting & tuning workload patterns that cause excessive IO
- Windows Memory Internals
- SQL Server Memory Internals & Troubleshooting
- Identifying, troubleshooting & tuning workload patterns that cause excessive Memory Usage
- Concurrency and Transactions
- Locking Internals
- Troubleshooting Blocking Scenarios
- Troubleshooting Deadlocks
- Query Execution and Optimizer Internals
- Analyzing Query Plans
- Statistics Internals
- Cardinality Estimation Internals
- Index Internals
- 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
- Indexing Techniques
- Indexing Strategies
- Real World Index Tuning Examples
- Plan Cache Internals
- Troubleshooting Plan Cache Issues
- Extended Events core concepts
- Implementing Extended Events
- Tools & Techniques
- Monitoring and Tracing
- Baselining and Benchmarking
- New Tuning Features in Latest Versions of SQL Server
2. CPU Performance Monitoring & Tuning
3. SQL Server Tempdb Internals & Tuning
4. SQL Server I/O Internals & Tuning
5. SQL Server Memory Internals & Troubleshooting
6. Concurrency and Transactions
7. Query Execution and Query Plan Analysis
8. Statistics and Index Internals
9. Query Tuning
10. Index Tuning
11. Plan Caching and Recompilation
12. Extended Events
13. Monitoring, Tracing and Baselining
14. SQL Server New Features
Note: This recorded class is available in the format of a video course. Content is presented in modular videos. Learn more.