Do you have enough from "normal" performance tuning sessions? You can't hear anything about Indexing and Execution Plans anymore? Then you are right in this session! In this session we will walk into the heart of SQL Server, and you will see performance bottlenecks and error conditions, from which your production SQL Server's should be afraid of. You will learn some troubleshooting techniques with which you can identify and solve the most difficult SQL Server problems. Agenda at a glance:

*) Hold Locks with Read Committed
*) ThreadPool Starvation
*) TempDb Latch Contention
*) Spinlock Contention
*) Cross NUMA Node Latency Problems
*) VMware Memory Balloon Driver
Slide Deck 227 KB , MP4 Video Low 98 MB , MP4 Video Med 185 MB , MP4 Video HD 509 MB