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 Title SQL Server Performance Tuning
Course Brochure Download   download_img
Delivery Format Online (Instructor-led, synchronous) using GoToMeeting Platform.
Date, Time & Duration December 19 & 20, 4 hours/day
Timings: 10.30 am to 1.00 pm and 2.00 pm to 4.30 pm IST

List Price
Date Amount
Super Early Bird – Oct 30 to Nov 10, 2017 INR 8000 / USD 300
Early Bird – Nov 11 to Nov 30, 2017 INR 9000 / USD 350
Regular – Dec 1 to Dec 19, 2017 INR 10,000/ USD 400

Note:

    * INR & USD Prices quoted above are exclusive of 18% GST.
    * 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)
                    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