sys.server_event_sessions (Transact-SQL)
Lists all the event session definitions that exist in SQL Server.
Column name |
Data type |
Description |
---|---|---|
event_session_id |
int |
The unique ID of the event session. Is not nullable. |
name |
sysname |
The user-defined name for identifying the event session. name is unique. Is not nullable. |
event_retention_mode |
nchar(1) |
Determines how event loss is handled. Is one of the following:
The default is S. Is not nullable. |
event_retention_mode_desc |
sysname |
Describes how event loss is handled. Is one of the following:
The default is ALLOW_SINGLE_EVENT_LOSS. Is not nullable. |
max_dispatch_latency |
int |
The amount of time, in milliseconds, that events will be buffered in memory before they are served to session targets. Valid values are from 1 to 2147483648, and -1. A value of -1 indicates that dispatch latency is infinite. Is nullable. |
max_memory |
int |
The amount of memory allocated to the session for event buffering. The default value is 4 MB. Is nullable. |
max_event_size |
int |
The amount of memory set aside for events that do not fit in event session buffers. If max_event_size exceeds the calculated buffer size, two additional buffers of max_event_size are allocated to the event session. Is nullable. |
memory_partition_mode |
nchar(1) |
The location in memory where event buffers are created. memory_partition_mode is one of:
The default partition mode is G. Is not nullable. |
memory_partition_mode_desc |
sysname |
Is one of the following:
The default is NONE. Is not nullable. |
track_causality |
bit |
Enable or disable causality tracking. If set to 1 (ON), tracking is enabled and related events on different server connections can be correlated. The default setting is 0 (OFF). Is not nullable. |
startup_state |
bit |
Value determines whether or not session is started automatically when the server starts. Is one of:
The default is 0. Is not nullable. |
Permissions
Requires VIEW SERVER STATE permission on the server.
Zobacz także
Odwołanie
Extended Events Catalog Views (Transact-SQL)