lock mail missing information


Since the update in version 13.5, the information of the blocking session in the alert email is no longer present.

Have you the same error ?

Thank you for your help.

  • Hi Emmanuel,

    Thank you so much for your question and we did have some tickets regarding this issue but in version 13.5.1.

    In this case, I would like to confirm if you are able to see the information using the following statement:

    SELECTdec.session_id,dec.properties,dec.creation_time,dec.is_open, sqltext.text
    FROM sys.dm_exec_cursors(@sessoinid)dec
    CROSSAPPLY sys.dm_exec_sql_text(dec.sql_handle) sqltext


    If you are able to see the blocking session information, but cannot see in Spotlight, please open a ticket with the Spotlight technical support team for further investigation.


    Thank you,