SQLBits 2013

Troubleshooting the most difficult SQL Server problems

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!
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