А вот какую информацию я могу прочитать из следующих таблиц? Что именно показывает наличие блокировки и где конкретно она?
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
115.
116.
117.
118.
119.
120.
121.
122.
123.
124.
125.
126.
127.
128.
129.
130.
131.
132.
133.
134.
135.
136.
137.
138.
139.
140.
141.
142.
143.
144.
51 4 0 0 DB S GRANT
53 7 0 0 DB S GRANT
54 4 0 0 DB S GRANT
55 7 0 0 DB S GRANT
56 7 0 0 DB S GRANT
57 7 0 0 DB S GRANT
58 7 0 0 DB S GRANT
59 7 0 0 DB S GRANT
60 7 0 0 DB S GRANT
61 7 0 0 DB S GRANT
62 7 0 0 DB S GRANT
63 7 0 0 DB S GRANT
64 7 0 0 DB S GRANT
65 7 0 0 DB S GRANT
66 7 0 0 DB S GRANT
67 7 0 0 DB S GRANT
67 1 85575343 0 TAB IS GRANT
68 7 312388182 0 TAB IX GRANT
68 7 1727345218 0 TAB IX GRANT
68 7 1727345218 12 KEY (4e001520a208) X GRANT
68 7 480720765 3 PAG 1 : 3642 IX GRANT
68 7 740197687 1 KEY (130092d8179c) X GRANT
68 7 1529772507 1 KEY (7e002223df56) X GRANT
68 7 740197687 0 TAB IX GRANT
68 7 1643868923 6 KEY (e1000b7f57de) X GRANT
68 7 1529772507 1 PAG 1 : 2483 IX GRANT
68 7 312388182 1 PAG 1 : 2469 IX GRANT
68 7 1727345218 13 PAG 1 : 2468 IX GRANT
68 7 633769315 1 KEY (2e00d992949f) X GRANT
68 7 633769315 1 PAG 1 : 2526 IX GRANT
68 7 1643868923 0 TAB IX GRANT
68 7 89767377 1 KEY (0300d2dc2e97) X GRANT
68 7 312388182 3 PAG 1 : 3699 IX GRANT
68 7 89767377 0 TAB IX GRANT
68 7 1727345218 14 PAG 1 : 3702 IX GRANT
68 7 480720765 2 PAG 1 : 3689 IX GRANT
68 7 633769315 17 KEY (360019f18248) X GRANT
68 7 480720765 0 TAB IX GRANT
68 7 959342482 1 PAG 1 : 2693 IX GRANT
68 7 1529772507 16 KEY (860056332b67) X GRANT
68 7 1529772507 15 KEY (860056332b67) X GRANT
68 7 959342482 1 KEY (8e00374934d4) X GRANT
68 7 959342482 1 KEY (8d00d9e681c6) X GRANT
68 7 459864705 1 PAG 1 : 2801 IX GRANT
68 7 1643868923 8 PAG 1 : 2804 IX GRANT
68 7 1727345218 1 KEY (2900e647255b) X GRANT
68 7 1529772507 0 TAB IX GRANT
68 7 1643868923 4 KEY (ed0007cefd99) X GRANT
68 7 633769315 0 TAB IX GRANT
68 7 312388182 3 KEY (2800094753e8) X GRANT
68 7 480720765 3 KEY (b400f3893735) X GRANT
68 7 1727345218 14 KEY (9f0084df7c75) X GRANT
68 7 1643868923 3 KEY (260137a8cf6c) X GRANT
68 7 1529772507 15 PAG 1 : 2978 IX GRANT
68 7 633769315 14 KEY (ac002700b7f5) X GRANT
68 7 89767377 4 KEY (2c000b211edb) X GRANT
68 7 312388182 2 KEY (a3002687b622) X GRANT
68 7 1643868923 5 KEY (e8009468cd8e) X GRANT
68 7 0 0 DB S GRANT
68 7 1643868923 1 PAG 1 : 3089 IX GRANT
68 7 89767377 1 PAG 1 : 3088 IX GRANT
68 7 480720765 1 PAG 1 : 3090 IX GRANT
68 7 1727345218 13 KEY (8e004ce94887) X GRANT
68 7 959342482 0 TAB IX GRANT
68 7 959342482 14 KEY (a800a164297d) X GRANT
68 7 959342482 14 KEY (a7004fcb9c6f) X GRANT
68 7 1643868923 2 KEY (e500446af889) X GRANT
68 7 959342482 13 KEY (0b012774a2ac) X GRANT
68 7 1643868923 8 KEY (02017716fc4d) X GRANT
68 7 959342482 13 KEY (0c01c9db17be) X GRANT
68 7 633769315 16 KEY (3500c866d2ca) X GRANT
68 7 480720765 1 KEY (a800c99cfe26) X GRANT
68 7 89767377 5 KEY (e00064425948) X GRANT
68 7 1727345218 11 KEY (56001430307d) X GRANT
68 7 959342482 14 PAG 1 : 3272 IX GRANT
68 7 959342482 13 PAG 1 : 3270 IX GRANT
68 7 459864705 1 KEY (49005437a738) X GRANT
68 7 1529772507 16 PAG 1 : 3325 IX GRANT
68 7 633769315 18 KEY (3000d195d799) X GRANT
68 7 1727345218 11 PAG 1 : 3310 IX GRANT
68 7 89767377 5 PAG 1 : 3311 IX GRANT
68 7 633769315 15 KEY (53002af513cc) X GRANT
68 7 1727345218 12 PAG 1 : 3306 IX GRANT
68 7 459864705 0 TAB IX GRANT
68 7 1727345218 1 PAG 1 : 3356 IX GRANT
68 7 633769315 18 PAG 1 : 3347 IX GRANT
68 7 633769315 17 PAG 1 : 3345 IX GRANT
68 7 740197687 1 PAG 1 : 276 IX GRANT
68 7 633769315 16 PAG 1 : 3343 IX GRANT
68 7 633769315 15 PAG 1 : 3341 IX GRANT
68 7 633769315 14 PAG 1 : 3339 IX GRANT
68 7 1643868923 6 PAG 1 : 3373 IX GRANT
68 7 1643868923 5 PAG 1 : 3371 IX GRANT
68 7 1643868923 4 PAG 1 : 3369 IX GRANT
68 7 1643868923 3 PAG 1 : 3367 IX GRANT
68 7 1643868923 2 PAG 1 : 3365 IX GRANT
68 7 480720765 2 KEY (d1001061ce6a) X GRANT
68 7 312388182 2 PAG 1 : 3414 IX GRANT
68 7 89767377 4 PAG 1 : 3406 IX GRANT
68 7 1643868923 6 KEY (e90084b4ed3c) X GRANT
68 7 1643868923 1 KEY (dd0084717b1e) X GRANT
68 7 312388182 1 KEY (2500d8159548) X GRANT
69 7 0 0 DB S GRANT
70 7 0 0 DB S GRANT
71 7 0 0 DB S GRANT
71 7 740197687 1 PAG 1 : 276 IS GRANT
71 7 740197687 0 TAB IS GRANT
71 7 740197687 1 KEY (130092d8179c) S WAIT
1 0 background sa 0 NULL LAZY WRITER
2 0 sleeping sa 0 NULL LOG WRITER
3 0 background sa 0 master SIGNAL HANDLER
4 0 background sa 0 NULL LOCK MONITOR
5 0 background sa 0 master TASK MANAGER
6 0 background sa 0 master TASK MANAGER
7 0 sleeping sa 0 NULL CHECKPOINT SLEEP
8 0 background sa 0 master TASK MANAGER
9 0 background sa 0 master TASK MANAGER
10 0 background sa 0 master TASK MANAGER
11 0 background sa 0 master TASK MANAGER
12 0 background sa 0 master TASK MANAGER
51 0 sleeping NT AUTHORITY\SYSTEM ASTAROT4 0 msdb AWAITING COMMAND
52 0 runnable NEST\kaa UNGOLIATH- 2 0 master SELECT
53 0 sleeping NEST\kaa UNGOLIATH- 2 0 hotelia AWAITING COMMAND
54 0 sleeping NT AUTHORITY\SYSTEM ASTAROT4 0 msdb AWAITING COMMAND
55 0 sleeping NEST\kaa UNGOLIATH- 2 0 hotelia AWAITING COMMAND
56 0 sleeping NEST\kaa UNGOLIATH- 2 0 hotelia AWAITING COMMAND
57 0 sleeping NEST\kaa UNGOLIATH- 2 0 hotelia AWAITING COMMAND
58 0 sleeping ticket MAGOT- 5 0 hotelia AWAITING COMMAND
59 0 sleeping NEST\kaa UNGOLIATH- 2 0 hotelia AWAITING COMMAND
60 0 sleeping NEST\kaa UNGOLIATH- 2 0 hotelia AWAITING COMMAND
61 0 sleeping NEST\kaa UNGOLIATH- 2 0 hotelia AWAITING COMMAND
62 0 sleeping NEST\kaa UNGOLIATH- 2 0 hotelia AWAITING COMMAND
63 0 sleeping NEST\kaa UNGOLIATH- 2 0 hotelia AWAITING COMMAND
64 0 sleeping NEST\kaa UNGOLIATH- 2 0 hotelia AWAITING COMMAND
65 0 sleeping NEST\kaa UNGOLIATH- 2 0 hotelia AWAITING COMMAND
66 0 sleeping NEST\kaa UNGOLIATH- 2 0 hotelia AWAITING COMMAND
67 0 runnable NEST\kaa UNGOLIATH- 2 0 hotelia SELECT
68 0 sleeping NEST\kaa UNGOLIATH- 2 0 hotelia AWAITING COMMAND
69 0 sleeping NEST\kaa UNGOLIATH- 2 0 hotelia AWAITING COMMAND
70 0 sleeping NEST\kaa UNGOLIATH- 2 0 hotelia AWAITING COMMAND
71 0 sleeping NEST\vsv AVATARA- 4 68 hotelia SELECT
