SQL Server Practical Performance Troubleshooting

Level 200 – Basic to Intermediate level
Type Full-day
Speaker Amit Bansal
Price Early Bird 130€ Until 1st of september
Regular 150€ after 1st of september
Location Microsoft Danmark – Kanalvej 7, 2800 Lyngby
Ticket Type Price Cart

Practical Performance Troubleshooting Pre-Con is designed for the working SQL Server professional who has the relevant experience with SQL Server and only needs practical examples of troubleshooting SQL Server performance that can be applied in production right away. In this full-day training, participants will see relevant, crisp, real-world examples of common performance areas.

An 8-hour, 100% demo-oriented delivery on SQL Server Performance Troubleshooting. Basic to Intermediate level, covering important aspects.

Topics Include:

Module 1: CPU Troubleshooting (Scheduling)

  • Query Lifecycle
  • Connections -> Sessions -> Requests -> Tasks -> Workers -> Threads
  • Common Scheduler Wait Types in SQL Server, identification & diagnosis
  • CPU Performance Troubleshooting
  • Identifying workload patterns that cause excessive CPU
  • Important DMVs & Performance Counters

Module 2: IO Troubleshooting

  • Understanding SQL Server IO patterns
  • Troubleshooting IO bottlenecks using DMVs
  • Troubleshooting IO bottlenecks using Performance Counters
  • Troubleshooting IO bottlenecks using Wait Types
  • Identifying workloads that cause excessive IO

Module 3: Memory Troubleshooting

  • SQL Server Memory Architecture – Welcome To The Dungeon
  • Internal vs External Memory Pressure
  • Understanding Memory Errors
  • Troubleshooting Memory Issues
  • Identifying workloads that cause excessive memory usage
  • Memory Wait Types
  • Understanding Query Workspace Memory

Module 4: Tempdb Troubleshooting

  • Common issues with Tempdb and resolutions
  • Identifying workloads that cause maximum Tempdb usage
  • Tips/Tricks with Tempdb to improve performance

Module 5: Dealing with Deadlocks

  • Common Deadlock Types
  • Deadlock Best Practices
  • Practical Deadlock Troubleshooting & Diagnosis

Module 6: Troubleshooting Indexes

  • Demystifying Common Myths with Indexes
  • Indexing Strategies
  • Real-World Index Tuning Examples


Bio Amit Bansal

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 MS Ignite, SQLBits, SSGAS/DPS, PASS Summit & SQL Saturday events. 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.

To learn more about Amit, visit http://sqlmaestros.com/amit-bansal/