Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chiangfj
Starting Member
2 Posts |
 Posted - 2011-10-15 : 03:06:55
|
| Hi all,Currently, I suspect that there are records deadlock issue in my application. So, I use this sql stmt:select distinct object_name(a.rsc_objid), a.req_spid, b.loginame, b.hostnamefrom master.dbo.syslockinfo a (nolock) joinmaster.dbo.sysprocesses b (nolock) on a.req_spid=b.spidwhere object_name(a.rsc_objid) is not null;it returns:Table name req_spid loginame hostname cmdTBL_A 501 prrm sERVER1 UPDATE TBL_A 443 prrm sERVER1 UPDATE TBL_A 454 prrm sERVER1 UPDATE TBL_A 456 prrm sERVER2 UPDATE TBL_A 409 prrm sERVER2 SELECT TBL_A 453 prrm sERVER2 UPDATE TBL_A 450 prrm sERVER2 UPDATE TBL_A 232 prrm sERVER3 UPDATE TBL_B 454 prrm sERVER1 UPDATE TBL_B 501 prrm sERVER1 UPDATE TBL_B 443 prrm sERVER1 UPDATE TBL_B 450 prrm sERVER2 UPDATE TBL_B 456 prrm sERVER2 UPDATE TBL_B 453 prrm sERVER2 UPDATE TBL_B 409 prrm sERVER2 SELECT TBL_B 232 prrm sERVER3 UPDATE TBL_c 443 prrm sERVER1 UPDATE TBL_c 501 prrm sERVER1 UPDATE TBL_c 454 prrm sERVER1 UPDATE TBL_c 453 prrm sERVER2 UPDATE TBL_c 450 prrm sERVER2 UPDATE TBL_c 409 prrm sERVER2 SELECT TBL_c 456 prrm sERVER2 UPDATE TBL_c 232 prrm sERVER3 UPDATE How can I select the actual sql statement that there are executing so that I can analyse which one caused the deadlock.Thanks. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Records deadlock