The Wayback Machine - https://web.archive.org/web/20170101235343/https://www.microsoft.com/en-us/sql-server/sql-server-benchmarks-microsoft-tested

Microsoft-tested SQL Server benchmarks

The new SQL Server 2014 In-Memory OLTP with the memory-optimized columnstore feature delivers breakthrough performance gains for both OLTP applications and data warehouse queries. SQL Server 2014 is the first mainstream RDBMS to integrate both in-memory OLTP and a memory optimized columnar data storage capability into the relational database engine.

To gauge the benefits of in-memory technologies, Microsoft engineers measured a collection of complex data warehousing queries running with and without columnstore indexes on a large data warehouse.

Microsoft-tested

Application

Feature

Version

Result

Data warehouse performancexVelocity in-memory for data warehousingSQL Server 2012

Gain 10-100x performance for data warehousing queries

Using a combination of compression, algorithms optimized for modern CPU/memory architectures, and highly parallel execution, xVelocity can speed up query execution times by 4x, 10x, and even 100x, simply by adding columnstore indexes to the fact tables of a star-schema data warehouse.

Read the xVelocity blog post to learn more.

Application

Data warehouse performance

Feature

xVelocity in-memory for data warehousing

Version

SQL Server 2012

Result

Gain 10-100x performance for data warehousing queries

Using a combination of compression, algorithms optimized for modern CPU/memory architectures, and highly parallel execution, xVelocity can speed up query execution times by 4x, 10x, and even 100x, simply by adding columnstore indexes to the fact tables of a star-schema data warehouse.

Read the xVelocity blog post to learn more.

Application

Feature

Version

Result

Application

Feature

Version

Result

Application

Feature

Version

Result

Application

Feature

Version

Result

Application

Feature

Version

Result

Application

Feature

Version

Result

Application

Feature

Version

Result

Application

Feature

Version

Result

Application

Feature

Version

Result

Application

Feature

Version

Result

Application

Feature

Version

Result

Application

Feature

Version

Result

Application

Feature

Version

Result

Application

Feature

Version

Result

Application

Feature

Version

Result

Application

Feature

Version

Result

Application

Feature

Version

Result

Application

Feature

Version

Result

Application

Feature

Version

Result

Application

Feature

Version

Result

Application

Feature

Version

Result

Back To Top