SQL Server with Mr. Denny:

ASPState

1

March 9, 2009  11:00 AM

Handy script for use when looking at blocking



Posted by: Denny Cherry
ASPState, Blocking, sys.dm_exec_sql_text, sys.sysprocesses

A while back I was looking at a clients database and we were looking at why the ASPState database was having blocking issues.  So I through this script together to show not only the blocked processes, but also the blocking processes, but also include the name of the stored procedure as well as the...

1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: