locked
Migrating to SQL Server 2016 RRS feed

  • Question

  • We are planning to Migration all our MS SQL servers from 2014 to 2016.

    But we having some confusion while choosing Windows Server. We know that SQL 2016 supports Windows Server 2012 R2.

    But which is better either Windows Server 2012 R2 or Windows Server 2016?

    Please need your suggestions.

    Tuesday, January 10, 2017 9:37 PM

Answers


  • But which is better either Windows Server 2012 R2 or Windows Server 2016?

    Please need your suggestions.

    I on other hand would be bit cautious with win server 2016 because it is new release. I have seen a new release encountering some bug and causing issue, well one can say so can happen with 2012 r2 but that is just me.

    If you are looking OS for standalone I am not sure their is large diff between 2012 R2 and 2016 but if you are looking for cluster then you must go for Win server 2016


    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP

    • Marked as answer by VijayKSQL Friday, January 13, 2017 6:21 PM
    Wednesday, January 11, 2017 3:23 PM

All replies

  • you should select the most modern operating system - 2016.
    Tuesday, January 10, 2017 10:00 PM
  • Hello,

    SQL Server 2016 and Windows Server 2016 better together as the following resources suggest:

    https://channel9.msdn.com/Blogs/windowsserver/SQL-Server-2016-and-Windows-Server-2016-Better-Together

    https://assets.microsoft.com/en-us/SQLServer2016_WindowsServer_Better_Together_White_Paper.pdf   

    Hope this helps.



    Regards,

    Alberto Morillo
    SQLCoffee.com

    • Proposed as answer by Naomi N Tuesday, January 10, 2017 11:04 PM
    Tuesday, January 10, 2017 10:16 PM
  • Hi, long term return on investment (ROI) Windows 2016 would likely be the better option.

    You'll need to consider:

    - the new core licensing model used by Windows 2016

    - can your internal resources can cope with the new OS i.e. monitoring, backups, user training etc.

    - likely not a stable as older Windows 2012 R2 i.e. not as many patches have been released.

    • Proposed as answer by Naomi N Tuesday, January 10, 2017 11:04 PM
    Tuesday, January 10, 2017 10:50 PM
  • Hi,
    I suggest you use the latest OS - Windows Server 2016. However, if budget is a constarint Windows Server 2012 is still compatable and supported OS for MSSQL 2016.
    SQL Server 2016 has a critical pre-requisite for updated Visual Studio VC++ 2013 Runtime Libraries. To install or check if this update is required on your system, please see KB3164398.

    Here's a link that shows operating system requirements for different editions of SQL Server 2016.
    https://msdn.microsoft.com/en-us/library/ms143506.aspx#TOP_Principal

    Regards,
    Sunit
    • Proposed as answer by Naomi N Tuesday, January 10, 2017 11:04 PM
    Tuesday, January 10, 2017 10:51 PM
  • Thank you very much.

    What makes difference if i install SQL Server 2016 on Windows 2012 R2 and Windows Server 2016?

    Wednesday, January 11, 2017 3:17 PM

  • But which is better either Windows Server 2012 R2 or Windows Server 2016?

    Please need your suggestions.

    I on other hand would be bit cautious with win server 2016 because it is new release. I have seen a new release encountering some bug and causing issue, well one can say so can happen with 2012 r2 but that is just me.

    If you are looking OS for standalone I am not sure their is large diff between 2012 R2 and 2016 but if you are looking for cluster then you must go for Win server 2016


    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP

    • Marked as answer by VijayKSQL Friday, January 13, 2017 6:21 PM
    Wednesday, January 11, 2017 3:23 PM