Windows Server 2012 R2 vs Windows Server 2008 R2

  • Hi

    Is there an advantage of running SQL 2012 Ent on Windows Server 2012 R2 vs Windows 2008 R2?

    Thanks

    Steven

  • I read a blog post[/url] by Kendra Little that there are a bunch of advantages when implementing clustering/Availability Groups.

    We're in the initial stages of planing our first availability group and I think we're going to take her advice and put it on at least server 2012, if not 2012 R2.

    Jim

  • Would it make a difference that our severs are all virtual in our VMWare enviroment?

  • I don't think so, as we would have the same configuration (cluster across VMs). However, since SQL 2014 is now RTM I might see if we can jump to that.

    Jim

  • Apart from the vastly improved SMB process which impacts network IO and any Named Pipes processing, the improved IO process, the ability to turn Core mode on and off, and if you use Hyper-V the much improved performance with vhdx files in W2012 and W2012R2, not a lot.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

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

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