The Wait Events drilldown is showing CLR_SEMAPHORE wait type with data.
説明
User found the Wait Events drilldown is showing a CLR_SEMAPHORE wait type, but everything else about it is <unknown>.
対策
Spotlight puts 'unknown' in to the SPID field when it cannot find the SPID. That could be due to the deadlock being an ' Intra-Query Parallel Thread Deadlock' where a process deadlocks itself due to parallelism. In some of these cases SQL Server doesn't populate the victim-list element of the deadlock graph. There's nothing Spotlight can do about this because SQL Server has not provided the data.
