Results 1 to 8 of 8

Thread: Lock timeout Q

  1. #1
    Join Date
    Jun 2003
    Posts
    127

    Unanswered: Lock timeout Q

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

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Try an event monitor.

    Andy

  3. #3
    Join Date
    Jun 2003
    Posts
    127
    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.

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Actually, I believe that an event monitor for STATEMENT will get you what you want.

    Andy

  5. #5
    Join Date
    Jun 2003
    Posts
    127
    It just gives me the SQL,execution times, rows written/read ...Thats all

  6. #6
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    You should also get sqlcode, sqlerrd1, sqlerrd2, sqlerrd3, sqlerrd4, sqlerrd5, sqlerrd6,sqlerrm, sqlerrp, sqlstate, sqlwarn, etc.

    Andy

  7. #7
    Join Date
    Jun 2003
    Posts
    127
    Thanks. I see an SQLCODE. Probably it captures 911 too. So,from your response, it looks like this might be the only option.

  8. #8
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Only if you do not want to change the application to capture this information.

    Andy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •