Deadlock Problem

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • IAPW
    #1

    Deadlock Problem

    I don't know what newsgroup to post this to so I'm posting it to both.

    I'm receiving sporadic deadlock problems. I get messages which look like
    the following:

    "Transactio n (Process ID 57) was deadlocked on {lock} resources with
    another process and has been chosen as the deadlock victim. Rerun the
    transaction."

    Running sp_lock I got the following result where dbid=7 is the tempdb and
    dbid=2 is production database. Could somebody help to figure out what is
    causing the problem? Thanks.

    --
    spid dbid ObjId IndId Type Resource Mode Status
    ------ ------ ----------- ------ ---- ---------------- -------- ------
    52 7 1682105033 1 KEY (1f011e8335e0) X GRANT
    52 7 0 0 DB S GRANT
    52 2 6 0 TAB IX GRANT
    52 7 1682105033 1 KEY (8001c4b164c8) X GRANT
    52 2 1 0 TAB IX GRANT
    52 7 1682105033 1 KEY (29017a63888f) X GRANT
    52 7 1682105033 1 KEY (32016b668443) X GRANT
    52 7 1682105033 1 KEY (ee00d5371f7f) X GRANT
    52 2 3 0 TAB IX GRANT
    52 2 2 0 TAB IX GRANT
    52 2 3 2 KEY (a302626a12e7) X GRANT
    52 2 12 0 TAB IX GRANT
    52 7 1682105033 1 KEY (3801b739ef66) X GRANT
    52 7 1682105033 1 KEY (1d01c2dc5ec5) X GRANT
    52 7 1682105033 1 KEY (2301a63ce3aa) X GRANT
    52 2 9 0 TAB IX GRANT
    52 2 11 0 TAB IX GRANT
    52 7 1682105033 1 KEY (ec000968745a) X GRANT
    52 7 1682105033 1 KEY (dd00c43213b3) X GRANT
    52 7 1682105033 1 KEY (f800b1d7a210) X GRANT
    52 7 1682105033 1 KEY (e300a0d2aedc) X GRANT
    52 7 1682105033 1 KEY (2c010f86392c) X GRANT
    52 7 1682105033 1 KEY (84017c0eb282) X GRANT
    52 7 1682105033 1 KEY (df00186d7896) X GRANT
    52 7 1682105033 1 KEY (e9007c8dc5f9) X GRANT
    52 7 1682105033 1 KEY (8601a051d9a7) X GRANT
    52 7 1682105033 1 KEY (2e01d3d95209) X GRANT
    52 7 1682105033 1 KEY (f2006d88c935) X GRANT
    52 7 1682105033 1 KEY (31010a1c251a) X GRANT
    52 7 1682105033 1 KEY (e4007917d9cf) X GRANT
    52 7 1682105033 1 KEY (da001df764a0) X GRANT
    52 7 1682105033 1 KEY (9801b4cec95d) X GRANT
    52 7 1682105033 1 KEY (f7006812d503) X GRANT
    52 7 1682105033 1 KEY (2b01d6434e3f) X GRANT
    52 7 1682105033 1 KEY (92016891a278) X GRANT
    52 7 1682105033 1 KEY (e600a548b2ea) X GRANT
    52 7 1682105033 1 KEY (f500b44dbe26) X GRANT
    52 7 1682105033 1 KEY (2001c74642f3) X GRANT
    52 7 1682105033 1 KEY (8e01d02e7432) X GRANT
    52 7 1682105033 1 KEY (2601a3a6ff9c) X GRANT
    52 7 1682105033 1 KEY (e000c1a80f85) X GRANT
    52 7 1682105033 1 KEY (3501b2a3f350) X GRANT
    52 7 1682105033 1 KEY (24017ff994b9) X GRANT
    52 7 1682105033 1 KEY (1a011b1929d6) X GRANT
    52 7 1682105033 1 KEY (8c010c711f17) X GRANT
    52 7 1682105033 1 KEY (f1000cf2686c) X GRANT
    52 7 1682105033 1 KEY (eb00d0ad0349) X GRANT
    52 7 1682105033 1 KEY (37016efc9875) X GRANT
    52 7 1682105033 1 KEY (d500b7ba981d) X GRANT
    52 7 1682105033 1 KEY (c600a6bf94d1) X GRANT
    52 7 1682105033 1 KEY (7d01c12b78fe) X GRANT
    52 2 0 0 PAG 1:79 X GRANT
    52 7 1682105033 1 KEY (d7006be5f338) X GRANT
    52 7 1682105033 1 KEY (7f011d7413db) X GRANT
    52 7 1682105033 1 KEY (c4007ae0fff4) X GRANT
    52 7 1682105033 1 KEY (cb00d35a2572) X GRANT
    52 2 99 0 RID 1:89:0 X GRANT
    52 2 0 0 EXT 1:88 X GRANT
    52 2 3 2 KEY (780254519c13) X GRANT
    52 7 1682105033 1 KEY (bf001b9a5ead) X GRANT
    52 2 0 0 PAG 1:80 X GRANT
    52 7 1682105033 1 KEY (d1000f054e57) X GRANT
    52 2 0 0 EXT 1:80 X GRANT
    52 7 1682105033 1 KEY (c000c25f29be) X GRANT
    52 2 99 0 RID 1:80:0 X GRANT
    52 7 1682105033 1 KEY (bd00c7c53588) X GRANT
    52 2 3 2 KEY (9a01d4bbc633) X GRANT
    52 2 0 0 PAG 1:88 X GRANT
    52 2 0 0 PAG 1:89 X GRANT
    52 7 1682105033 1 KEY (cc000a9f5261) X GRANT
    52 7 1682105033 1 KEY (ce00d6c03944) X GRANT
    52 7 1682105033 1 KEY (ba001e00429b) X GRANT
    52 7 1682105033 1 KEY (d2006e7fef0e) X GRANT
    52 7 1682105033 1 KEY (c9007f7ae3c2) X GRANT
    52 7 1682105033 1 KEY (7a0118ee0fed) X GRANT
    52 7 1682105033 1 KEY (c300a32588e7) X GRANT
    52 7 1682105033 1 KEY (d800b220842b) X GRANT
    52 2 1 3 KEY (05007a9d7c37) X GRANT
    52 2 3 2 KEY (c40246be5c01) X GRANT
    52 2 3 2 KEY (0403abfc7b7d) X GRANT
    52 7 673593638 0 TAB IX GRANT
    52 2 1 3 KEY (eb00018f10cf) X GRANT
    52 7 1682105033 1 KEY (6001cd749469) X GRANT
    52 7 1682105033 1 KEY (b500be7f68bc) X GRANT
    52 2 3 1 KEY (1000a9668803) X GRANT
    52 7 1682105033 1 KEY (a600af7a6470) X GRANT
    52 7 1682105033 1 KEY (b70062200399) X GRANT
    52 7 1682105033 1 KEY (6b01dc7198a5) X GRANT
    52 2 3 1 KEY (13009b965634) X GRANT
    52 7 1682105033 1 KEY (9a0017c5b23a) X GRANT
    52 7 1682105033 1 KEY (a40073250f55) X GRANT
    52 2 3 1 KEY (12007539e326) X GRANT
    52 2 3 1 KEY (0d0047c93d11) X GRANT
    52 7 1682105033 1 KEY (7101002ef380) X GRANT
    52 2 3 1 KEY (0600cd86356c) X GRANT
    52 7 1682105033 1 KEY (ab00da9fd5d3) X GRANT
    52 7 1682105033 1 KEY (770164ce4eef) X GRANT
    52 7 1682105033 1 KEY (b10006c0bef6) X GRANT
    52 2 3 1 KEY (07002329807e) X GRANT
    52 7 1682105033 1 KEY (5a01112bff4c) X GRANT
    52 7 1682105033 1 KEY (640175cb4223) X GRANT
    52 2 3 1 KEY (0900ff76eb5b) X GRANT
    52 7 1682105033 1 KEY (7501b89125ca) X GRANT
    52 7 1682105033 1 KEY (a000cb9ad91f) X GRANT
    52 7 1682105033 1 KEY (6601a9942906) X GRANT
    52 2 3 1 KEY (0c0011d95e49) X GRANT
    52 7 1682105033 1 KEY (ac00035aa2c0) X GRANT
    52 7 1682105033 1 KEY (6301ac0e3530) X GRANT
    52 7 1682105033 4 PAG 1:14687 IX GRANT
    52 7 1682105033 1 KEY (7801bd0b39fc) X GRANT
    52 7 1682105033 1 KEY (5d01c8ee885f) X GRANT
    52 2 3 1 KEY (1800d9192596) X GRANT
    52 7 1682105033 1 KEY (7201615452d9) X GRANT
    52 2 3 2 KEY (d501bbd6d318) X GRANT
    52 7 1682105033 1 KEY (ae00df05c9e5) X GRANT
    52 2 3 1 KEY (150037b69084) X GRANT
    52 7 1682105033 1 KEY (690170515e15) X GRANT
    52 7 1682105033 1 KEY (5f0114b1e37a) X GRANT
    52 7 1682105033 1 KEY (6e01d9eb8493) X GRANT
    52 7 1682105033 1 KEY (b20067ba1faf) X GRANT
    52 7 1682105033 1 KEY (a90076bf1363) X GRANT
    52 7 1682105033 1 KEY (9f00125fae0c) X GRANT
    52 7 1682105033 1 KEY (6c0105b4efb6) X GRANT
    52 7 1682105033 1 KEY (a300aae07846) X GRANT
    52 7 1682105033 1 KEY (9d00ce00c529) X GRANT
    52 7 1682105033 1 KEY (b800bbe5748a) X GRANT
    52 7 1682105033 1 KEY (fa0014329401) X GRANT
    52 7 1682105033 1 KEY (490173a6782e) X GRANT
    52 7 1682105033 1 KEY (520162a374e2) X GRANT
    52 7 1682105033 1 KEY (5801befc1fc7) X GRANT
    52 7 1682105033 1 KEY (4301aff9130b) X GRANT
    52 7 1682105033 1 KEY (4c010643c98d) X GRANT
    52 7 1682105033 1 KEY (3a0112dcd977) X GRANT
    52 2 3 2 KEY (2f02bcae25ba) X GRANT
    52 7 1682105033 1 KEY (4e01da1ca2a8) X GRANT
    52 7 1682105033 1 KEY (510103d9d5bb) X GRANT
    52 7 1682105033 1 KEY (3f011746c541) X GRANT
    52 7 1682105033 1 KEY (4b01df86be9e) X GRANT
    52 7 1682105033 1 KEY (3d01cb19ae64) X GRANT
    52 7 1682105033 1 KEY (4001ce83b252) X GRANT
    52 7 1682105033 1 KEY (4601aa630f3d) X GRANT
    52 7 1682105033 1 KEY (fd00cdf7e312) X GRANT
    52 2 3 2 KEY (800230bd9a6a) X GRANT
    52 7 1682105033 1 KEY (5501bb6603f1) X GRANT
    52 7 1682105033 1 KEY (ff0011a88837) X GRANT
    52 7 1682105033 1 KEY (4401763c6418) X GRANT
    52 2 3 2 KEY (5e037595f99f) X GRANT
    52 7 1682105033 1 KEY (5701673968d4) X GRANT
    52 7 1682105033 1 KEY (0e01dcf2efde) X GRANT
    52 7 1682105033 1 KEY (0c0100ad84fb) X GRANT
    52 7 1682105033 1 KEY (1801b81252b1) X GRANT
    52 7 1682105033 1 KEY (0301a9175e7d) X GRANT
    52 7 1682105033 1 KEY (090175483558) X GRANT
    52 7 1682105033 1 KEY (1201644d3994) X GRANT
    52 7 1682105033 1 KEY (040170d2296e) X GRANT
    52 7 1682105033 1 KEY (170161d725a2) X GRANT
    52 7 1682105033 1 KEY (0601ac8d424b) X GRAN3 1
    KEY (cd0058922cd8) X GRANT
    52 7 1682105033 1 KEY (bb004c0d3c22) X GRANT
    52 7 1682105033 1 KEY (cf0084cd47fd) X GRANT
    52 7 1682105033 1 KEY (7b014ae37154) X GRANT
    52 2 3 2 KEY (8501d81941e4) X GRANT
    52 7 1682105033 1 KEY (c8002d779d7b) X GRANT
    52 7 1682105033 1 KEY (d3003c7291b7) X GRANT
    52 7 1682105033 1 KEY (d900e02dfa92) X GRANT
    52 7 1682105033 1 KEY (c200f128f65e) X GRANT
    52 7 1682105033 1 KEY (c700f4b2ea68) X GRANT
    52 7 1682105033 1 KEY (7c0193260647) X GRANT
    52 7 1682105033 1 KEY (d400e5b7e6a4) X GRANT
    52 7 1682105033 1 KEY (7e014f796d62) X GRANT
    52 7 1682105033 1 KEY (c50028ed814d) X GRANT
    52 7 1410104064 0 TAB IX GRANT
    52 7 1682105033 1 KEY (d60039e88d81) X GRANT
    52 7 1682105033 1 KEY (d0005d0830ee) X GRANT
    52 7 1682105033 1 KEY (be0049972014) X GRANT
    52 7 1682105033 1 KEY (ca0081575bcb) X GRANT
    52 7 2050106344 8 KEY (cc00054873c4) X GRANT
    52 7 1682105033 1 KEY (bc0095c84b31) X GRANT
    52 7 1682105033 1 KEY (c10090525707) X GRANT
    52 7 1682105033 1 KEY (160133da5b1b) X GRANT
    52 7 1682105033 1 KEY (050122df57d7) X GRANT
    52 7 1682105033 1 KEY (1401ef85303e) X GRANT
    52 7 1682105033 1 KEY (0701fe803cf2) X GRANT
    52 2 3 2 KEY (de0193ef7558) X GRANT
    52 7 1682105033 1 KEY (01019a60819d) X GRANT
    52 7 1682105033 1 KEY (0a018b658d51) X GRANT
    52 7 1682105033 1 KEY (1001573ae674) X GRANT
    52 7 50099219 1 PAG 1:90498 IX GRANT
    52 7 1682105033 1 KEY (0f018eff9167) X GRANT
    52 7 1682105033 1 KEY (0d0152a0fa42) X GRANT
    52 7 1682105033 1 KEY (0201fb1a20c4) X GRANT
    52 7 1682105033 1 KEY (1901ea1f2c08) X GRANT
    52 7 1682105033 1 KEY (13013640472d) X GRANT
    52 7 1682105033 1 KEY (080127454be1) X GRANT
    52 2 3 2 KEY (49013c8cc935) X GRANT
    52 7 1682105033 4 KEY (3a02e19bb855) X GRANT
    52 7 1682105033 1 KEY (7901ef064745) X GRANT
    52 7 1682105033 1 KEY (5c019ae3f6e6) X GRANT
    52 7 1682105033 1 KEY (6201fe034b89) X GRANT
    52 2 3 1 KEY (0800464e3cc6) X GRANT
    52 2 3 2 KEY (de002759ba96) X GRANT
    52 7 1682105033 1 KEY (ad005157dc79) X GRANT
    52 7 2050106344 8 PAG 1:2966 IX GRANT
    52 2 3 1 KEY (0a009a1157e3) X GRANT
    52 7 1682105033 1 KEY (5e0146bc9dc3) X GRANT
    52 2 3 1 KEY (0b0074bee2f1) X GRANT
    52 7 1682105033 1 KEY (6801225c20ac) X GRANT
    52 7 1682105033 1 KEY (730133592c60) X GRANT
    52 7 1682105033 1 KEY (af008d08b75c) X GRANT
    52 7 1682105033 1 KEY (9e004052d0b5) X GRANT
    52 7 1410104064 1 KEY (3a0081b928d8) X GRANT
    52 7 1682105033 1 KEY (a80024b26dda) X GRANT
    52 2 2 1 KEY (05002c802609) X GRANT
    52 7 1682105033 1 KEY (6f018be6fa2a) X GRANT
    52 7 1682105033 1 KEY (b30035b76116) X GRANT
    52 7 673593638 1 PAG 1:76168 IX GRANT
    52 2 3 1 KEY (1400fef1ea8c) X GRANT
    52 7 1682105033 1 KEY (9c009c0dbb90) X GRANT
    52 2 3 1 KEY (0f00cc0134bb) X GRANT
    52 7 1682105033 1 KEY (b900e9e80a33) X GRANT
    52 7 1682105033 1 KEY (a200f8ed06ff) X GRANT
    52 7 1682105033 1 KEY (6d0157b9910f) X GRANT
    52 2 3 1 KEY (1100105e5f9e) X GRANT
    52 2 3 1 KEY (0e0022ae81a9) X GRANT
    52 7 1682105033 1 KEY (a700fd771ac9) X GRANT
    52 7 1682105033 1 KEY (61019f79ead0) X GRANT
    52 7 1682105033 1 KEY (b400ec721605) X GRANT
    52 7 1682105033 1 KEY (a500212871ec) X GRANT
    52 7 1682105033 1 KEY (9b0045c8cc83) X GRANT
    52 7 1682105033 1 KEY (700152238d39) X GRANT
    52 7 50099219 3 KEY (46016960a15e) X GRANT
    52 7 1682105033 1 KEY (b600302d7d20) X GRANT
    52 7 1682105033 1 KEY (6a018e7ce61c) X GRANT
    52 7 1682105033 1 KEY (b00054cdc04f) X GRANT
    52 7 1682105033 1 KEY (650127c63c9a) X GRANT
    52 2 3 1 KEY (19006021f20b) X GRANT
    52 7 1682105033 1 KEY (5b01432681f5) X GRANT
    52 7 1682105033 1 KEY (aa008892ab6a) X GRANT
    52 7 1682105033 1 KEY (760136c33056) X GRANT
    52 7 1682105033 1 KEY (6701fb9957bf) X GRANT
    52 2 3 1 KEY (160052d12c3c) X GRANT
    52 7 1682105033 1 KEY (7401ea9c5b73) X GRANT
    52 2 3 1 KEY (1700bc7e992e) X GRANT
    52 7 1682105033 1 KEY (a1009997a7a6) X GRANT
    52 7 1682105033 1 KEY (4a018d8bc027) X GRANT
    52 7 1682105033 1 KEY (3e01454bbbf8) X GRANT
    52 7 1682105033 1 KEY (500151d4ab02) X GRANT
    52 7 1682105033 1 KEY (41019c8ecceb) X GRANT
    52 7 1682105033 1 KEY (3c019914d0dd) X GRANT
    52 7 1682105033 1 KEY (5401e96b7d48) X GRANT
    52 7 1682105033 1 KEY (4701f86e7184) X GRANT
    52 7 1682105033 1 KEY (fc009ffa9dab) X GRANT
    52 7 1682105033 1 KEY (56013534166d) X GRANT
    52 7 1682105033 1 KEY (fe0043a5f68e) X GRANT
    52 7 1682105033 1 KEY (450124311aa1) X GRANT
    52 7 1682105033 1 KEY (530130ae0a5b) X GRANT
    52 7 1682105033 1 KEY (480121ab0697) X GRANT
    52 7 1682105033 1 KEY (fb00463feab8) X GRANT
    52 7 1682105033 1 KEY (4201fdf46db2) X GRANT
    52 2 3 2 KEY (df03a1fef4db) X GRANT
    52 7 1682105033 1 KEY (5901ecf1617e) X GRANT
    52 7 1682105033 1 KEY (4d01544eb734) X GRANT
    52 7 1682105033 1 KEY (4f018811dc11) X GRANT
    52 7 1682105033 1 KEY (3b0140d1a7ce) X GRANT
    52 7 1682105033 1 KEY (e000f6c2cd84) X GRANT
    52 7 1682105033 1 KEY (350185c93151) X GRANT
    52 7 1682105033 1 KEY (260194cc3d9d) X GRANT
    52 7 1682105033 1 KEY (eb00e7c7c148) X GRANT
    52 7 1682105033 1 KEY (370159965a74) X GRANT
    52 2 2 1 KEY (eb0035a95436) X GRANT
    52 7 1682105033 1 PAG 1:114462 IX GRANT
    52 7 1682105033 1 PAG 1:114461 IX GRANT
    52 7 1682105033 1 PAG 1:114460 IX GRANT
    52 7 1682105033 1 KEY (1a012c73ebd7) X GRANT
    52 7 1682105033 1 KEY (2401489356b8) X GRANT
    52 7 1682105033 1 KEY (f1003b98aa6d) X GRANT
    52 7 1682105033 1 KEY (f7005f781702) X GRANT
    52 7 1682105033 1 KEY (2b01e1298c3e) X GRANT
    52 7 1682105033 1 KEY (830192a10790) X GRANT
    52 7 1682105033 1 KEY (31013d76e71b) X GRANT
    52 7 1682105033 1 KEY (da002a9da6a1) X GRANT
    52 7 1682105033 1 KEY (e4004e7d1bce) X GRANT
    52 7 1682105033 1 KEY (f50083277c27) X GRANT
    52 7 1682105033 1 KEY (2001f02c80f2) X GRANT
    52 7 1682105033 1 KEY (e600922270eb) X GRANT
    52 7 1682105033 1 KEY (89014efe6cb5) X GRANT
    52 7 1682105033 1 KEY (2c0138ecfb2d) X GRANT
    52 7 1682105033 1 KEY (e30097b86cdd) X GRANT
    52 2 3 2 KEY (7a0171442aa8) X GRANT
    52 7 1682105033 1 KEY (dd00f358d1b2) X GRANT
    52 7 1682105033 1 KEY (97015a617c4f) X GRANT
    52 7 1682105033 1 KEY (f80086bd6011) X GRANT
    52 7 1682105033 1 KEY (2e01e4b39008) X GRANT
    52 7 1682105033 1 KEY (f2005ae20b34) X GRANT
    52 7 1682105033 1 KEY (e9004be707f8) X GRANT
    52 7 1682105033 1 KEY (df002f07ba97) X GRANT
    52 7 1682105033 1 KEY (9501863e176a) X GRANT
    52 7 1682105033 1 KEY (32015c0c4642) X GRANT
    52 7 1682105033 1 KEY (ee00e25ddd7e) X GRANT
    52 7 1682105033 1 KEY (29014d094a8e) X GRANT
    52 7 50099219 3 PAG 1:102217 IX GRANT
    52 7 1682105033 1 KEY (1f0129e9f7e1) X GRANT
    52 7 1682105033 1 KEY (8001f3dba6c9) X GRANT
    52 7 1682105033 1 KEY (91013e81c120) X GRANT
    52 7 1682105033 1 KEY (ec003e02b65b) X GRANT
    52 7 1682105033 1 KEY (2301915621ab) X GRANT
    52 7 1682105033 1 KEY (380180532d67) X GRANT
    52 7 1682105033 1 KEY (1d01f5b69cc4) X GRANT
    52 7 1682105033 1 KEY (8b01e2deaa05) X GRANT
    52 7 1682105033 1 KEY (7a012f84cdec) X GRANT
    52 7 1682105033 1 KEY (c900481021c3) X GRANT
    52 7 1682105033 1 KEY (d20059152d0f) X GRANT
    52 7 1682105033 1 KEY (d800854a462a) X GRANT
    52 7 1682105033 1 KEY (c300944f4ae6) X GRANT
    52 7 1682105033 1 KEY (cc003df59060) X GRANT
    52 7 1682105033 1 KEY (ba00296a809a) X GRANT
    52 2 3 2 KEY (7703885db1d2) X GRANT
    52 7 1682105033 1 KEY (ce00e1aafb45) X GRANT
    52 7 1682105033 1 KEY (d100386f8c56) X GRANT
    52 7 1682105033 1 KEY (bf002cf09cac) X GRANT
    52 7 1682105033 1 KEY (cb00e430e773) X GRANT
    52 7 1682105033 1 KEY (bd00f0aff789) X GRANT
    52 7 1682105033 1 KEY (c000f535ebbf) X GRANT
    52 2 3 2 KEY (7402670da95e) X GRANT
    52 7 1682105033 1 KEY (c60091d556d0) X GRANT
    52 7 1682105033 1 KEY (7d01f641baff) X GRANT
    52 7 1682105033 1 KEY (d50080d05a1c) X GRANT
    52 2 3 2 KEY (c302741d5036) X GRANT
    52 7 1682105033 1 KEY (7f012a1ed1da) X GRANT
    52 7 1682105033 1 KEY (c4004d8a3df5) X GRANT
    52 7 1682105033 1 KEY (d7005c8f3139) X GRANT
    52 2 3 2 KEY (ac02bc94c621) X GRANT
    52 2 3 2 KEY (f300c206222d) X GRANT
    52 7 1682105033 1 KEY (9f0025356c0d) X GRANT
    52 7 1682105033 1 KEY (a90041d5d162) X GRANT
    52 7 1682105033 1 KEY (6e01ee814692) X GRANT
    52 7 1682105033 1 KEY (b20050d0ddae) X GRANT
    52 2 3 2 KEY (6002954276f1) X GRANT
    52 7 1682105033 1 KEY (9d00f96a0728) X GRANT
    52 7 1682105033 1 KEY (b8008c8fb68b) X GRANT
    52 7 1682105033 1 KEY (a3009d8aba47) X GRANT
    52 7 1682105033 1 KEY (6c0132de2db7) X GRANT
    52 2 3 2 KEY (6b0259d33037) X GRANT
    52 7 1682105033 1 KEY (78018a61fbfd) X GRANT
    52 7 1682105033 1 KEY (5d01ff844a5e) X GRANT
    52 7 1682105033 1 KEY (63019b64f731) X GRANT
    52 7 1682105033 1 KEY (ac00343060c1) X GRANT
    52 2 3 2 KEY (9102a999d45e) X GRANT
    52 7 1682105033 1 KEY (5f0123db217b) X GRANT
    52 7 2050106344 1 KEY (92006b88f750) X GRANT
    52 2 369592555 0 TAB Sch-M GRANT
    52 7 1682105033 1 KEY (6901473b9c14) X GRANT
    52 7 1682105033 1 KEY (7201563e90d8) X GRANT
    52 2 0 0 IDX IDX: 2:369592555 X GRANT
    52 7 1682105033 1 KEY (ae00e86f0be4) X GRANT
    52 7 1682105033 1 KEY (b10031aa7cf7) X GRANT
    52 7 1682105033 1 KEY (640142a18022) X GRANT
    52 7 1682105033 1 KEY (5a0126413d4d) X GRANT
    52 7 1682105033 1 KEY (ab00edf517d2) X GRANT
    52 7 1682105033 1 KEY (770153a48cee) X GRANT
    52 7 1682105033 1 KEY (66019efeeb07) X GRANT
    52 7 1682105033 1 KEY (75018ffbe7cb) X GRANT
    52 7 1682105033 1 KEY (a000fcf01b1e) X GRANT
    52 2 3 2 KEY (8e01830bf507) X GRANT
    52 7 1682105033 1 KEY (a6009810a671) X GRANT
    52 7 1682105033 1 KEY (6001fa1e5668) X GRANT
    52 7 1682105033 1 KEY (b5008915aabd) X GRANT
    52 7 1682105033 1 KEY (a400444fcd54) X GRANT
    52 7 1682105033 1 KEY (710137443181) X GRANT
    52 7 1682105033 1 KEY (b700554ac198) X GRANT
    52 7 2050106344 7 PAG 1:98203 IX GRANT
    52 7 1682105033 1 KEY (6b01eb1b5aa4) X GRANT
    52 7 1682105033 1 KEY (55018c0cc1f0) X GRANT
    52 7 1682105033 1 KEY (46019d09cd3c) X GRANT
    52 7 1682105033 1 KEY (fd00fa9d2113) X GRANT
    52 7 1682105033 1 KEY (57015053aad5) X GRANT
    52 7 1682105033 1 KEY (ff0026c24a36) X GRANT
    52 7 1682105033 1 KEY (44014156a619) X GRANT
    52 7 1682105033 1 KEY (4b01e8ec7c9f) X GRANT
    52 7 1682105033 1 KEY (3f01202c0740) X GRANT
    52 7 1682105033 1 KEY (510134b317ba) X GRANT
    52 7 1682105033 1 KEY (4001f9e97053) X GRANT
    52 7 1682105033 1 KEY (9a009d6ba7a4) X GRANT
    52 7 1682105033 1 KEY (3d01fc736c65) X GRANT
    52 7 1682105033 1 KEY (4c0131290b8c) X GRANT
    52 7 1682105033 1 KEY (4e01ed7660a9) X GRANT
    52 7 1682105033 1 KEY (3a0125b61b76) X GRANT
    52 7 1682105033 1 KEY (520155c9b6e3) X GRANT
    52 7 1682105033 1 KEY (490144ccba2f) X GRANT
    52 7 1682105033 1 KEY (fa0023585600) X GRANT
    52 7 1682105033 1 KEY (43019893d10a) X GRANT
    52 7 1682105033 1 KEY (58018996ddc6) X GRANT
    52 7 1682105033 1 KEY (0001ff073d25) X GRANT
    52 7 1682105033 1 KEY (0b01ee0231e9) X GRANT
    52 7 1682105033 1 KEY (1101325d5acc) X GRANT
    52 7 1682105033 1 KEY (170156bde7a3) X GRANT
    52 7 1682105033 0 TAB IX GRANT
    52 7 1682105033 1 KEY (040147b8eb6f) X GRANT
    52 2 3 1 KEY (fb0031b8225d) X GRANT
    52 7 1682105033 1 KEY (15018ae28c86) X GRANT
    52 7 1682105033 1 KEY (06019be7804a) X GRANT
    52 2 3 1 KEY (fe00df17974f) X GRANT
    52 2 3 1 KEY (ec00cb8887b5) X GRANT
    52 2 3 1 KEY (f20017d7ec90) X GRANT
    52 2 3 1 KEY (ed00252732a7) X GRANT
    52 7 1682105033 1 KEY (03019e7d9c7c) X GRANT
    52 7 1682105033 1 KEY (18018f7890b0) X GRANT
    52 7 1682105033 1 KEY (12015327fb95) X GRANT
    52 7 1682105033 1 KEY (09014222f759) X GRANT
    52 2 3 1 KEY (ef00f9785982) X GRANT
    52 7 1682105033 1 KEY (0e01eb982ddf) X GRANT
    52 2 3 1 KEY (f600af683ada) X GRANT
    52 2 3 1 KEY (f30041c78fc8) X GRANT
    52 7 1682105033 1 KEY (0c0137c746fa) X GRANT
    52 2 3 1 KEY (f9009d98e4ed) X GRANT
    52 2 3 1 KEY (f800733751ff) X GRANT
    52 2 3 2 KEY (1f0336d2d087) X GRANT
    52 7 257540101 0 PAG 1:21868 IS GRANT
    52 2 3 2 KEY (f300e0d5b4b3) X GRANT
    52 7 1682105033 4 KEY (8102568ca4b3) X GRANT
    52 7 1410104064 1 PAG 1:13905 IX GRANT
    52 7 2050106344 0 TAB IX GRANT
    52 7 2050106344 1 PAG 1:3650 IX GRANT
    52 7 673593638 1 KEY (a200b2578fc8) X GRANT
    52 7 1682105033 1 KEY (dc00a155af0b) X GRANT
    52 7 1682105033 1 KEY (f900d4b01ea8) X GRANT
    52 7 1682105033 1 KEY (e200c5b51264) X GRANT
    52 7 1682105033 1 KEY (2d016ae18594) X GRANT
    52 7 1682105033 1 KEY (850119690e3a) X GRANT
    52 7 1682105033 1 KEY (de007d0ac42e) X GRANT
    52 7 1682105033 1 KEY (8701c536651f) X GRANT
    52 7 1682105033 1 KEY (e80019ea7941) X GRANT
    52 7 1682105033 1 KEY (2f01b6beeeb1) X GRANT
    52 7 1682105033 1 KEY (f30008ef758d) X GRANT
    52 7 1682105033 1 KEY (1e017be48958) X GRANT
    52 7 1682105033 1 KEY (8101a1d6d870) X GRANT
    52 7 1682105033 1 KEY (28011f043437) X GRANT
    52 7 1682105033 1 KEY (33010e0138fb) X GRANT
    52 7 1682105033 1 KEY (ef00b050a3c7) X GRANT
    52 7 1682105033 1 KEY (3901d25e53de) X GRANT
    52 7 1682105033 1 KEY (1c01a7bbe27d) X GRANT
    52 7 1682105033 1 KEY (2201c35b5f12) X GRANT
    52 7 1682105033 1 KEY (ed006c0fc8e2) X GRANT
    52 2 3 2 KEY (3902a1a9d5ad) X GRANT
    52 7 1682105033 1 KEY (8f01b549c88a) X GRANT
    52 7 1682105033 1 KEY (2701c6c14324) X GRANT
    52 7 1682105033 1 KEY (e100a4cfb33d) X GRANT
    52 7 1682105033 1 KEY (3401d7c44fe8) X GRANT
    52 7 1682105033 1 KEY (25011a9e2801) X GRANT
    52 7 1682105033 1 KEY (8d016916a3af) X GRANT
    52 7 1682105033 1 KEY (1b017e7e956e) X GRANT
    52 7 1682105033 1 KEY (f0006995d4d4) X GRANT
    52 7 1682105033 1 KEY (ea00b5cabff1) X GRANT
    52 7 1682105033 1 KEY (36010b9b24cd) X GRANT
    52 7 1682105033 1 KEY (30016f7b99a2) X GRANT
    52 7 1682105033 1 KEY (e5001c706577) X GRANT
    52 7 1682105033 1 KEY (db007890d818) X GRANT
    52 2 1 1 KEY (05000f9d1a73) X GRANT
    52 7 1682105033 1 KEY (8201c0ac7929) X GRANT
    52 7 1682105033 1 KEY (f6000d7569bb) X GRANT
    52 7 1682105033 1 KEY (9901d1a975e5) X GRANT
    52 7 1682105033 1 KEY (2a01b324f287) X GRANT
    52 7 1682105033 1 KEY (93010df61ec0) X GRANT
    52 7 1682105033 1 KEY (e700c02f0e52) X GRANT
    52 7 1682105033 1 KEY (f400d12a029e) X GRANT
    52 7 1682105033 1 KEY (2101a221fe4b) X GRANT
    52 7 1682105033 1 KEY (ca00b63d99ca) X GRANT
    52 7 1682105033 1 KEY (be007efde215) X GRANT
    52 7 1682105033 1 KEY (d0006a62f2ef) X GRANT
    52 7 1682105033 1 KEY (c100a7389506) X GRANT
    52 7 2034106287 1 KEY (3a0081b928d8) X GRANT
    52 7 1682105033 1 KEY (bc00a2a28930) X GRANT
    52 7 2034106287 5 PAG 1:70821 IX GRANT
    52 2 3 2 KEY (2c01a841bccd) X GRANT
    52 7 1682105033 1 KEY (d400d2dd24a5) X GRANT
    52 7 1682105033 1 KEY (c700c3d82869) X GRANT
    52 2 1 1 KEY (eb00748f768b) X GRANT
    52 7 1682105033 1 KEY (7c01a44cc446) X GRANT
    52 7 1682105033 1 KEY (d6000e824f80) X GRANT
    52 7 1682105033 1 KEY (7e017813af63) X GRANT
    52 7 1682105033 1 KEY (c5001f87434c) X GRANT
    52 7 1682105033 1 KEY (d3000b1853b6) X GRANT
    52 7 1682105033 1 KEY (c8001a1d5f7a) X GRANT
    52 7 1682105033 1 KEY (7b017d89b355) X GRANT
    52 7 1682105033 1 KEY (c200c642345f) X GRANT
    52 7 1682105033 1 KEY (d900d7473893) X GRANT
    52 7 1682105033 1 KEY (cd006ff8eed9) X GRANT
    52 7 1682105033 1 KEY (cf00b3a785fc) X GRANT
    52 7 2034106287 1 PAG 1:70803 IX GRANT
    52 7 1682105033 1 KEY (bb007b67fe23) X GRANT
    52 7 1682105033 1 KEY (1901dd75ee09) X GRANT
    52 7 1682105033 1 KEY (0201cc70e2c5) X GRANT
    52 2 3 1 KEY (ff00662f40d2) X GRANT
    52 2 3 1 KEY (fc0054df9ee5) X GRANT
    52 7 1682105033 1 KEY (0801102f89e0) X GRANT
    52 7 1682105033 1 KEY (1301012a852c) X GRANT
    52 2 3 1 KEY (fd00ba702bf7) X GRANT
    52 7 1682105033 1 KEY (0f01b9955366) X GRANT
    52 2 3 2 KEY (c60169c5ef78) X GRANT
    52 7 1682105033 1 KEY (0d0165ca3843) X GRANT
    52 2 3 1 KEY (f500ca0f8662) X GRANT
    52 7 1682105033 1 KEY (0101ad0a439c) X GRANT
    52 2 3 1 KEY (f40024a03370) X GRANT
    52 7 1682105033 1 KEY (100160502475) X GRANT
    52 2 3 1 KEY (f7001650ed47) X GRANT
    52 2 3 1 KEY (fa00f8ff5855) X GRANT
    52 7 1682105033 1 KEY (0a01bc0f4f50) X GRANT
    52 7 1682105033 1 KEY (050115b595d6) X GRANT
    52 2 3 1 KEY (f0009c1fe53a) X GRANT
    52 2 3 1 KEY (f10072b05028) X GRANT
    52 2 3 1 KEY (ee0040408e1f) X GRANT
    52 7 1682105033 1 KEY (160104b0991a) X GRANT
    52 7 1682105033 1 KEY (0701c9eafef3) X GRANT
    52 7 1682105033 1 KEY (1401d8eff23f) X GRANT
    52 2 0 0 IDX IDX: 2:17591301: X GRANT
    52 2 17591301 0 TAB Sch-M GRANT
    52 7 1682105033 1 KEY (aa00bff8696b) X GRANT
    52 7 1682105033 1 KEY (760101a9f257) X GRANT
    52 7 1682105033 1 KEY (b00063a7024e) X GRANT
    52 7 1682105033 1 KEY (5b01744c43f4) X GRANT
    52 7 1682105033 1 KEY (650110acfe9b) X GRANT
    52 7 1682105033 1 KEY (7401ddf69972) X GRANT
    52 7 1682105033 1 KEY (a100aefd65a7) X GRANT
    52 7 1682105033 1 KEY (6701ccf395be) X GRANT
    52 7 1682105033 1 KEY (6101a81328d1) X GRANT
    52 7 1682105033 1 KEY (b400db18d404) X GRANT
    52 7 1682105033 1 KEY (a700ca1dd8c8) X GRANT
    52 7 1682105033 1 KEY (b6000747bf21) X GRANT
    52 7 1682105033 1 KEY (6a01b916241d) X GRANT
    52 2 3 2 KEY (1e02c762ac84) X GRANT
    52 7 1682105033 1 KEY (9b0072a20e82) X GRANT
    52 7 1682105033 1 KEY (a5001642b3ed) X GRANT
    52 7 1682105033 1 KEY (700165494f38) X GRANT
    52 7 1682105033 1 KEY (6f01bc8c382b) X GRANT
    52 7 1682105033 1 KEY (b30002dda317) X GRANT
    52 7 1682105033 1 KEY (a80013d8afdb) X GRANT
    52 7 1682105033 1 KEY (9e00773812b4) X GRANT
    52 2 3 2 KEY (d9015b3a7642) X GRANT
    52 7 1682105033 1 KEY (6d0160d3530e) X GRANT
    52 2 3 2 KEY (580364db66a7) X GRANT
    52 7 1682105033 1 KEY (a200cf87c4fe) X GRANT
    52 7 1682105033 1 KEY (9c00ab677991) X GRANT
    52 7 1682105033 1 KEY (b900de82c832) X GRANT
    52 7 1682105033 1 KEY (ad00663d1e78) X GRANT
    52 7 1682105033 1 KEY (6201c9698988) X GRANT
    52 7 2034106287 0 TAB IX GRANT
    52 7 1682105033 1 KEY (7901d86c8544) X GRANT
    52 7 1682105033 1 KEY (5c01ad8934e7) X GRANT
    52 7 1682105033 1 KEY (73010433ee61) X GRANT
    52 7 1682105033 1 KEY (af00ba62755d) X GRANT
    52 7 50099219 1 KEY (460104986f4d) X GRANT
    52 7 1682105033 1 KEY (68011536e2ad) X GRANT
    52 7 1682105033 1 KEY (5e0171d65fc2) X GRANT
    52 7 1682105033 1 KEY (4d0163247535) X GRANT
    52 7 1682105033 1 KEY (3b0177bb65cf) X GRANT
    52 7 1682105033 1 KEY (4f01bf7b1e10) X GRANT
    52 7 1682105033 1 KEY (fb00715528b9) X GRANT
    52 7 1682105033 1 KEY (480116c1c496) X GRANT
    52 7 1682105033 1 KEY (530107c4c85a) X GRANT
    52 7 1682105033 1 KEY (5901db9ba37f) X GRANT
    52 7 1682105033 1 KEY (4201ca9eafb3) X GRANT
    52 7 1682105033 1 KEY (4701cf04b385) X GRANT
    52 7 1682105033 1 KEY (fc00a8905faa) X GRANT
    52 7 1682105033 1 KEY (5401de01bf49) X GRANT
    52 7 1682105033 1 KEY (fe0074cf348f) X GRANT
    52 7 1682105033 1 KEY (4501135bd8a0) X GRANT
    52 7 1682105033 1 KEY (5601025ed46c) X GRANT
    52 7 1682105033 1 KEY (500166be6903) X GRANT
    52 7 1682105033 1 KEY (3e01722179f9) X GRANT
    52 7 1682105033 1 KEY (4a01bae10226) X GRANT
    52 7 1682105033 1 KEY (3c01ae7e12dc) X GRANT
    52 2 3 2 KEY (d9016c0803f6) X GRANT
    52 2 3 2 KEY (dd01651473d6) X GRANT
    52 7 1682105033 1 KEY (4101abe40eea) X GRANT
    --
    Tags: None
    • Paul Ibison
      #2
      Re: Deadlock Problem

      What you really need is the actual TSQL that is causing the problem.
      To get more useful info, you could use profiler and monitor directly for
      deadlocks, or these trace flags:
      DBCC TRACEON(1204,12 05,3605,-1)
      The above flags will enter the actual relevant TSQL in the SQL log.
      HTH,
      Paul Ibison


        Comment

        Previous template Next
        Working...