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, November 18, 2016 12:42 PM
Points: 2,947, Visits: 9,054
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