Sorry didn't know where to put this question. We have implemented service
broker on a database. The question I have is that has anyone come across an
issue when using the Service Broker that after a while the database gets
"locked", in the sense when I try to look at the tables when something is
being processed from Service Broker. I get this this dialog box "Lock
request time out period exceeded"

Any one have any ideas what is causing this and how to fix it
Thanks in advance

Toby (Toby (AT) discussions (DOT) microsoft.com) writes:
How do you look at the tables? The message you relate comes from a lock
timeout which is controlled by SET LOCK_TIMEOUT, and which by defalt is -1,
which means wait forever.

It is highly unlikely that Service Broker itself is the culprit, but it
is of course not unlikely that your activation procedures causes blocking.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

I agree with with Erland's diagnosis that SB activated procedures are the
likely culprit. Review the execution plans for query and index tuning
opportunities.

--
Hope this helps.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/