Hi All,

The terible performance was caused by the query optimzer it decided to perform some merge joins in the slow plan and hash joins in the fast plan.

The problematic storage...

1) Have you done a wait stats and file IO stall analyses during both sets of runs?

Please see attached output,

2) Do you have vCPU Hot Plug enabled in VMware?

Hotplug is...