In this session, we’ll do a short introduction to the In-Memory OLTP feature before diving straight into the use cases where the new lockless/latchless concurrency control and native compilation really shine.
Demos will cover PAGELATCH contention (and lack thereof), use of non-persistent in-memory tables for ETL and in-memory tables as “shock absorbers” for high throughput environments.
For each case we will do a comparison of "Classic" vs. in-memory, what gains the audience can expect, and what patterns will yield the biggest benefits.
Warner is a SQL Server MCM, Data Platform MVP and Principal Consultant at Pythian, a global Canada-based company specialized in DBA services. A brief stint in .NET programming led to his early DBA formation working for enterprise customers in Hewlett-Packard ITO organization. From there he transitioned to his current position at Pythian, managing multiple customers and instances in many versions and industries while leading a highly talented team of SQL Server DBAs.