You should be able to capture what is getting run via profiler, and run it on both servers and dig into what it's actually doing. I'd be sure to...

I did see some majore performance degredation on some specific queries on x64, specifically those that include NOT IN (SUBQUERY).

check your queires/sp's in question to see if that might be...

Ours was a Dell server, and the performance issues was drastic, dispite all the config changes I made, it made no difference.

Since you have two new servers, I'd look more...

We ended up changing out the MotherBoard and all the memory via Dell. The box is now performing as expected.

I've already verified the alignment, it all looks good to me.

BlockSize Index Name ...

The performance issue is related to tempdb, or at least it appears to be.

Tempdb, is on a dedicated RAID10, 64K Stripe element size, 64k cluster size when formated.

I've included an...

If I run the below select, with the 256 mg tempdb mdf's it takes 11 seconds to run, 4 on the production box, same table

Select *

into #temp

from table ...

I just had to try to see if I could reproduce the same results to get the slow performance.

I re-set all my initial tempdb mdf files back to 1024, restarted...

Can someone explain this one.

I had created 12 mdf files for tempdb, one per processor core, dual core 6 core procs.

I initially created the mdf files for tempdb at 1...