{"id":461,"date":"2014-03-18T10:00:00","date_gmt":"2014-03-18T10:00:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/inside_microsoft_research\/2014\/03\/18\/helping-sql-server-rev-up-to-full-speed\/"},"modified":"2016-07-20T07:30:23","modified_gmt":"2016-07-20T14:30:23","slug":"helping-sql-server-rev-up-to-full-speed","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/research\/blog\/helping-sql-server-rev-up-to-full-speed\/","title":{"rendered":"Helping SQL Server Rev Up to Full Speed"},"content":{"rendered":"<div id=\"share-icons-top-of-post\">\n<ul class=\"post-social\">\n<li class=\"post-facebook\"><iframe src=\"http:\/\/www.facebook.com\/plugins\/like.php?href=http%3A%2F%2Fblogs.technet.com%2Fb%2Finside_microsoft_research%2Farchive%2F2014%2F03%2F18%2Fhelping-sql-server-rev-up-to-full-speed.aspx&width=100&layout=button_count&action=like&show_faces=true&share=false&height=21&appId=502558646482372\" scrolling=\"no\" frameborder=\"0\" style=\"border:none;overflow:hidden;width:100px;height:21px;\"><\/iframe><\/li>\n<li class=\"post-twitter\"><a class=\"twitter-share-button\" href=\"https:\/\/x.com\/share\">Tweet<\/a><br \/>\n<script type=\"text\/javascript\" src=\"https:\/\/msdnshared.blob.core.windows.net\/media\/TNBlogsFS\/prod.evol.blogs.technet.com\/CommunityServer.Blogs.Components.WeblogFiles\/00\/00\/00\/90\/35\/js\/6811.tweet-this.js\" original-url=\"http:\/\/blogs.technet.com\/cfs-file.ashx\/__key\/communityserver-blogs-components-weblogfiles\/00-00-00-90-35-js\/6811.tweet_2D00_this.js\"><\/script>\n<\/li>\n<\/ul>\n<\/div>\n<p><!--    END SOCIAL SHARING CONTENT and ENTER AUTHOR AND BLOG CONTENT BELOW --><\/p>\n<p class=\"posted-by\">Posted by <span class=\"author\">Rob Knies<\/span><\/p>\n<p><a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" target=\"_blank\" href=\"https:\/\/msdnshared.blob.core.windows.net\/media\/TNBlogsFS\/prod.evol.blogs.technet.com\/CommunityServer.Blogs.Components.WeblogFiles\/00\/00\/00\/90\/35\/SQLServer300X300.jpg\" original-url=\"http:\/\/blogs.technet.com\/cfs-file.ashx\/__key\/communityserver-blogs-components-weblogfiles\/00-00-00-90-35\/SQLServer300X300.jpg\"><img decoding=\"async\" src=\"https:\/\/msdnshared.blob.core.windows.net\/media\/TNBlogsFS\/prod.evol.blogs.technet.com\/CommunityServer.Blogs.Components.WeblogFiles\/00\/00\/00\/90\/35\/SQLServer300X300.jpg\" original-url=\"http:\/\/blogs.technet.com\/resized-image.ashx\/__size\/550x0\/__key\/communityserver-blogs-components-weblogfiles\/00-00-00-90-35\/SQLServer300X300.jpg\" alt=\"generic image\" width=\"300\" title=\"generic image\" style=\"float:left;margin:10px;\" \/><span class=\"sr-only\"> (opens in new tab)<\/span><\/a><\/p>\n<p>As <a href=\"http:\/\/www.microsoft.com\/en-us\/server-cloud\/products\/sql-server\/Explore.aspx#fbid=fySOzxJ4nBF\" title=\"SQL Server 2014\" target=\"_blank\">SQL Server 2014<\/a> is <a href=\"\/b\/microsoft_blog\/archive\/2014\/03\/18\/sql-server-2014-released-to-manufacturers-will-be-generally-available-april-1.aspx\" title=\"released to manufacturing\" target=\"_blank\">released to manufacturing<\/a> on March 18, one of the features that will be bolstering the new release, to be available to customers on April 1, are its in-memory solutions built directly into the product. These solutions began as <a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" href=\"http:\/\/research.microsoft.com\/pubs\/193594\/Hekaton%20-%20Sigmod2013%20final.pdf\" title=\"Hekaton\" target=\"_blank\">Hekaton<span class=\"sr-only\"> (opens in new tab)<\/span><\/a>, a collaboration between the product team and Microsoft Research.<\/p>\n<p>One of the selling points for SQL Server 2014 is its fast performance, and the solution built from Hekaton delivers in that regard, with its in-memory online-transaction processing, featuring an updatable in-memory column store and in-memory analytics.<\/p>\n<p>Hekaton is discussed in a video as part of the <a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" href=\"https:\/\/channel9.msdn.com\/Series\/Microsoft-Research-Luminaries\" title=\"Microsoft Research Luminaries\" target=\"_blank\">Microsoft Research Luminaries<span class=\"sr-only\"> (opens in new tab)<\/span><\/a> series on <a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" target=\"_blank\" href=\"https:\/\/channel9.msdn.com\/\" title=\"Channel 9\">Channel 9<span class=\"sr-only\"> (opens in new tab)<\/span><\/a>. In the video, <a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" href=\"http:\/\/research.microsoft.com\/en-us\/people\/palarson\/\" title=\"Paul Larson\" target=\"_blank\">Paul Larson<span class=\"sr-only\"> (opens in new tab)<\/span><\/a>, Microsoft Research principal researcher, and Mike Zwilling, SQL Server principal architect, chat about the collaboration and the goals for the project.<\/p>\n<p><object data=\"data:application\/x-silverlight-2,\" type=\"application\/x-silverlight-2\" width=\"320\" height=\"246\"><param name=\"source\" value=\"http:\/\/research.microsoft.com\/apps\/video\/ClientBin\/EmbeddedPlayer.xap\" \/><param name=\"enableHtmlAccess\" value=\"true\" \/><param name=\"initParams\" value=\"id=210557,start=0,end=1182\" \/><param name=\"background\" value=\"white\" \/><param name=\"minRuntimeVersion\" value=\"3.0.40818.0\" \/><param name=\"autoUpgrade\" value=\"true\" \/><a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" target=\"_blank\" href=\"http:\/\/research.microsoft.com\/apps\/video\/default.aspx?id=210557\" style=\"text-decoration:none;\"> <img decoding=\"async\" src=\"http:\/\/msrvideo.vo.msecnd.net\/rmcvideos\/210557\/i\/large.jpg\" style=\"border-style:none;\" alt=\" \" \/> <span class=\"sr-only\"> (opens in new tab)<\/span><\/a><\/object><\/p>\n<p>&ldquo;There are a lot of things that you can simplify compared with current database systems,&rdquo; Larson explains. &ldquo;We removed a lot of the overhead you have in a traditional database system, and we invented a lot of new algorithms to be able to exploit the fact that these are in memory and to be able to scale them to a very, very large number of processes. We need to scale to hundreds of processes.&rdquo;<\/p>\n<p>Zwilling takes time to discuss what that level of performance enables Hekaton to deliver.<\/p>\n<p>&ldquo;It excels in random lookups of data,&rdquo; he says. &ldquo;It excels in workloads that need very low latency&mdash;sub-millisecond measures in hundreds of microseconds&mdash;or even less latency to look up rows and to look up data in tables.&rdquo;<\/p>\n<p>The goals the collaborators had for the Hekaton project were lofty.<\/p>\n<p>\"We want to unlock the 10x, 20x, 50x gains for more applications,&rdquo; Zwilling says. &ldquo;We're going to go after the wider, broader applications.\"<\/p>\n<p>For more on their discussion, see the video above. For more background on Hekaton, read <a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" href=\"http:\/\/research.microsoft.com\/en-us\/news\/features\/hekaton-122012.aspx\" title=\"this story\" target=\"_blank\">this story<span class=\"sr-only\"> (opens in new tab)<\/span><\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tweet Posted by Rob Knies As SQL Server 2014 is released to manufacturing on March 18, one of the features that will be bolstering the new release, to be available to customers on April 1, are its in-memory solutions built directly into the product. These solutions began as Hekaton, a collaboration between the product team [&hellip;]<\/p>\n","protected":false},"author":0,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"msr-url-field":"","msr-podcast-episode":"","msrModifiedDate":"","msrModifiedDateEnabled":false,"ep_exclude_from_search":false,"_classifai_error":"","msr-author-ordering":[],"msr_hide_image_in_river":0,"footnotes":""},"categories":[1],"tags":[186833,194956,200985,201809,201811,201959,202765,202825,203151,203229,203993],"research-area":[],"msr-region":[],"msr-event-type":[],"msr-locale":[268875],"msr-post-option":[],"msr-impact-theme":[],"msr-promo-type":[],"msr-podcast-series":[],"class_list":["post-461","post","type-post","status-publish","format-standard","hentry","category-research-blog","tag-analytics","tag-channel-9","tag-column-store","tag-hekaton","tag-hekaton-breaks-through","tag-in-memory","tag-microsoft-research-luminaries","tag-mike-zwilling","tag-online-transaction-processing","tag-paul-larson","tag-sql-server-2014","msr-locale-en_us"],"msr_event_details":{"start":"","end":"","location":""},"podcast_url":"","podcast_episode":"","msr_research_lab":[],"msr_impact_theme":[],"related-publications":[],"related-downloads":[],"related-videos":[],"related-academic-programs":[],"related-groups":[],"related-projects":[],"related-events":[],"related-researchers":[],"msr_type":"Post","byline":"","formattedDate":"March 18, 2014","formattedExcerpt":"Tweet Posted by Rob Knies As SQL Server 2014 is released to manufacturing on March 18, one of the features that will be bolstering the new release, to be available to customers on April 1, are its in-memory solutions built directly into the product. These&hellip;","locale":{"slug":"en_us","name":"English","native":"","english":"English"},"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/posts\/461","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/types\/post"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/comments?post=461"}],"version-history":[{"count":1,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/posts\/461\/revisions"}],"predecessor-version":[{"id":261174,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/posts\/461\/revisions\/261174"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/media?parent=461"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/categories?post=461"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/tags?post=461"},{"taxonomy":"msr-research-area","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/research-area?post=461"},{"taxonomy":"msr-region","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-region?post=461"},{"taxonomy":"msr-event-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-event-type?post=461"},{"taxonomy":"msr-locale","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-locale?post=461"},{"taxonomy":"msr-post-option","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-post-option?post=461"},{"taxonomy":"msr-impact-theme","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-impact-theme?post=461"},{"taxonomy":"msr-promo-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-promo-type?post=461"},{"taxonomy":"msr-podcast-series","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-podcast-series?post=461"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}