Madeira Data Solutions

Your Data, Our Solutions

We Must Wait for SP1 before Upgrading to SQL Server 2016

Written By: Guy Glantser 14/06/2016

This post is for T-SQL Tuesday, hosted by Michael Swart (blog | twitter). This month’s topic is all about SQL Server 2016

download

I’ve been working with SQL Server for almost 20 years, since version 6.5, when we used the SQL WWW Page Wizard to publish data on the web, and when nobody have heard about user-defined functions. There were a lot of major versions and minor versions of SQL Server since then, until these days, when SQL Server 2016 has just been released with new exciting features like PolyBase and Query Store.

Picture 1

Throughout my career I have always heard people repeat the same mantra: “We must wait for SP1 before upgrading to SQL Server X”. And I’m still hearing these words today with SQL Server 2016. People who claim that it’s a bad idea to upgrade to a RTM version of the product usually claim that the RTM version is not stable enough, because it was only tested in Microsoft labs, but it was never tested on real-life databases and applications. They believe that SP1 will fix all the critical issues that will be discovered during the first wave of adoption with the RTM version.

 

I have never agreed with this claim, but in my first years as a DBA I didn’t have enough experience and confidence to claim otherwise, so I just assumed those people know what they’re talking about. But I still didn’t believe in it. Today, with SQL Server 2016 and with experience of 20 years and 8 major SQL Server versions, I am confident that there is no reason at all to wait for SP1. I have 3 reasons for this…

 

 

  1. Historical Facts

Throughout my career I have never seen an RTM version that was substantially less stable then the following SP1. Sure, there were bugs and issues. Sometimes there were critical bugs and issues. But there were just as much bugs and issues in SP1 and in SP2, and so on. I haven’t conducted a thorough research, so I don’t have a statistical proof, but these are the facts, at least from my experience.

 

  1. The First Cloud-First Version

Remus Rusanu (Blog | Twitter) wrote a blog post about why he has high hopes for the quality of SQL Server 2016 RTM release. Remus explains that SQL Server 2016 is the first major version, which is truly cloud-first. This means that the way the dev team has been working on this version is completely different than previous versions. As new features were developed, they became live in production in the Azure SQL Database service about 2 months after development was completed. Every single feature in SQL Server 2016 has been in production in Azure SQL DB for likely more than a year by now, so SQL Server 2016 RTM has already been well tested on lots of real-life databases and workloads.

 

  1. What’s between a Service Pack and a Cumulative Update?

A few months ago, the SQL Server engineering team announced an update to the SQL Server Incremental Servicing Model (ISM). The main message is that from now on cumulative updates are tested and generally treated by Microsoft just like service packs. Microsoft now recommends ongoing proactive installation of CU’s as they become available. So service packs actually have no special meaning from now on. In my opinion, Microsoft should remove service packs from the release cycle in order to simplify the process and avoid confusion. So this is another reason why you shouldn’t wait for SP1. If you insist, wait for CU1…

 

Every time I hear someone saying they must wait for SP1, I spend some time explaining my point of view. Now I won’t have to do it anymore. I’ll simply send them a link to this post. You can do it too…

 

shutterstock_264671855

 

2 responses to “We Must Wait for SP1 before Upgrading to SQL Server 2016”

  1. knarfalingus says:

    https://blogs.msdn.microsoft.com/bobsql/2016/06/15/sql-2016install-msvc-patch-required/

    I think I’ll wait a few months 🙂

    I agree that Waiting for SP1 is not the thing to do anymore only in that SP1 seems to come out much later than it used to when I first started working with SQL (6.5 in 1996). Doing some googling I see SP5a for 6.5 shipped in 1998 with an RTM in June 1996, so that’s five SP’s in two years, compared to SQL 2014, which didn’t ship SP1 until almost 13 months later. Similar for 2008R2, although for 2012, SP1 was only 6 months later, so perhaps they bungled something there (skipped it).

    But I’ll still wait a few months and scour the message boards first before I upgrade to a cumulative update, which in a way isn’t too different than it used to be with SP’s back in the day

  2. To be clear, Guy talks about why the wait-for-sp1 advice doesn’t apply.
    What I Thought: One sentence Guy wrote struck a chord with me: “I have never agreed with this claim, but in my first years as a DBA I didn’t have enough experience and confidence to claim otherwise, so I just assumed those people know what they’re talking about.” Wow, I’ve recognize that feeling. All I can say is that when you get past that feeling. That’s a really really good sign.

Leave a Reply

Your email address will not be published. Required fields are marked *