Applies To: SQL Server 2014, SQL Server 2016 Preview
Lists all the event session definitions that exist in SQL Server.
Applies to: SQL Server (SQL Server 2008 through current version).
The unique ID of the event session. Is not nullable.
The user-defined name for identifying the event session. name is unique. Is not nullable.
Determines how event loss is handled. Is one of the following:
The default is S. Is not nullable.
Describes how event loss is handled. Is one of the following:
The default is ALLOW_SINGLE_EVENT_LOSS. Is not nullable.
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.
The amount of memory allocated to the session for event buffering. The default value is 4 MB. Is nullable.
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.
The location in memory where event buffers are created. memory_partition_mode is one of:
The default partition mode is G. Is not nullable.
Is one of the following:
The default is NONE. Is not nullable.
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.
Value determines whether or not session is started automatically when the server starts. Is one of:
The default is 0. Is not nullable.
Requires VIEW SERVER STATE permission on the server.