Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server 2014 Expand / Collapse
Author
Message
Posted Thursday, May 1, 2014 10:37 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, August 21, 2014 5:44 PM
Points: 92, Visits: 820
What are the issues noticed while upgrading from SQL Server 2008 R2 to SQL Server 2014? What is the configuration recommendation etc. What is the difference between SQL 2008 Vs 2014?
Post #1566780
Posted Friday, May 2, 2014 7:50 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, August 21, 2014 5:51 AM
Points: 50, Visits: 265
I have upgraded many SQL instance of 2008 (not R2) and didn't get any issues..

The main difference between 2008 and 2014 would be it's new In OLTP memory engine which increases the performance upto 20x..

There are tons of articles over the internet for this

Post #1567035
Posted Saturday, May 3, 2014 4:14 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 6:45 AM
Points: 15,661, Visits: 28,049
The core setup for a 2014 server isn't going to be any different than for a 2008 server. After that, it completely depends on if you're using functionality that wasn't present in 2008 such as Availability Groups, Columnstore indexes, In-Memory OLTP, etc.

There is one principal difference that's going to be noticeable to everyone. 2014 introduces a new cardinality estimator within the query optimizer and statistics generator. That's going to possibly result in lots of changes in behavior to lots of queries. You can turn it off by leaving your databases in 2012 or earlier compatibility mode, but then you can' use any of the other 2014 features.

As to what's new, it's in the documentation.


----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1567240
Posted Wednesday, May 14, 2014 9:08 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 15, 2014 4:59 PM
Points: 3, Visits: 21
I am planning on upgrading to 2014 from 2008r2. Would I be able to leave my databases at 2008r2 release or will I need to upgrade them as well? I knwo that you mentioned that you could leave them at an earlier release like 2012 but my boss is asking me to make sure.
Post #1570894
Posted Wednesday, May 14, 2014 9:28 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 9:59 AM
Points: 33,191, Visits: 15,332
You can leave them at SQL 2008 R2. Set the compatibility mode down level (< 120). If you are lower than 120, the cardinality estimator remains the same as previous versions. Same for keywords and functionality.

You can read a bit more about backwards stuff here: http://msdn.microsoft.com/en-us/library/ms143532(v=sql.120).aspx







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1570906
Posted Wednesday, May 14, 2014 10:53 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 15, 2014 4:59 PM
Points: 3, Visits: 21
Thanks for that information. I am new to the DBA arena and did not want to set myself up for failure. Thanks again!
Post #1570951
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse