Posted by Jack Vamvas on 10/15/07 08:39
Are you testing with the same basis: i.e cache cleared , clean buffers.Also
, are the statistics updated on both?
--
Jack Vamvas
___________________________________
Search IT jobs from multiple sources- http://www.ITjobfeed.com
"pramodbura" <pramodbura@gmail.com> wrote in message
news:1192422342.795840.169000@e34g2000pro.googlegroups.com...
> We have a quick query regarding SQL performance.
> We have SQL Server 2000 (32 Bit) and SQL Server 2005 (64 Bit) as two
> separate instances on a DB Server.
>
> We were analysing the execution times for the same stored procedure on
> both instances:
> 1. Through Remote Desktop of the actual DB server
> 2. Through Query Analyser of my local machine.
>
> The results were as follows:
>
> 1. Through Remote Desktop of the actual DB server
>
> Iteration SP Execution Time (in secs)
> SQL 2000 SQL 2005
> 1 28 5
> 2 27 3
> 3 27 3
> 4 40 3
> 5 38 3
> Average 32 3
>
>
> 2. Through Query Analyser of my local machine.
> Iteration SP Execution Time (in secs)
> SQL 2000 SQL 2005)
> 1 37 96
> 2 32 77
> 3 35 84
> 4 27 79
> 5 43 91
> Average 35 85
>
>
> Could you please provide some light on why case 2 is slow and any
> suggestions to improve the same?
>
> Thanks in Advance!
>
[Back to original message]
|