Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Blocking on Select

Status
Not open for further replies.
andreis

andreis

Programmer
Apr 19, 2001
169
US
Hi:
We tested our application in production environment and noticed a lot of blocking on SQL 2000. The most puzzling thing is that there are blocking caused by select statements, is this possible? Select * from MyView blocked some other select - can SQL do it or it can be some transaction wrapping from JBOSS? How can we find out?
Thanks.
Andrei
 
Sort by date Sort by votes
Blocking can be such a pain ! I'm afraid there is rarely a single easy answer to this type of problems. Read about it in the online Microsoft Knowledge base article 224453. It contains info about what causes blocking and how to monitor/resolve it.
Good luck in solving your problem,
Patrick
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

leifoet
  • Locked
  • Question
Error in Select query
Replies
14
Views
280
Andrzejek
Andrzejek
grnzbra
  • Locked
  • Question
SELECT TOP 1 of Each of a Group
Replies
5
Views
167
grnzbra
grnzbra
Auguy
  • Locked
  • Question
Using UDF In Select, Bad Idea? 2
Replies
3
Views
149
Auguy
Auguy
grnzbra
  • Locked
  • Question
Is "IF EXISTS()..." better than "IF (SELECT COUNT...) > 0"
Replies
4
Views
1K
gmmastros
gmmastros
TheBugSlayer
  • Locked
  • Question
Transaction with SELECT and UPDATE with XLOCK causing deadlocks 2
Replies
10
Views
337
gmmastros
gmmastros

Part and Inventory Search

Sponsor

Back
Top