Colin, i have never encountered changing the max degree of parallelism either.
george sibbald (1/21/2009)
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?
yes, ideally.
george sibbald (1/21/2009)
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
what version exactly?
george sibbald (1/21/2009)
but all vms on the box were sharing the same LUN, so the problem was likely the SAN set up?
all VM's sharing the same LUN? I'm guessing they werent all sql vm's? How many vm's and what type of services (file, application, sql)? As we know for performance you would want at least 3 separate storage areas for sql (OS, data and logs) thats without considering any othe rvm's that were hosted.
I would use processor affinity in VMWare with caution as cpu resource assignments could surpass the physical resources available, a classic example of this is virtualising a citrix server. Its also important to only use the minimum cpu resources and only implement SMP where it is actually used (SQL server for example)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉