August 23, 2011 at 3:23 pm
Anyone seen extreme blocking from sp_procedure_params_managed?
There is an extensive amount of blocking that started yesterday from this. On Friday I had triggered an update statistics if that means anything. It seems as though the cache isn't holding what it needs to for query execution or the session eneds to wait for another user to finish their call... even on a proc full of nolocks that only does reads being blocked by another session calling it. Also, on Friday, I had called sys.sp_refreshsqlmodule for many objects, if that makes any difference. I did not see this much blocking yesterday.
spidblkbytransactsqlDBCCInputbuffer
51228NULLsys.sp_procedure_params_managed;1
14251NULLsys.sp_procedure_params_managed;1
15451NULLsys.sp_procedure_params_managed;1
17651NULLsys.sp_procedure_params_managed;1
228 .stored procedure textstored procedure call
24551NULLsys.sp_procedure_params_managed;1
August 24, 2011 at 8:06 am
On top of that, I was looking over stored execution plans and poof... all were wiped out. No one online did a freeprocache or other database equivalent, but the cache was wiped out. A few minutes later, a thousand entries back in place and growing, but not sure as to why the cache was just dropped all together.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply