In-Memory

Accelerate your business, not queries with state of the art in-memory technologies that offer performance gains of up to 100x on commodity hardware.

A Technical Best Practices Tour with ColumnStore Index in SQL Server 2012

xVelocity is a family of memory-optimized technologies spanning Analytical, Transactional, Streaming and Caching data. Designed for industry standard hardware, xVelocity is a built-in capability in SQL Server 2012, SQL Server Parallel Data Warehouse, Office Excel 2013 and Windows Azure.

Microsoft xVelocity Benefits

Complete and pervasive with end-to-end acceleration capabilities across analytics, transactions, streaming and caching scenarios.
Built-in technologies with no need for additional licensing or specialized hardware.
Dramatically accelerated insights across all data types; structured or unstructured.

xVelocity Workloads

Analytics and Streaming
xVelocity accelerates decision making from the desktop to the datacenter, by making optimal use of in-memory technologies across the Data Platform.
- PowerPivot integrated into Excel 2013 allows for dramatically accelerated queries on the desktop with millions of rows.
- xVelocity Analytics, an integral part of Analysis Services capable of scan rates up to 10s of billions of rows per second.
- xVelocity Column store gives break-through speed ups (10-100x) for common data warehouse queries organizing data columnar wise.
- StreamInsight is an event processing engine that manages streaming data in memory and offers near real-time insight on streams of data such as stock trading data or web clickstreams.
Caching and Transactional
xVelocity extends beyond Business Analytics to provide in memory acceleration transactional and web caching workloads.
- Windows Azure Caching provides cloud based scale-out for applications while reducing costs and increasing scalability.
- Project “Hekaton” is an OLTP engine enhancement for SQL Server. Meaning existing applications can simply take advantage of in-memory OLTP acceleration. Early customers are seeing up to 50x performance gains.