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;

8 votes
Sign in
(thinking…)
Sign in with: oidc
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
(thinking…)
Sign in with: oidc
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base