{"id":1873,"date":"2013-10-16T06:00:00","date_gmt":"2013-10-16T13:00:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2013\/10\/16\/sql-server-2014-pushing-the-boundaries-of-in-memory-performance\/"},"modified":"2024-01-22T22:49:08","modified_gmt":"2024-01-23T06:49:08","slug":"sql-server-2014-pushing-the-boundaries-of-in-memory-performance","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/16\/sql-server-2014-pushing-the-boundaries-of-in-memory-performance\/","title":{"rendered":"SQL Server 2014: Pushing the Boundaries of In-Memory Performance"},"content":{"rendered":"<p>This morning, during my keynote at the <a href=\"http:\/\/www.sqlpass.org\/summit\/2013\/Home.aspx\">Professional Association of SQL Server (PASS) Summit<\/a> 2013, I discussed how customers are <em>pushing the boundaries <\/em>of what\u2019s possible for businesses today using the advanced technologies in our data platform. It was my pleasure to announce the second Community Technology Preview (CTP2) of <a href=\"http:\/\/www.microsoft.com\/en-us\/sqlserver\/sql-server-2014.aspx?WT.mc_id=Blog_SQL_PASS_SQL2014\">SQL Server 2014<\/a> which features breakthrough performance with In-Memory OLTP and simplified backup and disaster recovery in Windows Azure.<\/p>\n<p><strong>Pushing the boundaries<\/strong><\/p>\n<p>We are pushing the boundaries of our data platform with breakthrough performance, cloud capabilities and the pace of delivery to our customers. Last year at PASS Summit, we announced our In-Memory OLTP project \u201cHekaton\u201d and since then released <a href=\"http:\/\/www.microsoft.com\/en-us\/sqlserver\/solutions-technologies\/data-warehousing\/pdw.aspx?WT.mc_id=Blog_SQL_PASS_SQL2014\">SQL Server 2012 Parallel Data Warehouse<\/a> and public previews of Windows Azure HDInsight and <a href=\"\/sqlserver\/2013\/09\/25\/microsoft-updates-power-bi-for-office-365-preview-with-new-natural-language-search-mapping-capabilities\/\">Power BI for Office 365<\/a>. Today we have SQL Server 2014 CTP2, our public and production-ready release shipping a mere 18 months after SQL Server 2012.<\/p>\n<p>Our drive to push the boundaries comes from recognizing that the world around data is changing.<\/p>\n<ul>\n<li>Our <strong>customers are demanding more from their data<\/strong> \u2013 higher levels of availability as their businesses scale and globalize, major advancements in performance to align to the more real-time nature of business, and more flexibility to keep up with the pace of <em>their <\/em>innovation.\u00a0So we provide in-memory, cloud-scale, and hybrid solutions.<\/li>\n<li>Our <strong>customers are storing and collecting more data<\/strong> \u2013 machine signals, devices, services and data from outside even their organizations. So we invest in scaling the database and a Hadoop-based solution.<\/li>\n<li>Our <strong>customers are seeking the value of new insights for their business<\/strong>. So we offer them self-service BI in Office 365 delivering powerful analytics through a ubiquitous product and empowering users with new, more accessible ways of gaining insights.<\/li>\n<\/ul>\n<p><strong>In-memory in the box for breakthrough performance<\/strong><\/p>\n<p>A few weeks ago, one of our competitors announced plans to build an in-memory column store into their database product some day in the future. We shipped similar technology <em>two years ago<\/em> in SQL Server 2012, and have continued to advance that technology in SQL Server 2012 Parallel Data Warehouse and now with SQL Server 2014. In addition to our in-memory columnar support in SQL Server 2014, we are also pushing the boundaries of performance with in-memory online transaction processing (OLTP). A year ago we announced project \u201cHekaton,\u201d and today we have customers realizing performance gains of up to 30x.\u00a0This work, combined with our early investments in Analysis Services and Excel, means Microsoft is delivering the most complete in-memory capabilities for all data workloads \u2013 analytics, data warehousing and OLTP.<\/p>\n<p>We do this to allow our customers to make breakthroughs for their businesses. SQL Server is enabling them to rethink how they can accelerate and exceed the speed of their business.<\/p>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/4682.Sven20Lowry20TPP.png\"><img decoding=\"async\" style=\"margin-left: auto;margin-right: auto\" title=\"Sven Lowry TPP\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/4682.Sven20Lowry20TPP.png\" alt=\"Sven Lowry TPP\" \/><\/a><\/p>\n<ul>\n<li><a href=\"http:\/\/www.microsoft.com\/casestudies\/Case_Study_Detail.aspx?CaseStudyID=710000003350\"><strong>TPP<\/strong><\/a> is a clinical software provider managing more than 30 million patient records \u2013 half the patients in England \u2013 including 200,000 active registered users from the UK\u2019s National Health Service. \u00a0Their systems handle 640 million transactions per day, peaking at 34,700 transactions per second. They tested a next-generation version of their software with the SQL Server 2014 in-memory capabilities, which has enabled their application to run seven times faster than before \u2013 all of this done and running in half a day.<\/li>\n<li><a href=\"http:\/\/www.microsoft.com\/canada\/casestudies\/Case_Study_Detail.aspx?casestudyid=710000003000\"><strong>Ferranti<\/strong><\/a> provides solutions for the energy market worldwide, collecting massive amounts of data using smart metering. With our in-memory technology they can now process a continuous data flow up to 200 million measurement channels making the system fully capable of meeting the demands of smart meter technology.<\/li>\n<li><a href=\"http:\/\/www.microsoft.com\/casestudies\/Microsoft-SQL-Server-2014\/SBI-Liquidity-Market\/Leading-Japanese-Financial-Firm-Accelerates-Trading-Platform-with-In-Memory-OLTP\/710000003358\"><strong>SBI Liquidity Market<\/strong><\/a> in Japan provides online services for foreign currency trading. By adopting SQL Server 2014, the company has increased throughput from 35,000 to 200,000 transactions per second. They now have a trading platform that is ready to take on the global marketplace.<\/li>\n<\/ul>\n<p><strong>A closer look into In-memory OLTP<\/strong><\/p>\n<p>Previously, <a href=\"\/sqlserver\/2013\/06\/03\/sql-server-2014-unlocking-real-time-insights\/\">I wrote about<\/a> the journey of the in-memory OLTP project <a href=\"\/sqlserver\/2012\/11\/08\/breakthrough-performance-with-in-memory-technologies\/\">Hekaton<\/a>, where a group of SQL Server database engineers collaborated with <a href=\"http:\/\/research.microsoft.com\/en-us\/news\/features\/hekaton-122012.aspx\">Microsoft Research<\/a>. Changes in the ratios between CPU performance, IO latencies and bandwidth, cache and memory sizes as well as innovations in networking and storage were changing assumptions and design for the next generation of data processing products.\u00a0This gave us the opening to push the boundaries of what we could engineer without the constraints that existed when relational databases were first built many years ago.<\/p>\n<p>Challenging those assumptions, we engineered for dramatically changing latencies and throughput for so-called \u201chot\u201d transactional tables in the database. Lock-free, row-versioning data structures and compiling T-SQL and queries into native code, combined with making the programming semantics consistent with SQL Server means our customers can apply the performance benefits of extreme transaction processing without application rewrites or the adoption of entirely new products.<\/p>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/1727.Transformational20In20Memory20Performance.png\"><img decoding=\"async\" style=\"margin-left: auto;margin-right: auto\" title=\"Transformational In-Memory Performance\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/1727.Transformational20In20Memory20Performance.png\" alt=\"Transformational In-Memory Performance\" \/><\/a><\/p>\n<p><strong>The continuous data platform<\/strong><\/p>\n<p>Windows Azure fulfills new scenarios for our customers \u2013 transcending what is on-premises or in the cloud. Microsoft is providing a continuous platform from our traditional products that are run on-premises to our cloud offerings.<\/p>\n<p>With SQL Server 2014, we are bringing the cloud into the box. We are delivering high availability and disaster recovery on Windows Azure built right into the database. This enables customers to benefit from our global datacenters: AlwaysOn Availability Groups that span on-premises and Windows Azure Virtual Machines, database backups directly into Windows Azure storage, and even the ability to store and run database files directly in Windows Azure storage.\u00a0That last scenario really does something interesting \u2013 now you can have an infinitely-sized hard drive with incredible disaster recovery properties with all the great local latency and performance of the on-premises database server.<\/p>\n<p>We\u2019re not just providing easy backup in SQL Server 2014, today we announced backup to Windows Azure would be available for <em>all <\/em>our currently supported SQL Server releases. Together, the backup to Windows Azure capabilities in SQL Server 2014 and via the standalone tool offer customers a single, cost-effective backup strategy for secure off-site storage with encryption and compression across all supported versions of SQL Server.<\/p>\n<p>By having a complete and continuous data platform we strive to empower billions of people to get value from their data.\u00a0It\u2019s why I am so excited to announce the availability of SQL Server 2014 CTP2, hot on the heels of the fastest-adopted release in SQL Server\u2019s history, SQL Server 2012. Today, <strong>more businesses solve their data processing needs with SQL Server than any other database<\/strong>. It\u2019s about empowering the world to push the boundaries.<\/p>\n<p>Quentin Clark<br \/>\nCorporate Vice President<br \/>\nData Platform Group<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This morning, during my keynote at the Professional Association of SQL Server (PASS) Summit 2013, I discussed how customers are pushing the boundaries of what\u2019s possible for businesses today using the advanced technologies in our data platform.<\/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":[],"content-type":[2445],"topic":[],"coauthors":[2487],"class_list":["post-1873","post","type-post","status-publish","format-standard","hentry","content-type-thought-leadership","review-flag-free-1593619513-128","review-flag-new-1593580247-437"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL Server 2014: Pushing the Boundaries of In-Memory 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\/2013\/10\/16\/sql-server-2014-pushing-the-boundaries-of-in-memory-performance\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2014: Pushing the Boundaries of In-Memory Performance - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"This morning, during my keynote at the Professional Association of SQL Server (PASS) Summit 2013, I discussed how customers are pushing the boundaries of what\u2019s possible for businesses today using the advanced technologies in our data platform.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/16\/sql-server-2014-pushing-the-boundaries-of-in-memory-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=\"2013-10-16T13:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:49:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/4682.Sven20Lowry20TPP.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=\"4 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\/2013\/10\/16\/sql-server-2014-pushing-the-boundaries-of-in-memory-performance\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/16\/sql-server-2014-pushing-the-boundaries-of-in-memory-performance\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"SQL Server 2014: Pushing the Boundaries of In-Memory Performance\",\"datePublished\":\"2013-10-16T13:00:00+00:00\",\"dateModified\":\"2024-01-23T06:49:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/16\/sql-server-2014-pushing-the-boundaries-of-in-memory-performance\/\"},\"wordCount\":1060,\"commentCount\":10,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/16\/sql-server-2014-pushing-the-boundaries-of-in-memory-performance\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/4682.Sven20Lowry20TPP.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/16\/sql-server-2014-pushing-the-boundaries-of-in-memory-performance\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/16\/sql-server-2014-pushing-the-boundaries-of-in-memory-performance\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/16\/sql-server-2014-pushing-the-boundaries-of-in-memory-performance\/\",\"name\":\"SQL Server 2014: Pushing the Boundaries of In-Memory Performance - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/16\/sql-server-2014-pushing-the-boundaries-of-in-memory-performance\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/16\/sql-server-2014-pushing-the-boundaries-of-in-memory-performance\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/4682.Sven20Lowry20TPP.png\",\"datePublished\":\"2013-10-16T13:00:00+00:00\",\"dateModified\":\"2024-01-23T06:49:08+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/16\/sql-server-2014-pushing-the-boundaries-of-in-memory-performance\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/16\/sql-server-2014-pushing-the-boundaries-of-in-memory-performance\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/16\/sql-server-2014-pushing-the-boundaries-of-in-memory-performance\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/4682.Sven20Lowry20TPP.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/4682.Sven20Lowry20TPP.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/16\/sql-server-2014-pushing-the-boundaries-of-in-memory-performance\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2014: Pushing the Boundaries of In-Memory 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":"SQL Server 2014: Pushing the Boundaries of In-Memory 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\/2013\/10\/16\/sql-server-2014-pushing-the-boundaries-of-in-memory-performance\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2014: Pushing the Boundaries of In-Memory Performance - Microsoft SQL Server Blog","og_description":"This morning, during my keynote at the Professional Association of SQL Server (PASS) Summit 2013, I discussed how customers are pushing the boundaries of what\u2019s possible for businesses today using the advanced technologies in our data platform.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/16\/sql-server-2014-pushing-the-boundaries-of-in-memory-performance\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2013-10-16T13:00:00+00:00","article_modified_time":"2024-01-23T06:49:08+00:00","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/4682.Sven20Lowry20TPP.png","type":"","width":"","height":""}],"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":"4 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/16\/sql-server-2014-pushing-the-boundaries-of-in-memory-performance\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/16\/sql-server-2014-pushing-the-boundaries-of-in-memory-performance\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"SQL Server 2014: Pushing the Boundaries of In-Memory Performance","datePublished":"2013-10-16T13:00:00+00:00","dateModified":"2024-01-23T06:49:08+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/16\/sql-server-2014-pushing-the-boundaries-of-in-memory-performance\/"},"wordCount":1060,"commentCount":10,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/16\/sql-server-2014-pushing-the-boundaries-of-in-memory-performance\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/4682.Sven20Lowry20TPP.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/16\/sql-server-2014-pushing-the-boundaries-of-in-memory-performance\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/16\/sql-server-2014-pushing-the-boundaries-of-in-memory-performance\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/16\/sql-server-2014-pushing-the-boundaries-of-in-memory-performance\/","name":"SQL Server 2014: Pushing the Boundaries of In-Memory Performance - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/16\/sql-server-2014-pushing-the-boundaries-of-in-memory-performance\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/16\/sql-server-2014-pushing-the-boundaries-of-in-memory-performance\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/4682.Sven20Lowry20TPP.png","datePublished":"2013-10-16T13:00:00+00:00","dateModified":"2024-01-23T06:49:08+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/16\/sql-server-2014-pushing-the-boundaries-of-in-memory-performance\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/16\/sql-server-2014-pushing-the-boundaries-of-in-memory-performance\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/16\/sql-server-2014-pushing-the-boundaries-of-in-memory-performance\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/4682.Sven20Lowry20TPP.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/4682.Sven20Lowry20TPP.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/16\/sql-server-2014-pushing-the-boundaries-of-in-memory-performance\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2014: Pushing the Boundaries of In-Memory 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\/1873","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=1873"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/1873\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=1873"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=1873"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=1873"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=1873"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=1873"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=1873"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}