Diffrent performance on diffrent connections

[3270]

Hi

Im trying to measure the performance on some changes im going to make.

So i created a script which calls some stored procedures, in a while loop. When run the script from the query analyzer, a round trip in the while loop takes about 3,5 seconds. I then make 3 other connections, and start all 4 connections (with the same script)as fast as i can.

Now a round trip for one of the connections is still 3,5 seconds while the other takes about 12 seconds!

How can it be? I tried from 2 diffrent machines, with the same result. The SQL server is installed with sp4 and is an Enterprise version.

 

[vongrunt]

Locking perhaps?

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[3270]

I found the error, just had to disable "shared memory protocol"