Posted by loosecannon_1@yahoo.com on 12/08/05 17:23
I get a 90-120 second blocking when send 15 or so simultaneous queries
to SQL Server 2000 that query a view made up of two joined tables.
After each query is blocking for the same amount of time they all
return. Further identical queries of this type work in 3-4 seconds
(caching?) until hours later where it happens again. If I query the
tables directly (without the view) I still get the same blocking. If I
remove the join (it is a simple inner join on two columns) I do not get
the blocking.
Any ideas?
Navigation:
[Reply to this message]
|