In-Memory Features.pdf

Provides row-based in-memory data access and modification capabilities, used for transaction processing workloads and data warehousing scenarios.
Key Components:
+ Memory-optimized data structures
+ Native compilation for efficient data access and querying
+ Lock- and latch-free architecture for linear scaling
+ Integrated into the SQL Server database engine
Benefits: Dramatically improves throughput and latency on transactional processing workloads, provides significant performance improvements.

In-Memory Columnstore Features

Column Compression: Reduces storage footprint and improves query performance.
Batch-Mode Query Processing: Optimized for in-memory performance.
Updatable, Memory-Optimized, Column-Oriented Indexes: Used primarily in data warehousing scenarios, but also suitable for operational analytics.
Key Components:
+ Clustered and nonclustered Columnstore indexes
+ Row groups for efficient compression
+ Batch-mode processing for optimized performance

Comparison with Other Providers

Oracle: Offers In-Memory OLTP (Oracle TimesTen) and In-Memory Columnstore (Oracle 12c).
IBM: Offers BLU Acceleration (IBM DB2).
* Comparison Points:
+ SQL Server in-memory solutions provide faster transactions, queries, and insights.
+ SQL Server in-memory technology outpaces other solutions in terms of performance and functionality.