Practical SQL Server Troubleshooting & Performance Tuning (Online)

This Master Class will be delivered by Amit Bansal

Friendly Title SQL Server Performance Tuning
Class Title Practical SQL Server Troubleshooting & Performance Tuning
Trainer Amit Bansal (India)
Brochure Download
Delivery Type Online
Delivery Format
  • Total 8 hours
  • Two consecutive days
  • 5 hours each day with one-hour break in between
  • Date March 12 & 13, 2019
    Time
  • IST: 10.00 AM – 3.00 PM (Break from 12 PM to 1 PM)
  • UTC: 4.30 AM – 9.30 AM (Break from 6.30 AM to 7.30 AM)
  • PST: 9.30 PM – 2.30 AM (Break from 11.30 PM to 12.30 AM)
  • ACT: 3.00 PM – 8.00 PM (Break from 5 PM to 6 PM)
  • Price Regular Price: $190 USD / INR 13300
    Discounted Price: $147 / INR 10300 (Limited Seats. Limited Period Offer)

      * Conversion rate of INR 70 per USD has been taken into consideration
      * For Indian Credit Cards, 18% GST will be charged extra
      * Group discounts available
    Level Intermediate
    Pre-requisites At least two years of genuine working experience with SQL Server
    Key Highlights Practical SQL Server Performance Troubleshooting & Tuning Pre-Con is designed for the working SQL Server professionals, Developers, Database Administrators & Architects who have relevant experience with SQL Server and only needs practical examples of performance troubleshooting & tuning that can be applied in applications & production right away. In this full-day training, participants will see relevant, crisp, real-world examples of tuning SQL Server performance.
    Takeaways
  • Practical, Real-World Examples
  • All Demo Scripts
  • Loads of learning that can be applied into production right-away
  • Course Outline
  • Module 1: SQL Server Wait Types & Statistics
    • Query Lifecycle
    • Connections -> Sessions -> Requests -> Tasks -> Workers -> Threads
    • Common Wait Types in SQL Server, identification & diagnosis
  • Module 2: The Holy Trinity – CPU, Memory, IO
    • 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
  • Module 3: Query Execution & Query Plan Analysis
    • Statistics & Cardinality Estimation
    • Reading & Analysing Execution Plans
    • Important Iterators
  • Module 4: Query Tuning
    • Rewriting Transact-SQL
    • Optimizing Stored Procedures
    • Solving Parameter Sniffing Issues
    • Parametrization Best Practices
    • Tips with Procedural Code
  • Module 5: Index Tuning
    • Demystifying Common Myths with Indexes
    • Indexing Strategies
    • Index Fragmentation
    • Real-World Index Tuning Examples
  • Module 6: Dealing with Deadlocks
    • SQL Server Concurrency, Isolation Levels, Locking Granularity & Hierarchy
    • Common Deadlock Types
    • Deadlock Best Practices
    • Practical Deadlock Troubleshooting & Diagnosis

    `

    Demos Complete 8-hr content is demo packed
    Trainer’s Bio Amit 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 (India), 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 www.youtube.com/SQLMaestros. To learn more about Amit, visit https://sqlmaestros.com/amit-bansal/.

    SQLMaestros Contact Details Email: Classes@SQLMaestros.com
    Phone: +91 9606482131 / +91 9606482133
    Skype: Classes@SQLMaestros.com
    Important Links :

    Home page https://sqlmaestros.com/
    SQLMaestros Master Classes https://sqlmaestros.com/sql-server-classes-india/
    Video Courses https://sqlmaestros.com/sql-server-videos-courses/
    Learning Kits https://sqlmaestros.com/sql-server-courseware/
    SQL Server Health Check Service https://sqlmaestros.com/sql-server-health-check/
    Hands-On-Labs http://hols.sqlmaestros.com/
    Testimonials https://sqlmaestros.com/sql-server-master-class-feedback-testimonials/
    FAQ https://sqlmaestros.com/faqs/

    Please feel free to contact us if you need any further information
    Email: Classes@SQLMaestros.com
    Phone: +91 9606482131 / +91 9606482133
    Skype: Classes@SQLMaestros.com