Developing Highly Concurrent Databases [AD-208]
Michael J Swart
Duration: 75 minutes
Understanding concurrency is critical when taking a database solution from startup to enterprise scale and beyond.
Concurrency problems can restrict the throughput you get from SQL Server. So your goal is to develop an application that can avoid these bottlenecks and make use of all the hardware it's given.
In this session we'll cover several enemies of concurrency, excessive blocking, how to detect and fix deadlocks, correct tempdb configuration and others. We'll also talk about when it's appropriate to use SQL Server's In-Memory OLTP features or the Read Committed Snapshot Isolation Level.