benjamin.reyes (7/30/2012)

---

What kind of wait types are you getting on both servers while the query is running?

The only wait I can see in the Activity Monitor is PREEMPTIVE_WAIT_GETDATA.

Are all sql server, server wide settings and database settings the same?

Yes

Are both vm's on the same host machine?

I don't know. I will have to check with our server admins, however I don't thinkk they are.

Also in vSphere you should have a resourse allocation tab, a performance tab, and a tasks & events tab; double check to make sure you aren't overcommitted on resources and that the configurations are the same for both machines. The performance tab should give you a logged view on utilization, and the tasks and events tab will just to get a rough idea that there aren't any serious conflicts.

Again, I will have to check with out server admins.

What does the drive/san architecture look like?

Out default set-up is a seperate drive for backups, transaction logs, database files, and install binaries.

What are you doing with the tempdb?