spotgrow.blogg.se

Sql server deadlock dmv
Sql server deadlock dmv













07:38:11.33 spid16s OBJECT_NAME(p.OBJECT_ID) BlockedObjectName, Here is the fragment of the errorlog file: Process ID 103 was killed by hostname Server1, host process ID 9908. I don't know why SQL Server took so long in identifying that deadlock. The both were involved on a deadlock that lasted around 5.5 hours. I have a really weird problem with a deadlock between a business process and a monitoring job.















Sql server deadlock dmv