Hi

Thanks for everyones comments.

We have it working now and have taken on board all the tips.

Again thanks.

Hi

It turned out to be the sql optimzer deciding not to use more than one CPU. Our DBA made a change by adding a hash join and this appears...

Ok I see your point.

I am no fan of Hyperthreading in general, it is only on because by default HP enable it and the performance of the server was great...

Yes affinity is set correctly.

I have arrived in work today and the DBA has informed me it is now all working. Neither him or I have done...