13:34:00.180 spid28s waiter id=process6644bc8 mode=S requestType=wait Resource lists everything exists but I dont see anything hostname,login,program name details,tried using XML no luck,is there anyway using those resouce lists can be identify?. 13:34:42.680 spid138 Transaction (Process ID 138) was deadlocked on lock resources with another process and has been chosen as the deadlock victim.
13:34:00.170 spid91 Transaction (Process ID 91) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. How we can identify those information's, the alert we come to know after 20mins but tried from sys.dm_exec_connections,sessions,requests,threads,locks.
I got deadlock in errorlog but unable to identify the login name,hostname,programe which is caused.
0 kommentar(er)
