Kalen Delaney: What the Hekaton!? A Whole New Way to Think About Data Mgmt
Friday, May 2, 2014 from 9:00 AM to 4:30 PM (EDT)
Why concurrency matters for performance, and how In-Memory OLTP can drastically improve yours
SQL Server Hekaton, Microsoft’s new In-Memory table technology being shipped as part of SQL Server 2014, will completely change the way you think about concurrency and data management. Concurrency problems are one of the top three performance issues that all applications have to deal with.
In this full-day seminar, Kalen Delaney (a SQL Server MVP for over 20 years) will show you how SQL Server 2012 manages concurrent operations to understand where there is room for improvement. We’ll look at the completely new data structures for In-Memory OLTP to see how SQL Server 2014 can provide lock-free and latch-free data processing.
This session we’ll discuss what gets written to disk during checkpoints, as well as what gets logged. Kalen will explain how the recovery process recreates your Hekaton tables. Finally, she’ll go into detail on just what it is that makes Hekaton so much FASTER!
Our planned agenda:
- Why Hekaton?
- Concurrency Control in SQL Server 2012
- o Isolation Levels
- o Pessimistic vs Optimistic Concurrency
- Locking and Blocking
- Snapshot Isolation
- In-Memory Data Structures
- Hash Indexes
- Range Indexes
- Data Access
- Performance Benefits
- No latching
- No locking
- No query interpretation
- Managing Memory
- Space Requirements
- Garbage Collection
- Persistence and Storage Management
- Checkpoint Files
- Planning for Hekaton
Kalen Delaney has been working with SQL Server for over 26 years, and provides performance consulting services as well as advanced SQL Server training to clients around the world, using her own custom-developed curriculum. She has been a SQL Server MVP since 1993 and has been writing about SQL Server almost as long. Kalen has spoken at dozens of technical conferences, including almost every US PASS conference since the organization’s founding in 1999. Kalen is a contributing editor and columnist for SQL Server Magazine and the author or co-author of several of the most deeply technical books on SQL Server, including SQL Server 2012 Internals. Kalen blogs at www.sqlblog.com and her personal website and schedule can be found at www.SQLServerInternals.com.
Lunch will be provided and is included in your ticket price.
IMPORTANT: Registration for a precon session does NOT include registration for SQL Saturday on May 3 - please register here (it's free!) for Saturday's event.
When & Where
SQL Saturday #285 - Atlanta
Organized by AtlantaMDF (Atlanta chapter of SQL PASS), SQL Saturday Atlanta set an attendance record in 2013. The Atlanta SQL Server community attracts world-class speakers for event sessions as well as full-day pre-conference training.