0

I am planning to upgrade my SQL Server 2008 R2 Standard Edition to SQL Server 2012 Standard Edition.

I had been through many blogs on advantages of 2012 but I didn't find any performance comparison of both the versions.

Are there any performance variations between the two versions?

What impact (if any) will 2008R2 and 2012 have on ability to service larger loads of data?

  • 1
    There is general guidance about your questions, but the reason you can't find anything concrete is because it depends. It depends on your hardware and the specific workload you're throwing at the server. Usually people will upgrade their hardware when upgrading SQL Server, so there's no way to make a direct performance comparison there. But why upgrade to 2012 when 2014 has been out for three years, and 2016 for 9 months? – alroc Mar 27 '17 at 11:24
3

Benchmarks aren't done as frequently as before, at least not publicly. This is true across the industry, not just SQL Server.

Internally, performance improvements are always pursued for each major release, though it may target some specific areas or something broader. One area that still gets somewhat regular updates are TPC-H benchmarks. Check out the TPC website and filter on SQL Server.

That said, you really should get your customer to reconsider their business preference on "upgrading" to SQL Server 2012. Mainstream support for 2012 SP3 ends in July 2017. See the Microsoft product support lifecycle search page for details.

That means they're investing in the upgrade for a product that is out of mainstream support within a year. The business might think it's ok, but make sure they understand the impact. Definitions of mainstream and extended support are documented in the Microsoft Business, Developer and Desktop Operating Systems Policy.

Fixes aside, some industries have specific requirements about only using products that are still in mainstream support so make sure your client is not affected there.

Try to get them on 2016 or at least 2014. You'd be doing your client a huge service.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.