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

Windows Server 2012 R2 vs Windows Server 2008 R2 Expand / Collapse
Author
Message
Posted Tuesday, April 1, 2014 5:07 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 4, 2014 3:45 AM
Points: 6, Visits: 30
Hi

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

Thanks
Steven
Post #1556909
Posted Tuesday, April 1, 2014 6:20 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 8:52 AM
Points: 101, Visits: 1,346
I read a blog post 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
Post #1556937
Posted Tuesday, April 1, 2014 6:48 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 4, 2014 3:45 AM
Points: 6, Visits: 30
Would it make a difference that our severs are all virtual in our VMWare enviroment?
Post #1556950
Posted Tuesday, April 1, 2014 7:21 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 8:52 AM
Points: 101, Visits: 1,346
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
Post #1556967
Posted Friday, April 4, 2014 3:41 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 5:03 AM
Points: 2,900, Visits: 3,298
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: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005. 18 October 2014: now over 31,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #1558407
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse