{"id":3575,"date":"2016-10-20T18:10:53","date_gmt":"2016-10-20T18:10:53","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/premier_developer\/?p=3575"},"modified":"2019-02-14T20:27:52","modified_gmt":"2019-02-15T03:27:52","slug":"sql-server-2016-it-just-runs-faster","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/premier-developer\/sql-server-2016-it-just-runs-faster\/","title":{"rendered":"SQL Server 2016: It Just Runs Faster"},"content":{"rendered":"

Does the marketing live up to the hype?\u00a0 Senior ADM, Paul King<\/a> shares some perspective from the field.<\/p>\n

\n

\"image\"<\/a>Upgrading between major versions of a product can sometimes be a painful and time consuming task.\u00a0 Development organizations often have to spend time going over depreciated feature lists to make sure that their applications will still work.\u00a0 Many times, unless there is a new feature in the latest and greatest version of a product, companies are not compelled to upgrade their applications.<\/p>\n

Part of the marketing message around SQL Server 2016 is \u2018It Just Runs Faster\u2019.\u00a0 Sounds great doesn\u2019t it?\u00a0 Well, I want to tell you that this is one marketing claim that rings true!<\/p>\n

My customer was working on an application as a proof of concept.\u00a0 This was a new application that had a database with very wide tables with very few joins.\u00a0 While the proof of concept only used about 200GB of data, it was a good sample of the type of data the application would work with.\u00a0 The application was originally written against SQL Server 2012, the same version of SQL that is powering most of the applications the customer has today.<\/p>\n

During testing, they found that some of the queries were taking around 60 seconds to complete.\u00a0 Not happy with those results, they upgraded from SQL Server 2012 to SQL Server 2016.\u00a0 With no other application or index changes, the same queries were completing in 30 seconds.\u00a0 That\u2019s a 50% improvement in query speed!\u00a0 My customer is now looking to upgrade all of their existing SQL Server 2012 databases to SQL Server 2016.<\/p>\n

While every application may not improve this dramatically, it shows that a simple upgrade and test may be well worth it in terms of performance.\u00a0 If you would like additional information, Bob Ward posted a video of a talk he just gave and Microsoft Ignite: Upgrade to Microsoft SQL Server 2016:\u00a0 It Just Runs Faster<\/a>.\u00a0 In addition, Robert Dorr published a series of posts covering the technical details behind some of these performance improvements.\u00a0 Learn more here<\/a>.<\/p>\n

<\/h6>\n
\n

Premier Support for Developers<\/strong><\/a> provides strategic technology guidance, critical support coverage, and a range of essential services to help teams optimize development lifecycles and improve software quality.\u00a0 Contact your Application Development Manager (ADM) or email us<\/a> to learn more about what we can do for you.<\/p>\n","protected":false},"excerpt":{"rendered":"

Does the marketing live up to the hype?\u00a0 Senior ADM, Paul King shares some perspective from the field. Upgrading between major versions of a product can sometimes be a painful and time consuming task.\u00a0 Development organizations often have to spend time going over depreciated feature lists to make sure that their applications will still work.\u00a0 […]<\/p>\n","protected":false},"author":582,"featured_media":37840,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[8],"tags":[12],"class_list":["post-3575","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data","tag-sql-server"],"acf":[],"blog_post_summary":"

Does the marketing live up to the hype?\u00a0 Senior ADM, Paul King shares some perspective from the field. Upgrading between major versions of a product can sometimes be a painful and time consuming task.\u00a0 Development organizations often have to spend time going over depreciated feature lists to make sure that their applications will still work.\u00a0 […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/posts\/3575","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/users\/582"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/comments?post=3575"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/posts\/3575\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/media\/37840"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/media?parent=3575"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/categories?post=3575"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/tags?post=3575"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}