Tuning Diagnosing and Fixing Hard Problems

This course is suitable for developers who access databases, for database administrators, data warehouse and business intelligence developers and of course for professional tuning consultants. It aims to take you beyond best practices and go below the surface into  the realm of measurement and KNOWLEDGE about why your implementation works or doesn’t. The teacher is Thomas Kejser.

Prerequisites:

• Experience running SQL Server
• Fundamental index tuning and query plan analysis skills
• Basic understanding of operating system

Modul 1:

• Single Threaded Optimisation
• Workload Classification
• Join algorithms (re)visited
• Query pattern and expected behaviours
• Measuring CPU time and basic Xperf skills

Modul 2:

• Stack walking and symbol resolution
• Classifying time outside the database (.NET and other code)
• Digging into strange wait types
• Getting I/O right
• Getting Networking right

Modul 3:

• Multi threaded Optimisation
• Thread Bottlenecks and shared context
• Allocations and transaction log file optimisation
• Spinlocks and classification
• What is CXPACKET? When should you worry?
• Avoiding shared context in SQL Server

Modul 4:

• Advanced Xperf Configuration
• Bad Drivers: Troubleshooting DPC/ISR issues
• Affinity masks and cache coherency
• NUMA optimisations