The in-memory chapters mission is to enable the SQL server community to take full advantage of the new in-memory features.
Next Meeting

Wed, Jun 15 2016 17:00 (UTC-12:00) International Date Line West

The Use Cases For In-Memory OLTP


The Use Cases For In-Memory OLTP

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.