hi,
Im getting exclusive locks on my table and ext is the resource locked......
.
can anyone explain me..why do we get ext locks on tables..
regardsjust means SQL server has identified a group of 8 pages(extent) for update i
nsert(most likely upadte and insert), create or drop destined for an exclusi
ve lock. More efficient than locking an individual page of a contiguous set
of 8 pages.|||They are most likely Intent locks and essentially help to prevent things
like deadlocks.
Andrew J. Kelly SQL MVP
"san" <anonymous@.discussions.microsoft.com> wrote in message
news:24647640-DE56-4A51-BAE5-74088CD31DE1@.microsoft.com...
> hi,
> Im getting exclusive locks on my table and ext is the resource
locked.......
> can anyone explain me..why do we get ext locks on tables..
> regards
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment