The Wait Events drilldown is showing CLR_SEMAPHORE wait type with <unknown> data. (4275760)

Chat now with support

Zurück

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Titel

The Wait Events drilldown is showing CLR_SEMAPHORE wait type with data.
Beschreibung

User found the Wait Events drilldown is showing a CLR_SEMAPHORE wait type, but everything else about it is <unknown>.
Lösung

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.
Fehler-ID

SOSSE-4841

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Empfohlener Inhalt

Titel