Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Deadlocks and metadata locks Expand / Collapse
Author
Message
Posted Wednesday, December 19, 2012 2:42 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, November 22, 2013 10:13 AM
Points: 79, Visits: 200
I have a deadlock situation that I am having some difficulty understanding. Attached is the deadlock graph - I am trying to understand why we see so many metadata locks. Is a metadata lock the same as a Schema lock ? I think not, but the Object ID in the matadata lock actually belongs to a user table(not system tables/management views).

I would appreciate any insights anyone may have as to what exactly a metadata lock is and why does SQL Server use them ?


  Post Attachments 
DeadlocksInfo.zip (5 views, 5.53 KB)
Post #1398680
Posted Thursday, December 20, 2012 8:58 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, November 22, 2013 10:13 AM
Points: 79, Visits: 200
No one ? Not even Sean ? Gila ? GSquared ?
Post #1399027
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse