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

Chatee ahora con Soporte

Regresar

Comentarios enviados

¿Este artículo solucionó su problema?

Seleccionar calificación

Título

The Wait Events drilldown is showing CLR_SEMAPHORE wait type with data.
Descripción

User found the Wait Events drilldown is showing a CLR_SEMAPHORE wait type, but everything else about it is <unknown>.
Resolución

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.
ID de defecto

SOSSE-4841

Comentarios enviados

¿Este artículo solucionó su problema?

Seleccionar calificación

Contenido recomendado

Título