Thanks everybody for feedback!

Igor

Lowell,

Sorry, I didn't make myself clear. Client computers are not in the 'outside world'. They are within different subnet. Our network guys configured traffic so that it...

Roy,

I fixed the problem by executing (found somewhere in the posts):

ALTER AUTHORIZATION ON DATABASE::<DBName> to sa

Thanks,

Igor

Hello Jonathan,

Thanks for you reply. Yes, I tested typical sp calls and in some cases results were almost identical in others SQL 2008 was slower (but never...

Hello!

SQL 2005 Cluster doens't have a shared LUN. That's why I was checking repetitive executions when data pages are loaded in memory and no disk IO involved...

I actually tested database on another node (this is Active/Active). Second node has the same number of CPUs (slighly better characteristics on 2005 server) and RAM (32GB) by running...

Jonathan!

I collected Client Side statistics from 2005 and 2008 servers while executing query returning 500K rows from local and remote (on the same network) clients :

SQL 2008 (local client) ...

Thank you, Jonathan! I will report additional information and results on Monday!

Have a great weekend,

Igor

Thanks Gail! I actually found nice script in Itzik's book.

Thank you for your feedback!

Igor

Thanks Bru!

Thanks a lot, Leo! Could you please elaborate on 'I strongly recommend you Slipstream service pack 1'? Do I install SQL 2008 and then SP1? I read that Slipstream functionality...

Thanks Leo!

Thanks!

Thank you so much, Gail! It worked like a charm.