What is the recommended way to determine which connections are blocked by semaphores? The ReqStatus shows up as Executing and BlockedOn as zero...
LockObjectOID and LockObjectType connection properties.
sa_conn_info.LockObject and LockObjectType which are (?) pretty much the same thing.
sp_list_mutexes_semaphores.currently_waited_for, which appears to contain at least one victim's connection id.
...not sa_locks(), however, that only lists mutexes.
Are the currently_owned_by and currently_waited_for columns returned by sp_list_mutexes_semaphores() going to be changed to return Y/N/null like DCX says, or are they going to continue return a connection number like they do now?
What about mutexes and semaphores that block multiple victims? (that makes Y/N seem the likely choice, which in turn makes DCX more like specs and less like docs :)
sa_conn_info() and sp_list_mutexes_semaphores() result sets include this information.
The following fields can be used to distinguish blocking on semaphore from blocking on a mutex or a table:
Documentation for the currently_waited_for field will need to be fixed to reflect this information.