June 29, 2014 at 3:00 am
Just curious as to what the general feeling is amongst the community whether SQL 2008 R2 reaching the end of mainstream support is something to worry about or not.
The only differences I believe are no:
Free incident support
Warranty claims
Design changes and feature requests
Nothing there that particularly says, get yourself off SQL Server 2008 R2 is there?
June 30, 2014 at 4:46 am
Personally, I don't like being out of support because if you have some type of major issue, Microsoft may not help. Most of the time and in most circumstances, this won't matter. But it will matter when you're in an extreme situation. It's something I would strive to avoid.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 30, 2014 at 4:49 am
Fair enough Grant, thanks for your thoughts.
With 2008 R2 not going out of Extended Warranty until 2019, seems unlikely that the business I work for will consider upgrading anytime soon.
June 30, 2014 at 7:26 am
Yes, if you run into a bug OR a security issue comes up Microsoft will not code a fix for it.
Much like SQL 2000 is right now and SQL2005 will be next Summer.
June 30, 2014 at 7:26 am
if your system has been running stable for a few years with no issues, you are unlikely to hit new problems, and known issues and security fixes will still be covered.
Just ensure the business are signed up to the risk, albeit a low one.
---------------------------------------------------------------------
June 30, 2014 at 7:29 am
george sibbald (6/30/2014)
if your system has been running stable for a few years with no issues, you are unlikely to hit new problems, and known issues and security fixes will still be covered.Just ensure the business are signed up to the risk, albeit a low one.
Security fixes will NOT be written for new security holes! That is the case right now with SQL Server 2000.
June 30, 2014 at 7:57 am
SECURITY fixes are available during the extended support phase, caveat is you are on the latest service pack
---------------------------------------------------------------------
June 30, 2014 at 7:59 am
george sibbald (6/30/2014)
SECURITY fixes are available during the extended support phase, caveat is you are on the latest service pack
Yes, you are correct. I guess I was referring to after the extended support date in 2019.
June 30, 2014 at 8:01 am
I thought you might be when you mentioned 2000 and 2005.
---------------------------------------------------------------------
June 30, 2014 at 8:11 am
george sibbald (6/30/2014)
if your system has been running stable for a few years with no issues, you are unlikely to hit new problems, and known issues and security fixes will still be covered.Just ensure the business are signed up to the risk, albeit a low one.
Really? I mean, I agree, the risk itself is quite low, but the result of accepting that risk could be quite high. And I've never seen systems so stable that something doesn't make it go south at some point. I mean, just changes to data alone could lead to issues. Maybe I'm just paranoid.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 30, 2014 at 9:12 am
Grant Fritchey (6/30/2014)
george sibbald (6/30/2014)
if your system has been running stable for a few years with no issues, you are unlikely to hit new problems, and known issues and security fixes will still be covered.Just ensure the business are signed up to the risk, albeit a low one.
Really? I mean, I agree, the risk itself is quite low, but the result of accepting that risk could be quite high. And I've never seen systems so stable that something doesn't make it go south at some point. I mean, just changes to data alone could lead to issues. Maybe I'm just paranoid.
well thats why you have a risk register, so everyone is aware of the risk, and the impact of that risk happening, but its not high\high. if a system has been working fine for a long period the risk of hitting a new, unknown bug with a major impact you cannot get a fix for is low, and personally that is how I feel I have to present it to the business.
We are talking going into extended support here rather than totally out of support.
there are all sorts of variables that come into play here, such as system complexity, importance, features used, in-house or third party, business aversion to upgrade costs (and riske), which make an upgrade or not decision anything but black and white.
---------------------------------------------------------------------
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply