george sibbald (1/21/2009)
a long thread here but I don't think this has been asked\answered -the article mentioned that VM streamlines the DR process, but for that to be fully true the SAN would have to be mirrored as well, yes?
for what its worth we have hit performance problems on VMWARE, this was with a fairly small (20GB ) but heavily used database. I was not involved in the design of the solution (sigh) but I understand it is an up to date version of vmware but all vms on the box were sharing the same LUN, so the problem was likely the SAN set up?
Was the max degree of parallelism greater than 1 on your instance?
VMs do not handle parallelism well, from what I have heard. This could partly the problem here.
Jonathan Kehayas has actually mentioned this earlier in this thread.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]