Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

LAST_MODE should map to LCK_M_RX_X in the lock_mode Extended Event

This is just plain wrong.

SELECT mv.name, mv.map_value, xo.description, xp.description
FROM sys.dm_xe_map_values AS mv
JOIN sys.dm_xe_objects AS xo
ON mv.object_package_guid = xo.package_guid
AND mv.name = xo.name
JOIN sys.dm_xe_packages AS xp
ON xo.package_guid = xp.guid
WHERE mv.name = 'lock_mode'
ORDER BY mv.map_key;

7 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Erik Darling shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    0 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base