troubleshooting Question

Slow performance on Windows 2016 Server

Avatar of Marka Mekapse
Marka MekapseFlag for United States of America asked on
DatabasesWindows OSWindows Server 2016SQL
3 Comments1 Solution144 ViewsLast Modified:
Recently migrated SQL database from 2008 to 2016 (SQL 2008 to SQL 2014); the issue appears to be on the Operating System as i have run several tests that prove this.  I run a simple script that runs a for loop counting from 1 to 16000 to emulate a rudimentary write to disk. When i run this script on a 2016 server it takes almost 6 minutes to complete where as it is instantaneous on a windows 2008 server.  

The purpose of the test was to prove that there is additional overhead on a Server 2016 box versus the 2008.

1.      2008 server
      a.      On the <host> network
            i.      Result = instant
      b.      Off the <host> network
            i.      Result = instant

2.      2012 server
      a.      On the <host> network
            i.      Result = 35 seconds
      b.      Off the <host> network
            i.      Result = Test 1 - 15 seconds (SSD) ;
            ii.      Result = Test 2 - 29 Seconds

3.      2016 server
      a.      On the <host> network
            i.      Result = 5 minutes
      b.      Off the <host> network
            i.      Result = 6 minutes

We know it is not the disk or the amount of memory and CPU
Is there anything i can do to the windows server 2016 box to increase its performance and remove the "overhead"???

Server OS is Server 2016 - 4 vCPU w 2 Cores & 50 GB Ram
Virtualization - Vmware 5.5 U2
SQL server 2014

here is my script that i have been testing with
#Powershell Script#
$file = "C:\testlog.txt"
Remove-Item –path $file

$d = Get-Date -Format G

Write-Output $d >> $file

    $i -le 16000 
       Write-Output $i >> $file

$d = Get-Date -Format G

Write-Output $d >> $file
Adam Brown
Cloud Security Consultant
Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros