HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Windows Server version and SQL Server

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
versionsqlandwindowsserver

Problem

Is there a blog / webpage / information (I did not find anything) out there, if it has performance benefits, if I use a newer Windows Server version for my SQL Server?

Example: I run SQL 2016 on a Windows Server 2012. Does it make sense to update this server to Windows Server 2016 or the upcoming Windows Server 2019 beside those out-of-support lifecycle topics? Does it make a difference, if I install a new SQL Server 2019 (if it is out) on Windows Server 2016 or Windows Server 2019?

PS: The only point I found to this topic was that - if I want to use NVDIMMs I should use Windows Server 2016 for better support.

Solution

There would not be any noticeable performance benefit if you move to higher version of windows server. Normally people move to higher version keeping support in perspective and the host of new features they get in newer version of windows. Refer Compare features in Windows Server versions to see list of new features you get in various versions of Windows Server.

Context

StackExchange Database Administrators Q#237739, answer score: 4

Revisions (0)

No revisions yet.