SQL Server Performance Tuning (online)

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 TitleSQL Server Performance Tuning
Course BrochureDownload   download_img
Delivery FormatOnline (Instructor-led, two-way audio/video, 100% virtual classroom experience)
Date, Time & DurationSeptember 11 & 12, 2018, 4 hours/day + 1 hour buffer time
Timing: 09.00 am to 12.00 pm & 01.00 pm to 03.00 pm EST

List Price
DateAmount
Super Early Bird – Until March 31, 2018$295.00 USD
Early Bird – April 1 to July 31, 2018$345.00 USD
Regular – From August 01, 2018 Onwards$395.00 USD
LevelLevel 300-400 (Intermediate to Advance)
LevelLevel 300 – 400 (Intermediate to Advanced)
Target AudienceThis course is intended for SQL Server Database Administrators, SQL Database Engineers, SQL Developers & SQL Architects.
PrerequisitesThis course requires that participants have at least 2 years of genuine experience with Microsoft SQL Server. This course is not meant for Fresher
Trainer/InstructorAmit R S Bansal (SQL MCM, SQL MVP)
                    Registration                    
Key Highlights:

  • 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