Advertisement

02.26.2008 at 05:09PM PST, ID: 23195643
[x]
Attachment Details
[x]
The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

  • The Grade of the Solution
  • The Zone Rank of the Expert Providing the Solution
  • The Number of Author and Expert Comments
  • The Number of Experts Contributing
  • The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!
8.5

Blocking After SLQ SP4 Installed - Part II

Asked by slamhound in MS SQL Server, Microsoft Access Database

Tags: , ,

We have an ordering system written in Access with a SQL back end that's replicated to a web site SQL server (the web side is working fine). Ever since the client has installed SP4 for SQL 2000 we've been getting some unreasonable "blocking" on the largest and most important table; the customers table. This results in everyone (up to 15 users) having Access freeze on them till someone (I'm guessing the blocker) reciving a "ODBC call failed" error message.

It seems this happens when there are chained blocks like this:
SPID 1 Blocking
SPID 5 Blocked by 1
SPID 10 Blocked by 5
SPID 15 Blocked by 5
SPID 20 Blocked by 5

Want to avoid re-creating the replication as the system will be down for a day or two as the data is updated and the client will lose lots of orders in that time. Have run a reindex, checked workstations, relinked all tables.

How can I stop this happening? Looking for any ideas even if it's not a perfect solution.

You can see some history here: http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23189908.htmlStart Free Trial 
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:
145:
146:
147:
148:
149:
150:
151:
152:
153:
154:
155:
156:
157:
158:
159:
160:
161:
162:
163:
164:
165:
166:
167:
168:
169:
170:
171:
172:
173:
174:
175:
176:
177:
178:
179:
180:
181:
182:
183:
184:
185:
186:
187:
188:
189:
190:
191:
192:
193:
194:
195:
196:
197:
198:
199:
200:
201:
202:
203:
204:
205:
206:
207:
208:
209:
210:
211:
212:
213:
214:
215:
216:
217:
218:
219:
220:
221:
222:
223:
224:
225:
226:
227:
228:
229:
230:
231:
232:
233:
234:
235:
236:
237:
238:
239:
240:
241:
242:
243:
244:
245:
246:
247:
248:
249:
250:
251:
252:
253:
254:
255:
256:
257:
258:
259:
260:
261:
262:
263:
264:
265:
266:
267:
268:
269:
270:
271:
272:
273:
274:
275:
276:
277:
278:
279:
280:
281:
282:
283:
284:
285:
286:
287:
288:
289:
290:
291:
292:
293:
294:
295:
296:
297:
298:
299:
300:
301:
302:
303:
304:
305:
306:
307:
308:
309:
310:
311:
312:
313:
314:
315:
316:
317:
318:
319:
320:
321:
322:
323:
324:
325:
326:
327:
328:
329:
330:
331:
332:
333:
334:
335:
336:
337:
338:
339:
340:
341:
342:
343:
344:
345:
346:
347:
348:
349:
350:
351:
352:
353:

[some information from a MS stored proc during a lock]
8.2 Start time: 2008-02-26 16:07:39.317 0
 
SYSPROCESSES [CLIENT NAME]-FS1  134219767
spid   status                         blocked open_tran waitresource                                                                                                                                                                                                                                                     waittype waittime    cmd              lastwaittype                     cpu         physical_io          memusage    last_batch                 login_time                 net_address  net_library  dbid   ecid   kpid   hostname                                                                                                                         hostprocess loginame                                                                                                                         program_name                                                                                                                     nt_domain                                                                                                                        nt_username                                                                                                                      uid    sid                                                                                                                                                                            sql_handle                                 stmt_start  stmt_end    
------ ------------------------------ ------- --------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------- ----------- ---------------- -------------------------------- ----------- -------------------- ----------- -------------------------- -------------------------- ------------ ------------ ------ ------ ------ -------------------------------------------------------------------------------------------------------------------------------- ----------- -------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------ ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ------------------------------------------ ----------- ----------- 
59     runnable                       0       0                                                                                                                                                                                                                                                                          0x0800   50266       SELECT           NETWORKIO                        15          0                    16          1900-01-01 00:00:00.000    2008-02-26 16:06:48.897    0018FE311644 TCP/IP       8      0      4152   [CLIENT NAME]-FS1                                                                                                                   5048        [CLIENT NAME]\stephaniew                                                                                                            Microsoft® Access                                                                                                                [CLIENT NAME]                                                                                                                       stephaniew                                                                                                                       0      0x010500000000000515000000B644E4238A5A4160828BA628F704000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0x01000800C598201FC0803C2A0000000000000000 18          -1
59     sleeping                       0       0                                                                                                                                                                                                                                                                          0x0208   50266       SELECT           CXPACKET                         93          0                    16          1900-01-01 00:00:00.000    2008-02-26 16:06:48.897    0018FE311644 TCP/IP       8      4      6728   [CLIENT NAME]-FS1                                                                                                                   5048        [CLIENT NAME]\stephaniew                                                                                                            Microsoft® Access                                                                                                                [CLIENT NAME]                                                                                                                       stephaniew                                                                                                                       0      0x010500000000000515000000B644E4238A5A4160828BA628F704000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0x0000000000000000000000000000000000000000 0           0
59     sleeping                       0       0                                                                                                                                                                                                                                                                          0x0208   50282       SELECT           CXPACKET                         78          0                    16          1900-01-01 00:00:00.000    2008-02-26 16:06:48.897    0018FE311644 TCP/IP       8      3      1620   [CLIENT NAME]-FS1                                                                                                                   5048        [CLIENT NAME]\stephaniew                                                                                                            Microsoft® Access                                                                                                                [CLIENT NAME]                                                                                                                       stephaniew                                                                                                                       0      0x010500000000000515000000B644E4238A5A4160828BA628F704000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0x0000000000000000000000000000000000000000 0           0
59     sleeping                       0       0                                                                                                                                                                                                                                                                          0x0208   50282       SELECT           CXPACKET                         94          0                    16          1900-01-01 00:00:00.000    2008-02-26 16:06:48.897    0018FE311644 TCP/IP       8      2      1748   [CLIENT NAME]-FS1                                                                                                                   5048        [CLIENT NAME]\stephaniew                                                                                                            Microsoft® Access                                                                                                                [CLIENT NAME]                                                                                                                       stephaniew                                                                                                                       0      0x010500000000000515000000B644E4238A5A4160828BA628F704000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0x0000000000000000000000000000000000000000 0           0
59     sleeping                       0       0                                                                                                                                                                                                                                                                          0x0208   50282       SELECT           CXPACKET                         125         0                    16          1900-01-01 00:00:00.000    2008-02-26 16:06:48.897    0018FE311644 TCP/IP       8      1      5824   [CLIENT NAME]-FS1                                                                                                                   5048        [CLIENT NAME]\stephaniew                                                                                                            Microsoft® Access                                                                                                                [CLIENT NAME]                                                                                                                       stephaniew                                                                                                                       0      0x010500000000000515000000B644E4238A5A4160828BA628F704000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0x0000000000000000000000000000000000000000 0           0
67     sleeping                       98      0         TAB: 8:1680725040 []                                                                                                                                                                                                                                             0x0006   27125       SELECT           LCK_M_IS                         329         0                    1           2008-02-26 16:07:12.210    2008-02-26 16:07:12.067    0018FE311644 TCP/IP       8      0      6588   RDP-SERVER                                                                                                                       6364        [CLIENT NAME]                                                                                                                       Microsoft® Access                                                                                                                                                                                                                                                                                                                                                                                  5      0xFF7CAA671F19E14F897369BAA5451D0C00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0x010008003EAE0634C08095500000000000000000 108         -1
72     runnable                       0       0                                                                                                                                                                                                                                                                          0x0042   63          SELECT           SLEEP                            103891      1                    11          2008-02-26 09:54:22.697    2008-02-26 09:32:24.260    000BCD4DADAF TCP/IP       1      0      2068   [CLIENT NAME]-FS1                                                                                                                   6484        [CLIENT NAME]\selwyn                                                                                                                SQL Profiler                                                                                                                     [CLIENT NAME]                                                                                                                       selwyn                                                                                                                           1      0x010500000000000515000000B644E4238A5A4160828BA6287504000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0x02000100579A5A62000000000100000000000000 164         -1
75     sleeping                       98      0         TAB: 8:1680725040 []                                                                                                                                                                                                                                             0x0006   26672       SELECT           LCK_M_IS                         828         0                    1           2008-02-26 16:07:12.677    2008-02-26 16:02:35.003    0018FE311644 TCP/IP       8      0      5844   ATBOXGEL                                                                                                                         11436       [CLIENT NAME]\sue                                                                                                                   Microsoft Office XP                                                                                                              [CLIENT NAME]                                                                                                                       sue                                                                                                                              0      0x010500000000000515000000B644E4238A5A4160828BA628D104000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0x0100080081480121C0C02D2A0000000000000000 18          -1
77     sleeping                       98      0         TAB: 8:1680725040 []                                                                                                                                                                                                                                             0x0006   7047        SELECT           LCK_M_IS                         0           0                    1           1900-01-01 00:00:00.000    2008-02-26 16:07:32.303    0018FE311644 TCP/IP       8      0      2624   [CLIENT NAME]-FS1                                                                                                                   5960        [CLIENT NAME]\sue                                                                                                                   Microsoft® Access                                                                                                                [CLIENT NAME]                                                                                                                       sue                                                                                                                              0      0x010500000000000515000000B644E4238A5A4160828BA628D104000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0x01000800AC2C6B14C0E058350000000000000000 18          -1
96     sleeping                       98      0         TAB: 8:1680725040 []                                                                                                                                                                                                                                             0x0006   27078       SELECT           LCK_M_IS                         1016        0                    2           2008-02-26 16:07:12.287    2008-02-26 16:05:37.440    0018FE311644 TCP/IP       8      0      772    ATBOXGEL                                                                                                                         12752       [CLIENT NAME]\sue                                                                                                                   Microsoft Office XP                                                                                                              [CLIENT NAME]                                                                                                                       sue                                                                                                                              0      0x010500000000000515000000B644E4238A5A4160828BA628D104000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0x0100080072E89724C020227F0000000000000000 18          -1
98     sleeping                       110     1         TAB: 8:1680725040 []                                                                                                                                                                                                                                             0x0008   27531       INSERT           LCK_M_IX                         2204        0                    1           2008-02-26 16:07:11.833    2008-02-26 16:04:40.770    0018FE311644 TCP/IP       8      0      2628   RDP-SERVER                                                                                                                       15352       [CLIENT NAME]                                                                                                                       Microsoft® Access                                                                                                                                                                                                                                                                                                                                                                                  5      0xFF7CAA671F19E14F897369BAA5451D0C00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0x01000800E9EE500FC04008730000000000000000 386         -1
104    sleeping                       98      0         TAB: 8:1680725040 []                                                                                                                                                                                                                                             0x0006   25203       SELECT           LCK_M_IS                         984         0                    2           2008-02-26 16:07:14.160    2008-02-26 16:05:48.380    0018FE311644 TCP/IP       8      0      4120   ATBOXGEL                                                                                                                         8340        [CLIENT NAME]\sue                                                                                                                   Microsoft Office XP                                                                                                              [CLIENT NAME]                                                                                                                       sue                                                                                                                              0      0x010500000000000515000000B644E4238A5A4160828BA628D104000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0x01000800A3AB0B20C040B1320000000000000000 284         -1
110    runnable                       0       0                                                                                                                                                                                                                                                                          0x0800   76515       SELECT           NETWORKIO                        0           0                    16          1900-01-01 00:00:00.000    2008-02-26 16:06:22.723    0018FE311644 TCP/IP       8      0      2272   [CLIENT NAME]-FS1                                                                                                                   8340        [CLIENT NAME]\sue                                                                                                                   Microsoft® Access                                                                                                                [CLIENT NAME]                                                                                                                       sue                                                                                                                              0      0x010500000000000515000000B644E4238A5A4160828BA628D104000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0x01000800C598201FC0803C2A0000000000000000 18          -1
110    sleeping                       0       0                                                                                                                                                                                                                                                                          0x0208   76531       SELECT           CXPACKET                         94          0                    16          1900-01-01 00:00:00.000    2008-02-26 16:06:22.723    0018FE311644 TCP/IP       8      4      5872   [CLIENT NAME]-FS1                                                                                                                   8340        [CLIENT NAME]\sue                                                                                                                   Microsoft® Access                                                                                                                [CLIENT NAME]                                                                                                                       sue                                                                                                                              0      0x010500000000000515000000B644E4238A5A4160828BA628D104000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0x0000000000000000000000000000000000000000 0           0
110    sleeping                       0       0                                                                                                                                                                                                                                                                          0x0208   76531       SELECT           CXPACKET                         94          0                    16          1900-01-01 00:00:00.000    2008-02-26 16:06:22.723    0018FE311644 TCP/IP       8      3      764    [CLIENT NAME]-FS1                                                                                                                   8340        [CLIENT NAME]\sue                                                                                                                   Microsoft® Access                                                                                                                [CLIENT NAME]                                                                                                                       sue                                                                                                                              0      0x010500000000000515000000B644E4238A5A4160828BA628D104000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0x0000000000000000000000000000000000000000 0           0
110    sleeping                       0       0                                                                                                                                                                                                                                                                          0x0208   76531       SELECT           CXPACKET                         78          0                    16          1900-01-01 00:00:00.000    2008-02-26 16:06:22.723    0018FE311644 TCP/IP       8      2      5348   [CLIENT NAME]-FS1                                                                                                                   8340        [CLIENT NAME]\sue                                                                                                                   Microsoft® Access                                                                                                                [CLIENT NAME]                                                                                                                       sue                                                                                                                              0      0x010500000000000515000000B644E4238A5A4160828BA628D104000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0x0000000000000000000000000000000000000000 0           0
110    sleeping                       0       0                                                                                                                                                                                                                                                                          0x0208   76531       SELECT           CXPACKET                         78          0                    16          1900-01-01 00:00:00.000    2008-02-26 16:06:22.723    0018FE311644 TCP/IP       8      1      5392   [CLIENT NAME]-FS1                                                                                                                   8340        [CLIENT NAME]\sue                                                                                                                   Microsoft® Access                                                                                                                [CLIENT NAME]                                                                                                                       sue                                                                                                                              0      0x010500000000000515000000B644E4238A5A4160828BA628D104000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0x0000000000000000000000000000000000000000 0           0
 
ESP 46
 
SYSPROC FIRST PASS
spid   ecid   waittype 
------ ------ -------- 
59     0      0x0800
59     1      0x0208
59     2      0x0208
59     3      0x0208
59     4      0x0208
72     0      0x0042
110    0      0x0800
110    1      0x0208
110    2      0x0208
110    3      0x0208
110    4      0x0208
67     0      0x0006
75     0      0x0006
77     0      0x0006
96     0      0x0006
104    0      0x0006
98     0      0x0008
 
Blocking via locks at 2008-02-26 16:07:39.317
 
SPIDs at the head of blocking chains
spid   
------ 
110
110
110
110
110
 
SYSLOCKINFO
spid   ecid   dbid   ObjId       IndId  Type Resource         Mode         Status TransID              TransUOW                             
------ ------ ------ ----------- ------ ---- ---------------- ------------ ------ -------------------- ------------------------------------ 
77     0      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
67     0      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
59     4      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
59     4      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
59     4      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
59     4      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
59     4      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
59     3      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
59     3      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
59     3      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
59     3      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
59     3      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
59     2      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
59     2      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
59     2      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
59     2      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
59     2      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
59     1      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
59     1      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
59     1      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
59     1      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
59     1      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
59     0      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
59     0      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
59     0      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
59     0      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
59     0      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
110    4      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
110    4      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
110    4      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
110    4      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
110    4      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
110    3      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
110    3      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
110    3      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
110    3      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
110    3      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
110    2      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
110    2      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
110    2      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
110    2      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
110    2      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
110    1      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
110    1      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
110    1      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
110    1      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
110    1      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
110    0      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
110    0      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
110    0      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
110    0      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
110    0      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
104    0      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
96     0      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
98     0      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
75     0      8      0           0      DB                    S            GRANT  0                    00000000-0000-0000-0000-000000000000
59     0      8      1680725040  0      TAB                   IS           GRANT  17582202             00000000-0000-0000-0000-000000000000
59     0      8      1680725040  0      TAB                   IS           GRANT  17582202             00000000-0000-0000-0000-000000000000
59     0      8      1680725040  0      TAB                   IS           GRANT  17582202             00000000-0000-0000-0000-000000000000
59     0      8      1680725040  0      TAB                   IS           GRANT  17582202             00000000-0000-0000-0000-000000000000
59     0      8      1680725040  0      TAB                   IS           GRANT  17582202             00000000-0000-0000-0000-000000000000
110    0      8      1680725040  0      TAB                   S            GRANT  17580215             00000000-0000-0000-0000-000000000000
110    0      8      1680725040  0      TAB                   S            GRANT  17580215             00000000-0000-0000-0000-000000000000
110    0      8      1680725040  0      TAB                   S            GRANT  17580215             00000000-0000-0000-0000-000000000000
110    0      8      1680725040  0      TAB                   S            GRANT  17580215             00000000-0000-0000-0000-000000000000
110    0      8      1680725040  0      TAB                   S            GRANT  17580215             00000000-0000-0000-0000-000000000000
98     0      8      1680725040  0      TAB                   IX           WAIT   17585898             00000000-0000-0000-0000-000000000000
67     0      8      1680725040  0      TAB                   IS           WAIT   17585926             00000000-0000-0000-0000-000000000000
96     0      8      1680725040  0      TAB                   IS           WAIT   17585927             00000000-0000-0000-0000-000000000000
75     0      8      1680725040  0      TAB                   IS           WAIT   17585929             00000000-0000-0000-0000-000000000000
104    0      8      1680725040  0      TAB                   IS           WAIT   17585958             00000000-0000-0000-0000-000000000000
77     0      8      1680725040  0      TAB                   IS           WAIT   17586278             00000000-0000-0000-0000-000000000000
98     0      8      5575058     0      TAB                   IS           GRANT  17585898             00000000-0000-0000-0000-000000000000
104    0      8      5575058     0      TAB                   IS           GRANT  17585958             00000000-0000-0000-0000-000000000000
 
ESL 33
 
DBCC SQLPERF(WAITSTATS)
Wait Type                        Requests                 Wait Time                Signal Wait Time         
-------------------------------- ------------------------ ------------------------ ------------------------ 
MISCELLANEOUS                    8076.0                   32.0                     32.0
LCK_M_SCH_S                      25.0                     493904.0                 16.0
LCK_M_SCH_M                      9.0                      391313.0                 0.0
LCK_M_S                          1547.0                   1254160.0                5543.0
LCK_M_U                          5.0                      733.0                    0.0
LCK_M_X                          64.0                     25191.0                  62.0
LCK_M_IS                         1169.0                   5.1160936E+7             459.0
LCK_M_IU                         0.0                      0.0                      0.0
LCK_M_IX                         383.0                    2.664144E+7              62.0
LCK_M_SIU                        0.0                      0.0                      0.0
LCK_M_SIX                        0.0                      0.0                      0.0
LCK_M_UIX                        0.0                      0.0                      0.0
LCK_M_BU                         0.0                      0.0                      0.0
LCK_M_RS_S                       0.0                      0.0                      0.0
LCK_M_RS_U                       0.0                      0.0                      0.0
LCK_M_RIn_NL                     0.0                      0.0                      0.0
LCK_M_RIn_S                      0.0                      0.0                      0.0
LCK_M_RIn_U                      0.0                      0.0                      0.0
LCK_M_RIn_X                      0.0                      0.0                      0.0
LCK_M_RX_S                       0.0                      0.0                      0.0
LCK_M_RX_U                       0.0                      0.0                      0.0
LCK_M_RX_X                       0.0                      0.0                      0.0
SLEEP                            2127581.0                4.484455E+8              4.3421584E+8
IO_COMPLETION                    270634.0                 2338275.0                4373.0
ASYNC_IO_COMPLETION              96.0                     10449.0                  0.0
RESOURCE_SEMAPHORE               0.0                      0.0                      0.0
DTC                              0.0                      0.0                      0.0
OLEDB                            1.9450382E+7             4.1249405E+9             4.1126484E+9
FAILPOINT                        0.0                      0.0                      0.0
RESOURCE_QUEUE                   832052.0                 1.275044E+9              4.2561488E+8
ASYNC_DISKPOOL_LOCK              1449.0                   0.0                      0.0
UMS_THREAD                       0.0                      0.0                      0.0
PIPELINE_INDEX_STAT              2.0                      0.0                      0.0
PIPELINE_LOG                     0.0                      0.0                      0.0
PIPELINE_VLM                     0.0                      0.0                      0.0
WRITELOG                         349382.0                 5510704.0                55743.0
LOGBUFFER                        37486.0                  1127604.0                2639.0
PSS_CHILD                        0.0                      0.0                      0.0
EXCHANGE                         24379.0                  2963147.0                1324.0
XCB                              0.0                      0.0                      0.0
DBTABLE                          1.0                      4750.0                   0.0
EC                               4.0                      63.0                     0.0
TEMPOBJ                          0.0                      0.0                      0.0
XACTLOCKINFO                     0.0                      0.0                      0.0
LOGMGR                           0.0                      0.0                      0.0
CMEMTHREAD                       96786.0                  1721.0                   1658.0
CXPACKET                         5535501.0                1.3340896E+8             1150923.0
PAGESUPP                         150926.0                 23754.0                  3138.0
SHUTDOWN                         0.0                      0.0                      0.0
WAITFOR                          2.0                      2030.0                   2030.0
CURSOR                           0.0                      0.0                      0.0
EXECSYNC                         38.0                     0.0                      0.0
LATCH_NL                         0.0                      0.0                      0.0
LATCH_KP                         0.0                      0.0                      0.0
LATCH_SH                         0.0                      0.0                      0.0
LATCH_UP                         3339.0                   42275.0                  0.0
LATCH_EX                         7.9713536E+7             1.1192282E+7             2702172.0
LATCH_DT                         0.0                      0.0                      0.0
PAGELATCH_NL                     0.0                      0.0                      0.0
PAGELATCH_KP                     0.0                      0.0                      0.0
PAGELATCH_SH                     10134.0                  244516.0                 1155.0
PAGELATCH_UP                     91059.0                  38990.0                  2793.0
PAGELATCH_EX                     13573.0                  14029.0                  328.0
PAGELATCH_DT                     0.0                      0.0                      0.0
PAGEIOLATCH_NL                   0.0                      0.0                      0.0
PAGEIOLATCH_KP                   0.0                      0.0                      0.0
PAGEIOLATCH_SH                   62295.0                  1094631.0                22846.0
PAGEIOLATCH_UP                   3629.0                   109944.0                 61.0
PAGEIOLATCH_EX                   7882.0                   159029.0                 31.0
PAGEIOLATCH_DT                   0.0                      0.0                      0.0
TRAN_MARK_NL                     0.0                      0.0                      0.0
TRAN_MARK_KP                     0.0                      0.0                      0.0
TRAN_MARK_SH                     0.0                      0.0                      0.0
TRAN_MARK_UP                     0.0                      0.0                      0.0
TRAN_MARK_EX                     0.0                      0.0                      0.0
TRAN_MARK_DT                     0.0                      0.0                      0.0
NETWORKIO                        1371984.0                4.5004976E+7             0.0
Total                            1.1016541E+8             6.131689E+9              4.9764367E+9
 
(78 row(s) affected)
 
 
(78 row(s) affected)
 
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
 
*********************************************************************
Print out DBCC Input buffer for all blocked or blocking spids.
*********************************************************************
 
DBCC INPUTBUFFER FOR SPID 104
EventType Parameters EventInfo       
--------- ---------- --------------- 
RPC Event 0          sp_executesql;1
 
(1 row(s) affected)
 
 
(1 row(s) affected)
 
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
 
DBCC INPUTBUFFER FOR SPID 110
EventType Parameters EventInfo       
--------- ---------- --------------- 
RPC Event 0          sp_executesql;1
 
(1 row(s) affected)
 
 
(1 row(s) affected)
 
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
 
DBCC INPUTBUFFER FOR SPID 59
EventType Parameters EventInfo       
--------- ---------- --------------- 
RPC Event 0          sp_executesql;1
 
(1 row(s) affected)
 
 
(1 row(s) affected)
 
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
 
DBCC INPUTBUFFER FOR SPID 67
EventType Parameters EventInfo       
--------- ---------- --------------- 
RPC Event 0          sp_executesql;1
 
(1 row(s) affected)
 
 
(1 row(s) affected)
 
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
 
DBCC INPUTBUFFER FOR SPID 72
EventType      Parameters EventInfo                  
-------------- ---------- -------------------------- 
Language Event 0          exec sp_trace_getdata 1, 0
 
(1 row(s) affected)
 
 
(1 row(s) affected)
 
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
 
DBCC INPUTBUFFER FOR SPID 75
EventType Parameters EventInfo    
--------- ---------- ------------ 
RPC Event 0          sp_execute;1
 
(1 row(s) affected)
 
 
(1 row(s) affected)
 
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
 
DBCC INPUTBUFFER FOR SPID 77
EventType Parameters EventInfo     
--------- ---------- ------------- 
RPC Event 0          sp_prepexec;1
 
(1 row(s) affected)
 
 
(1 row(s) affected)
 
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
 
DBCC INPUTBUFFER FOR SPID 96
EventType Parameters EventInfo     
--------- ---------- ------------- 
RPC Event 0          sp_prepexec;1
 
(1 row(s) affected)
 
 
(1 row(s) affected)
 
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
 
DBCC INPUTBUFFER FOR SPID 98
EventType Parameters EventInfo       
--------- ---------- --------------- 
RPC Event 0          sp_executesql;1
 
(1 row(s) affected)
 
 
(1 row(s) affected)
 
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
 
*******************************************************************************
Print out DBCC OPENTRAN for active databases for all blocked or blocking spids.
*******************************************************************************
 
DBCC OPENTRAN FOR DBID 1 [master]
No active open transactions.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
 
 
DBCC OPENTRAN FOR DBID 8 [SOYSourceSQL]
No active open transactions.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
 
End time: 2008-02-26 16:07:39.427
 
Keywords: Blocking After SLQ SP4 Installed - Pa…
Title
1 ORA-01460: unimplemented or u…
2 Blocking after SQL SP4 Installed
3 ODBC / IIS
4 Help connecting to a remote ODBC ser…
5 IIS and SP4
6 ODBC timeout
 
Loading Advertisement...
 
[+][-]02.26.2008 at 06:22PM PST, ID: 20990806

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]02.26.2008 at 06:39PM PST, ID: 20990880

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]02.26.2008 at 06:41PM PST, ID: 20990894

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]02.26.2008 at 07:37PM PST, ID: 20991178

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]02.26.2008 at 07:41PM PST, ID: 20991192

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]02.26.2008 at 08:05PM PST, ID: 20991270

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]02.26.2008 at 08:58PM PST, ID: 20991464

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]03.12.2008 at 04:31PM PDT, ID: 21111892

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]03.12.2008 at 04:34PM PDT, ID: 21111905

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]03.12.2008 at 05:19PM PDT, ID: 21112157

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]03.12.2008 at 05:52PM PDT, ID: 21112336

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: MS SQL Server, Microsoft Access Database
Tags: Microsoft, SQL Server 2000, Access 2000, Access front end running on SQL back end. SQL database running merge replication.
Sign Up Now!
Solution Provided By: chapmandew
Participating Experts: 1
Solution Grade: B
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628