Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

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



Group: General Forum Members
Last Login: Friday, August 5, 2016 10:50 AM
Points: 2,922, Visits: 8,967
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