SQL Server 2014

Question

SQL Server 2014

Admingod

SSCertifiable

Points: 5997
More actions
May 1, 2014 at 10:37 am

#306950

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?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Ashif Shaikh Default port Points: 1445 More actions · Answer 1

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

🙂

Grant Fritchey SSC Guru Points: 398679 More actions · Answer 2

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

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

james.murphy 76104 Valued Member Points: 67 More actions · Answer 3

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.

Steve Jones - SSC Editor SSC Guru Points: 734418 More actions · Answer 4

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

james.murphy 76104 Valued Member Points: 67 More actions · Answer 5

Thanks for that information. I am new to the DBA arena and did not want to set myself up for failure. Thanks again!