Concurrency question

Any help here appreciated.

I ran a vacuum verbose analyze on a database over the weekend.  It ran fine
until it tried to vacuum a table less than 2000 pages.  It successfully
acquired a ShareUpdateExclusiveLock as I would expect.
There was an idle thread that had an AccessSharelock on the same table.
Compatible locks I would think. But the vacuum hung until the
AccessSharelock thread was cancelled - 11 hours in all.
This table normally vacuums in less than 15 seconds.   This AccessSharelock
came from a query that formerly was part of a transaction sent from a remote
server.  Could it be that it hung because it was
A transaction?   Even so I thought those lock types were compatible.


As always thanks for your time.

Mark Steben│Database Administrator│
@utoRevenueR "Join the Revenue-tion"
95 Ashley Ave. West Springfield, MA., 01089 
413-243-4800 x1512 (Phone) │ 413-732-1824 (Fax)
@utoRevenue is a registered trademark and a division of Dominion Enterprises