New answers tagged extended-events
2
votes
Why execution plan could be skipped from XE session?
It looks like you are using a ring buffer and "Watch Live Data".
Sometimes, plans can be larger than 4MB (the default setting for XE), and they can be dropped from the result set.
You should ...
2
votes
Sql Server Extened Events lock_acquired and lock_released - The meaning of resource_0, resource_1 and resource_2
It means different things for different types of locks. In your case the resource_0 matches the associated_object_id
To parse other types of resources I usually use these posts:
Decoding Key and Page ...
3
votes
Accepted
Why can I not capture dynamic SQL called with EXEC using the sqlserver.sql_batch_completed Extended Event?
You're probably doing something wrong (like executing in a different database than you're filtering on). But to answer the question:
A batch is a set (one or more) of commands that a client sends to ...
Top 50 recent answers are included
Related Tags
extended-events × 224sql-server × 182
sql-server-2012 × 41
sql-server-2014 × 24
sql-server-2016 × 18
deadlock × 13
sql-server-2019 × 13
profiler × 11
performance × 10
sql-server-2008 × 10
sql-server-2008-r2 × 10
ssms × 10
sql-server-2017 × 9
blocking × 9
audit × 7
xml × 7
stored-procedures × 6
monitoring × 6
trace × 6
locking × 5
t-sql × 4
performance-tuning × 4
sql-server-2022 × 4
trigger × 3
execution-plan × 3