March 10, 2012 - Microsoft re-brands the Vertipaq engine that runs inside PowerPivot and Analysis Services to xVelocity in-memory analytics engine
March 10, 2012 - Microsoft re-brands the Vertipaq engine that runs inside PowerPivot and Analysis Services to xVelocity in-memory analytics engine.
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.