I have a 10 year old Dell Poweredge 2950 that will be replaced with a Dell Poweredge R820. Both of these machines are set up as a Virtual Machine Host Running Hyper-V. Both Operating Systems are Windows Server 2012 R2 Standard x64 Bit. I have MSSQL Standard database that has been virtualized and is currently hosted on the 2950.
I recently migrated MSSQL from the 2950 over to the R820 but noticed MSSQL queries are a lot slower on the new R820 machine. These queries are being executed locally from the server and the database is also local so, it is definitely not network related. When we run the query on the 2950, it takes about 1-2 seconds for results. When the same query is executed on the new R820 however, it takes about 4 seconds. I really think its a hardware issue since all of the settings are identically configured as its a virtual machine and the same OS.
Here are some hardware specs of both machines:
- Dell Poweredge R820
- Processor: Intel(R) Xeon(R) CPU E5-4620 0 @ 2.20GHz (2 Processors) @ 32 Cores
- Ram: 56GB DDR3
- 4 Intel SSD RAID-10 Config With Dell PERC H710P Adapter
- Read Policy: Adaptive Read Ahead; Write Policy: Write-Back; Disk Cache: Enabled
- Dell Poweredge 2950
- Processor: Intel(R) Xeon(R) CPU X5450 @ 3.00GHz (2 Processors) @ 8 Cores
- Ram: 8GB DDR2
- 4 Seagate HDD 10K RPM RAID-10 Config With Dell PERC 6/i Integrated
- Read Policy: No Read Ahead; Write Policy: Write-Back; Disk Cache: Disabled
Any ideas on what could cause a 2 month old machine with SSDs and a good Raid Controller card to run slower than a 10 year old machine? the R820 SHOULD be running circles over the 2950.