Lock timeout Q

Kota · #1 (**permalink**) 03-27-08, 12:28

Is there a way to capture locktimeout in realtime along with the tables involved and SQL.

ARWinner · #2 (**permalink**) 03-27-08, 12:46

Try an event monitor.

Andy

Kota · #3 (**permalink**) 03-27-08, 12:51

Does event monitor capture lock timeouts or just deadlocks? Also, since there might be overhead, any other way? I have seen that diaglevel 3 doesn't capture 911 errors.

ARWinner · #4 (**permalink**) 03-27-08, 12:56

Actually, I believe that an event monitor for STATEMENT will get you what you want.

Andy

Kota · #5 (**permalink**) 03-27-08, 13:04

It just gives me the SQL,execution times, rows written/read ...Thats all

ARWinner · #6 (**permalink**) 03-27-08, 13:10

You should also get sqlcode, sqlerrd1, sqlerrd2, sqlerrd3, sqlerrd4, sqlerrd5, sqlerrd6,sqlerrm, sqlerrp, sqlstate, sqlwarn, etc.

Andy

Kota · #7 (**permalink**) 03-27-08, 13:15

Thanks. I see an SQLCODE. Probably it captures 911 too. So,from your response, it looks like this might be the only option.

ARWinner · #8 (**permalink**) 03-27-08, 13:24

Only if you do not want to change the application to capture this information.

Andy

Internet Services

Web Development

Digital Marketing

Consumer Tech