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

sys.sp_sproc_columns Causing Blocking ?! Expand / Collapse
Author
Message
Posted Tuesday, October 23, 2012 9:17 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 1:05 PM
Points: 2,834, Visits: 8,544
We just had an incident in which users across various databases suddenly were affected by blocking. I can usually track it down to a table lock or something, but this time it appears it was caused by "sys.sp_sproc_columns". I have a utility to log blocking events, and the blocker process is "sys.sp_sproc_columns;1"

Any thoughts or comments on this ? Sorry I don't have any more useful information yet.



Post #1376309
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse