August 28, 2019 at 12:41 am
I am hoping you can help solve a problem in my environment.
The Server administrators decided to upgrade the VMWare from 5.5 to 6.7. They updated the VMware tools, vmotioned the servers to larger LUNs and made other changes that I frankly do not know about or even deal with.
The problem is that after the upgrade my SQL Server does not perform as well. More specifically, I have an SQL Maintenance plan that performs an SQL native backup and copies the files to another server where they are restored. For some reason, after the upgrade, this job that used to take about 4 hours is now taking 12 hours to complete. I also performed a disk Read and Write baseline before the move and then after and the latency numbers are not a good as before but not terrible - I an not getting any complaints from the users about application performance so far.
The administrators want to change the disks to Thick provision Eager Zero to see if that helps. I also tried taking a backup of a 1GB database and the throughput was about 20MB/sec and I do not think this is good.
Could there be an issue with SQL server suddenly - maybe its not compatible with the new version. Do you have any ideas about what can be checked?
Any help is appreciated.
Jeff
August 28, 2019 at 12:37 pm
Possibly there are more VM's on the larger luns and there isn't so much bandwidth available for the SQL vm's? On a system I used to administer I found there were two backups running at the same time (one file server and the SQL server) and it maxed the network bandwidth. It wasn't noticeable on user requests but it was on the backups.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply