Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2016
    Posts
    13

    Unanswered: capture sql text on blocked user process

    Hi gurus,
    I'm trying to capture running SQL text from the holding blocked process using monprocesssqltext table. unfortunately, the script cannot captured the SQL text if the holding blocked process command is "AWAITING COMMAND". any explanations why monprocesssqltext cannot capture the sql text from the holding block process?

    Thanks in advance

  2. #2
    Join Date
    Jun 2017
    Posts
    5
    it's ok to check syslocks to find out

Posting Permissions

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