SQL Server 2012: xVelocity

After SQL Server 2012 was released this past week, I saw a few mentions from Microsoft about a new feature in SQL Server 2012 called “xVelocity”.  I have been using SQL Server 2012 for months now, playing with all the new features, and never came across one called xVelocity.  How did I miss it?  Or did Microsoft add this feature after RC0 and kept it secret?

Turns out, xVelocity is not a new feature, but rather a renaming of an existing feature.  Vertipaq is the existing feature that will now be called xVelocity.  So the Vertipaq engine that is inside PowerPivot and Analysis Services 2012 Tabular is now called “xVelocity in-memory analytics engine”.  Also, “xVelocity” now refers to the column store index feature in the SQL Server 2012 relational database.

Here is a blog post from Microsoft that further explains the change:

Along with the SQL Server 2012 launch, Microsoft announced xVelocity in-memory technologies, delivering huge performance improvements for data warehousing and business intelligence.  The purpose of this blog post is to clarify what xVelocity means for business intelligence and Analysis Services in particular.

In SQL Server 2008 R2, Microsoft released PowerPivot for Excel which introduced an in-memory analytics engine called VertiPaq.  Vertipaq enables Excel to process hundreds of millions of rows with sub-second response times on desktop hardware.  This engine uses in-memory column-oriented storage and innovative compression techniques to achieve these remarkable results.

In SQL Server 2012, Microsoft has taken the same Vertipaq engine and integrated it into Analysis Services.  The results have been staggering with scan rates up to 10s of billions of rows per second on typical server hardware.  Customers who previewed SQL Server 2012 have also experienced compression ratios in excess of 100 times.

In SQL Server 2012, we are re-branding the Vertipaq engine that runs inside PowerPivot and Analysis Services to xVelocity in-memory analytics engine.  This engine is part of the xVelocity family that represents the next generation performance improvements across SQL Server.  We will stop using the Vertipaq name and transition the product, documentation and other collateral to use the xVelocity name.

More info:

No more Vertipaq, it’s now called xVelocity in-memory technologies

Extreme performance with xVelocity: is VertiPaq faster than ColumnStore Index or just different?

New Whitepaper from SQLBI: Vertipaq vs ColumnStore

xVelocity in SQL Server 2012

xVelocity, Vertipaq, and BI Semantic Model

About James Serra

James currently works for Microsoft specializing in big data and data warehousing using the Analytics Platform System (APS), a Massively Parallel Processing (MPP) architecture. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence/MDM architect and developer, specializing in the Microsoft BI stack. He is a SQL Server MVP with over 25 years of IT experience.
This entry was posted in SQL Server 2012, SQLServerPedia Syndication, Tabular. Bookmark the permalink.

2 Responses to SQL Server 2012: xVelocity

  1. Pingback: SQL Server 2014: In-memory OLTP Engine, code-name: Hekaton | James Serra's Blog

  2. Pingback: SQL Server 2014: In-memory OLTP Engine, code-name: Hekaton - SQL Server - SQL Server - Toad World

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>