{"id":3713,"date":"2012-03-08T10:00:00","date_gmt":"2012-03-08T18:00:00","guid":{"rendered":""},"modified":"2024-01-22T22:49:47","modified_gmt":"2024-01-23T06:49:47","slug":"introducing-xvelocity-in-memory-technologies-in-sql-server-2012-for-10-100x-performance","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/03\/08\/introducing-xvelocity-in-memory-technologies-in-sql-server-2012-for-10-100x-performance\/","title":{"rendered":"Introducing xVelocity in-memory technologies in SQL Server 2012 for 10-100X performance"},"content":{"rendered":"

In a fast evolving new world of data you need immediate answers to any question you ask about your business. Imagine the possibilities of being able to analyze 7 billion rows of data in seconds to generate an insight that moves the business forward.<\/span><\/p>\n

Companies are doing this today with SQL Server 2012 and the new xVelocity in-memory technologies. <\/span>bwin.party<\/span><\/a> turned a large report that took 17 minutes to run down to three seconds by enabling xVelocity for their data warehouse. <\/span>Beth Israel Deaconess Medical Center<\/span><\/a> also enabled xVelocity and dropped execution time for a 160 column table by 88 percent. Finally, Microsoft-led <\/span>benchmark testing<\/span> has shown 100X<\/b> reduction in query processing times for single queries.<\/span><\/p>\n

How is this new level of performance possible? This is achieved through improvements from both hardware and software. Hardware innovations allow you to have large memory storage at low cost. Software innovations delivered with xVelocity will optimize query executions for modern day hardware, that process data in memory, and switch from row to column-based organization of data.<\/span><\/p>\n

While other in-memory offerings in the marketplace may have required customers to purchase a separate hardware appliance or expensive add-ons, Microsoft SQL Server 2012 is exposing xVelocity as a core capability directly in its primary database engine. By doing so, you get the benefits of next-generation performance with your current IT hardware and software infrastructure. xVelocity also delivers these dramatic results for both Data Warehousing and Business Intelligence workloads.<\/span><\/p>\n

Data Warehousing<\/b>: xVelocity memory optimized columnstore index enables you to achieve break-through speed ups for common data warehouse queries. To enable this, your IT staff can simply use SQL Server Management Studio to create the column store. When the query runs, SQL Server will automatically pick the most optimized index and will bring data into or out of memory on demand not requiring you to have a memory capacity that fits your entire dataset. This design gives you the performance gains by fully utilizing the hardware you have today.<\/span><\/span><\/p>\n

Business Intelligence: <\/b>xVelocity introduces an in-memory analytics engine within SQL Server Analysis Services delivering faster time to insights. With scan rates of 10s of Billions of rows per second on typical industry hardware, xVelocity gives users the ability to actively interact with an unprecedented amount of data at the speed of thought.<\/span><\/span><\/p>\n

SQL Server 2008 R2 has already demonstrated high performance with leadership in both industry benchmarks and real-world scenarios (customers running <\/span>100 million transactions<\/span><\/a> daily). xVelocity in-memory technologies takes this a generational leap forward giving SQL Server the biggest performance improvements in its product history. You can now analyze billions of rows of data instantly transforming your decision making with real-time analytics.<\/span><\/p>\n

Microsoft is very excited about xVelocity and invite you to learn more through the following resources:<\/span><\/p>\n

\u00b7 Read customer examples of xVelocity (<\/span>bwin.party<\/span><\/a> and <\/span>Beth Israel Deaconess Medical Center<\/span><\/a>)<\/span><\/p>\n

\u00b7 Download an <\/span>evaluation copy of SQL Server 2012<\/span><\/a> to try xVelocity for yourself<\/span><\/p>\n

Douglas Leland
\n<\/span>General Manager, SQL Server Product Marketing
\n<\/span>Microsoft Corporation<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

In a fast evolving new world of data you need immediate answers to any question you ask about your business. Imagine the possibilities of being able to analyze 7 billion rows of data in seconds to generate an insight that moves the business forward.<\/p>\n","protected":false},"author":1457,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[5227,2400],"content-type":[2448],"topic":[],"coauthors":[2487],"class_list":["post-3713","post","type-post","status-publish","format-standard","hentry","product-sql","product-sql-server-2012","content-type-updates","review-flag-7-1593580462-294","review-flag-new-1593580247-437"],"yoast_head":"\nIntroducing xVelocity in-memory technologies in SQL Server 2012 for 10-100X performance - Microsoft SQL Server Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/03\/08\/introducing-xvelocity-in-memory-technologies-in-sql-server-2012-for-10-100x-performance\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Introducing xVelocity in-memory technologies in SQL Server 2012 for 10-100X performance - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"In a fast evolving new world of data you need immediate answers to any question you ask about your business. Imagine the possibilities of being able to analyze 7 billion rows of data in seconds to generate an insight that moves the business forward.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/03\/08\/introducing-xvelocity-in-memory-technologies-in-sql-server-2012-for-10-100x-performance\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2012-03-08T18:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:49:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png\" \/>\n\t<meta property=\"og:image:width\" content=\"512\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"SQL Server Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"SQL Server Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/03\/08\/introducing-xvelocity-in-memory-technologies-in-sql-server-2012-for-10-100x-performance\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/03\/08\/introducing-xvelocity-in-memory-technologies-in-sql-server-2012-for-10-100x-performance\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"Introducing xVelocity in-memory technologies in SQL Server 2012 for 10-100X performance\",\"datePublished\":\"2012-03-08T18:00:00+00:00\",\"dateModified\":\"2024-01-23T06:49:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/03\/08\/introducing-xvelocity-in-memory-technologies-in-sql-server-2012-for-10-100x-performance\/\"},\"wordCount\":499,\"commentCount\":8,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/03\/08\/introducing-xvelocity-in-memory-technologies-in-sql-server-2012-for-10-100x-performance\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/03\/08\/introducing-xvelocity-in-memory-technologies-in-sql-server-2012-for-10-100x-performance\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/03\/08\/introducing-xvelocity-in-memory-technologies-in-sql-server-2012-for-10-100x-performance\/\",\"name\":\"Introducing xVelocity in-memory technologies in SQL Server 2012 for 10-100X performance - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"datePublished\":\"2012-03-08T18:00:00+00:00\",\"dateModified\":\"2024-01-23T06:49:47+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/03\/08\/introducing-xvelocity-in-memory-technologies-in-sql-server-2012-for-10-100x-performance\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/03\/08\/introducing-xvelocity-in-memory-technologies-in-sql-server-2012-for-10-100x-performance\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/03\/08\/introducing-xvelocity-in-memory-technologies-in-sql-server-2012-for-10-100x-performance\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Introducing xVelocity in-memory technologies in SQL Server 2012 for 10-100X performance\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/sqlserver\",\"https:\/\/x.com\/SQLServer\",\"https:\/\/www.youtube.com\/user\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Introducing xVelocity in-memory technologies in SQL Server 2012 for 10-100X performance - Microsoft SQL Server Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/03\/08\/introducing-xvelocity-in-memory-technologies-in-sql-server-2012-for-10-100x-performance\/","og_locale":"en_US","og_type":"article","og_title":"Introducing xVelocity in-memory technologies in SQL Server 2012 for 10-100X performance - Microsoft SQL Server Blog","og_description":"In a fast evolving new world of data you need immediate answers to any question you ask about your business. Imagine the possibilities of being able to analyze 7 billion rows of data in seconds to generate an insight that moves the business forward.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/03\/08\/introducing-xvelocity-in-memory-technologies-in-sql-server-2012-for-10-100x-performance\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2012-03-08T18:00:00+00:00","article_modified_time":"2024-01-23T06:49:47+00:00","og_image":[{"width":512,"height":512,"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png","type":"image\/png"}],"author":"SQL Server Team","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"SQL Server Team","Est. reading time":"2 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/03\/08\/introducing-xvelocity-in-memory-technologies-in-sql-server-2012-for-10-100x-performance\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/03\/08\/introducing-xvelocity-in-memory-technologies-in-sql-server-2012-for-10-100x-performance\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"Introducing xVelocity in-memory technologies in SQL Server 2012 for 10-100X performance","datePublished":"2012-03-08T18:00:00+00:00","dateModified":"2024-01-23T06:49:47+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/03\/08\/introducing-xvelocity-in-memory-technologies-in-sql-server-2012-for-10-100x-performance\/"},"wordCount":499,"commentCount":8,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/03\/08\/introducing-xvelocity-in-memory-technologies-in-sql-server-2012-for-10-100x-performance\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/03\/08\/introducing-xvelocity-in-memory-technologies-in-sql-server-2012-for-10-100x-performance\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/03\/08\/introducing-xvelocity-in-memory-technologies-in-sql-server-2012-for-10-100x-performance\/","name":"Introducing xVelocity in-memory technologies in SQL Server 2012 for 10-100X performance - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"datePublished":"2012-03-08T18:00:00+00:00","dateModified":"2024-01-23T06:49:47+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/03\/08\/introducing-xvelocity-in-memory-technologies-in-sql-server-2012-for-10-100x-performance\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/03\/08\/introducing-xvelocity-in-memory-technologies-in-sql-server-2012-for-10-100x-performance\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/03\/08\/introducing-xvelocity-in-memory-technologies-in-sql-server-2012-for-10-100x-performance\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"Introducing xVelocity in-memory technologies in SQL Server 2012 for 10-100X performance"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/3713","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/1457"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=3713"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/3713\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=3713"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=3713"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=3713"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=3713"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=3713"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=3713"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}