Brent Ozar about the state and future of the things in the SQL Server space:
In SQL Server 2012 and beyond, we’ve got:
- AlwaysOn Availability Groups – high availability, disaster recovery, and
- Hekaton - in-memory storage with optimized stored procedures and new data
formats on disk
- Column store indexes – faster data retrieval for certain kinds of queries
Call me maybe crazy, but I don’t see really widespread adoption for any of
Leaving crazyness aside, I’m wondering if these features are not of interest for SQL Server users then what is would SQL Server users want to see?
✚ Hekaton is something new for me to read about.
✚ Here’s something interesting about Hekaton:
By late fall 2009, Larson and his colleagues had come up with a design and a
simple prototype for an in-memory database engine that showed huge
performance improvements. They had moved away from a partitioned approach,
which essentially treated a multicore processor as a distributed system, to
a latch-free, also called lock-free, design that focused on removing the
barriers to scalability present in current systems.
✚ There’s a paper about the MVCC implementation in Hekaton: High-Performance Concurrency Contorl Mechanisms for Main-Memory Databases.
Original title and link: SQL Server’s Future ( ©myNoSQL)