• Thanks for reply.

    I think I have narrowed down the problem to be something to do with the multiprocessor setup. I had a look at the execution plan for the queries and store procedures used in the application on the server machine. None of them were using any kind of parallelism. As such, only the single slower cpu was being used and hence the slower results.

    Now the problem is to find out how to make better use of the multiprocessor environment..