|
|
Posted by Erland Sommarskog on 04/04/07 22:01
DzU (claudio@scartozzetto.it) writes:
> Yes, I run the query in two different session. It seems that the second
> wait for the first and then start running.
And the first window returns in 20 seconds, and the second 20 seconds later?
Unless you are using some XLOCK hints, I would rather suspect the network
communication. Or are you running these queries on the local server? What
happens if you run the two queries from two different clients.
On thing you could try is from a third window run sp_who2, and study the two
processes. I would expect both to consume CPU and physical IO.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|