0

enter image description hereFull disclosure, I'm a VMware admin. We're trying to virtualize a SQL server that handles pricing information for multiple customers. Up until now, it has been a physical system with local SSDs. It's now running as a VM, Win 2016, 128GB memory, 6 vCPU (2sockets, 3 cores) against an all flash array. I/O has confirmed that this thing screams, storage admin says we're looking at very low latency, which confirms what I/O meter is seeing.

When it was physical, it performed a nightly process where it dumped table contents to a series of txt files per customer, then zipped those files up. Repeat again for the next customer.

On the physical system, files that are 250MB (text) would take around 6 seconds. On the VM they're taking around 60 seconds. I can tell the storage subsytem is in good shape. I've increased the queue depth for the vhba, and pvscsi controller as per vmware recommendations and no change.

My DBA's are saying "it worked on the physical server just fine, so it must be your system" If it is, there's no indication on my end that we're saturating the storage connections or running into resource contentions.

I'm attaching my sp_blitz and the subsequent results of the script that shows the wait for the various DBs... one is much higher than others.

sp_blitz

10
  • You should get more details from the DBAs - what is here isn't really useful for troubleshooting. Get timings and (where applicable) execution plans for each step of the described process and go from there. Have them double check their CPU and memory-related configurations on the instance (guessing this isn't a 1:1 hardware spec of the physical machine) as well. – LowlyDBA - John M Aug 2 '19 at 16:27
  • 2
    Run Crystal Disk Mark on the new drives and compare speeds. See my post here: brentozar.com/archive/2019/01/from-the-server-to-the-san – Erik Darling Aug 2 '19 at 17:02
  • 1
    @LowlyDBA - I completely agree. They haven't been very forthcoming, so i'm trying to put this DBA hat on myself. They are in Germany, so are one of their many holidays this week and most of next but I'm going to press them shortly. – Chrys Bundy Aug 2 '19 at 17:30
  • @ErikDarling - I believe that looks for physically attached disks. Not pulling any disks when ran on my server. – Chrys Bundy Aug 2 '19 at 17:31
  • @ErikDarling - I feel I'm missing something, as your demo in the blog is done via a VM. digs into documentation – Chrys Bundy Aug 2 '19 at 17:40

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.