Posted by pramodbura on 10/15/07 04:25

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!

• Next in forum: Re: A probably over and over again asked question of Syntax - Help please
• Prev in forum: Re: How do I link a database in SQL
• Thread view: SQL execution slow over the network

[Reply to this message]