I am trying to make to a blocking monitor using sys.dm_exec_sql_text. But on some occasions the Blocking monitor, which should take less than a second, take up to 10 seconds. By placing statements throughout the blocking monitor query to put entries
into a table with the time of execution, I've narrowed it down to the cross apply of the sys.dm_exec_sql_text statement.
I was wondering if its possible that this statement could get blocked
View Complete Post