Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
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.
