Windows 2016 Standard doesnt have Storage Spaces Direct (S2D), and it has lower virtualization limits, as a host.Only certain combinations of SQL Server and Windows Server are officially supported by Microsoft, but tracking down this information is a little tedious.
Table 1 shows these possible combinations and whether they are officially supported by Microsoft. ![]() Perhaps this is less surprising if you keep in mind that SQL Server 2012 will fall out of mainstream support on July 11, 2017, which is not that far away. Table 1: OS Support for Recent Versions of SQL Server The available links that document this are listed below: Hardware and Software Requirements for Installing SQL Server 2008 R2 Hardware and Software Requirements for Installing SQL Server 2012 Hardware and Software Requirements for Installing SQL Server 2014 Hardware and Software Requirements for Installing SQL Server (for 2016 and later) If you are getting ready to deploy a new instance of SQL Server 2014 or SQL Server 2016, then you should prefer Windows Server 2016, even though they are also supported on older operating systems. If you are getting ready to deploy a new instance of SQL Server 2008 through SQL Server 2012, then you should prefer Windows Server 2012 R2, even though they are supported on older operating systems. Finally, if you are getting ready to deploy a new instance of SQL Server 2005, then I feel a little sorry for you SQL Server 2005 is out of extended support, and it is missing so many useful features that were added in newer versions of SQL Server. Actually, I recently helped a client deploy some new instances of SQL Server 2005 for some pretty valid business reasons. We ended up deploying to a VM (on new, very fast host hardware) that was running Windows Server 2008 R2, which worked perfectly fine. Related Posts Using Windows Resource Monitor to Find Unusual Performance Bottlenecks SQLskills SQL101: Using DDL Triggers SQL Server Diagnostic Information Queries for May 2018 SQL Server Diagnostic Information Queries for June 2015 AES-NI Encryption Support in SQL Server 2016 Posted in: SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SQL Server 2016, Windows Server 2008 R2, Windows Server 2012, Windows Server 2012 R2, Windows Server 2016 24 Comments 24 Responses to Operating System Support for SQL Server Versions Ben Harding says: January 12, 2017 at 7:58 pm Hi Glenn, The following KB does state that SQL 2012 (with SP2) is supported on Windows Server 2016. Reply Glenn Berry says: January 13, 2017 at 6:55 am Most other Microsoft links (and some senior people at Microsoft) have stated that SQL Server 2012 is not officially supported on Windows Server 2016. Thanks Reply Sumac says: April 6, 2018 at 6:07 am Hi Glenn, Did you ever find out anything about SQL Server 2012 support on Windows Server 2016 and the link above showing where it is supported Reply Ian says: February 19, 2019 at 8:20 am SQL 2012 and 2014 are definitely supported on WS 2016 with appropriate service packs. Reply Mayur N. says: March 3, 2017 at 8:14 am Thanks for this excellent post, Glenn. The table above for WS 2012 was precisely what I was looking for. ![]() Your post has most likely rescued me from hours of digging through MSDN links to figure this out. Reply Tony Ferraz says: March 23, 2018 at 12:27 pm Hi Glenn Congratulations for the excelente post. Do you have any other article or tips on how can I find it out Regards Reply Glenn Berry says: March 28, 2018 at 6:24 am You need Windows Server 2012 or newer to run SQL Server 2017. Reply Matt Cote says: September 27, 2018 at 4:37 am Are there any important improvements to be had if using Windows Server 2016 instead of 2012 for SQL Server 2017 I couldnt find anything in the official documentation to suggest this. Reply Glenn Berry says: September 27, 2018 at 7:33 am Windows Server 2016 has a higher OS memory limit than Windows Server 2012 R2 (but that wont affect most people). Windows Server 2016 supports Intel Speed Shift (with a Xeon Skylake-SP processor or newer). Windows Server 2016 will also be supported for a longer period of time. Reply Vassilis Ioannidis says: June 1, 2018 at 6:30 am SQL Server 2014 runs on anything Just an observation I needed to share Very helpful post, Glenn Reply Dale Kerr says: December 17, 2018 at 7:53 pm Linux Reply Bon says: August 2, 2018 at 10:40 pm is there a way to run SQL 2008 R2 to Windows Server 2016 Reply Glenn Berry says: February 14, 2019 at 1:35 pm No, that is not supported. Sql 2008 R2 Sp1 Install It OnReply Eric Heineke says: April 25, 2019 at 1:46 pm I have found the Microsoft states that SQL Server 2016 Service Pack 2 is supported on the following operating systems: Windows 10, Windows 8, Windows 8.1, Windows Server 2008 R2, Windows Server 2008 R2 SP1, Windows Server 2012, Windows Server 2012 R2, Windows Server 2016 ( ), but when trying to install it on Windows Server 2008 R2 SP1, you will get a message that the operating system or its service pack level do not meet the minimum requirements. So it appears this is correct, but that Microsoft is publishing incorrect information. Reply Richard says: March 15, 2019 at 12:25 pm Assuming SQL2016 Enterprise any meaningful differences between Windows2016 Standard and Windows 2016 Data Center Reply Glenn Berry says: March 15, 2019 at 12:35 pm Not for most SQL Server usage.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |