SQL Server Performance Tuning (In-Person)
Have you ever been to Army-Training? When was the last time you had a brain-melting experience? Welcome to the most rigorous 8-hour SQL training you ever had. This Accelerator is 100% demo-oriented and 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 SQL Server Performance Tuning Accelerator will be delivered by Amit Bansal, Microsoft Certified Master of SQL Server & 11 times Microsoft’s Most Valuable Professional awardee
| Course Code | PI_SQL_101_A | ||||||||
| Course Title | SQL Server Performance Tuning | ||||||||
| Course Brochure | Download  | ||||||||
| Delivery Format & Location | In-Person (Classroom-based), Bangalore. | ||||||||
| Date, Time & Duration | December 1, 2017, 8 hours Timings: 9 am to 6 pm with one-hour of lunch break | ||||||||
| List Price |
Note:
* Prices in USD are applicable ONLY for international participants registering and/or planning to join the class from outside India. * There will be an additional service charge of 4% for online payment (using debit/credit card) * There are group discounts available. Reach out to the team for updated offers. | ||||||||
| Level | Level 300 – 400 (Intermediate to Advanced) | ||||||||
| Target Audience | This course is intended for SQL Server Database Administrators, SQL Database Engineers, SQL Developers & SQL Architects. | ||||||||
| Prerequisites | This course requires that participants have at least 2 years of genuine experience with Microsoft SQL Server. This course is not meant for Fresher | ||||||||
| Trainer/Instructor | Amit R S Bansal (SQL MCM, SQL MVP) | ||||||||
- 8-hour training
- Advance & exclusive content
- 100% demo-based
- Based on real-world scenarios
- Intermediate to Advanced level content
- Available In-person & Online
Module 1: SQL Server Wait & Queues
- Analyze Wait Stats at instance and level and take a top-down approach to identify the root cause of a performance issue.
- Understand, troubleshoot and diagnose common wait types
- Use Extended Events to capture workload specific wait types for fine-grained troubleshooting
Module 2: IO Troubleshooting
- How to identify IO bottlenecks and queries that are causing maximum IO
- Tune queries that are causing IO bottlenecks
Module 3: CPU Troubleshooting
- Understand SQL Server Scheduling
- Identify, troubleshoot & diagnose workloads that choke CPU
Module 4: Memory Troubleshooting
- Understand three-layered SQL Server Memory Architecture
- Identify, troubleshoot & diagnose workloads that are consuming high memory
- Understand Query Workspace Memory
- Identify, troubleshoot & diagnose queries that demand high memory grant
Module 5: Tempdb Troubleshooting
- How to identify Tempdb usage
- Identify, troubleshoot & diagnose workloads that are causing maximum tempdb usage
Module 6: Dealing with Deadlocks
- Identify different types of deadlocks
- Troubleshoot deadlocks & minimize them
Module 7: Index Tuning
- Identify bad indexing strategies
- Re-design indexes for better query performance
Module 8: Query Tuning Examples
- Analyze execution plans & identify poor performing queries
- Re-write T-SQL for query improvement
Hands-On-Labs
SQLMaestros Accelerators are one-day demo-oriented training, and hence they do not have hands-on component as part of the course curriculum. However, if a participant wishes to practice using SQLMaestros Hands-On-Labs, then he/she can purchase a subscription (monthly or annual) of SQLMaestros HOLs. Additionally, participants can opt for the 3-day SQLMaestros Master Classes or the 5-day SQLMaestros Hackathons, that have mandatory Hands-on-labs as part of the comprehensive curriculum.
Please feel free to contact us if you need any further information
Email : classes@sqlmaestros.com
Skype : classes@sqlmaestros.com
Contact: +91-9606482133 / +91-9503124667