Understanding "Mode" Parameter and Finding Documentation for Event Properties in SQL Server
1
vote
1
answer
98
views
I'm working with an extended event session in SQL Server and encountered a part of the T-SQL code that I don't fully understand. Specifically, I'm puzzled by the use of "Mode = 3 OR Mode = 4" in the following portion of the code:
...
ADD EVENT sqlserver.latch_suspend_end
(WHERE (
Duration > 0
AND (Mode = 3 OR Mode = 4)
AND has_waiters = 1
)
)
...
I've been trying to find documentation or any sort of information that explains what "Mode = 3" and "Mode = 4" represent in this context, but so far, I've had no luck.
Furthermore, I'm interested in finding a comprehensive source of documentation or reference that describes the properties and possible values for different events, not just for this specific example. Could anyone point me towards the relevant documentation or explain what these Mode values signify in this extended event session?
Thank you in advance for your help!
Asked by Fajela Tajkiya
(1239 rep)
Jul 15, 2023, 11:29 PM
Last activity: Jul 16, 2023, 08:55 PM
Last activity: Jul 16, 2023, 08:55 PM