December 6, 2012

Extended Events Catalog Views

Se more view version maps here: Microsoft Sql System View Version Maps

sys.server_event_session_actions

action on each event of an event session.

Column name Sql 2005 Sql 2008 Sql 2008 R2 Sql 2012 Type Description
event_session_id   int The ID of the event session. Is not nullable.
event_id   int The ID of the event. This ID is unique within the event session object. Is not nullable.
name   sysname The name of the action. Is nullable.
package   sysname The name of the event package that contains the event. Is nullable.
module   sysname The name of the module that contains the event. Is nullable.

TSQL

Sql 2008
SELECT [event_session_id], [event_id], [name], [package], [module] FROM sys.server_event_session_actions
Sql 2008 R2
SELECT [event_session_id], [event_id], [name], [package], [module] FROM sys.server_event_session_actions
Sql 2012
SELECT [event_session_id], [event_id], [name], [package], [module] FROM sys.server_event_session_actions

Back to Top


sys.server_event_session_events

event in an event session.

Column name Sql 2005 Sql 2008 Sql 2008 R2 Sql 2012 Type Description
event_session_id   int The ID of the event session. Is not nullable.
event_id   int The ID of the event. This ID is unique within an event session object. Is not nullable.
name   sysname The name of the event. Is not nullable.
package   sysname The name of the event package that contains the event. Is not nullable.
module   sysname The name of the module that contains the event. Is not nullable.
predicate   nvarchar(3000) The predicate expression that is applied to the event. Is nullable.
predicate_xml       nvarchar(3000) The XML predicate expression that is applied to the event. Is nullable.

TSQL

Sql 2008
SELECT [event_session_id], [event_id], [name], [package], [module], [predicate] FROM sys.server_event_session_events
Sql 2008 R2
SELECT [event_session_id], [event_id], [name], [package], [module], [predicate] FROM sys.server_event_session_events
Sql 2012
SELECT [event_session_id], [event_id], [name], [package], [module], [predicate], [predicate_xml] FROM sys.server_event_session_events

Back to Top


sys.server_event_session_fields

customizable column that was explicitly set on events and targets.

Column name Sql 2005 Sql 2008 Sql 2008 R2 Sql 2012 Type Description
event_session_id   int The ID of the event session. Is not nullable.
object_id   int The ID of the object this field is associated with. Is not nullable.
name   sysname The name of the field. Is not nullable.
value   sql_variant The value of the field. Is not nullable.

TSQL

Sql 2008
SELECT [event_session_id], [object_id], [name], [value] FROM sys.server_event_session_fields
Sql 2008 R2
SELECT [event_session_id], [object_id], [name], [value] FROM sys.server_event_session_fields
Sql 2012
SELECT [event_session_id], [object_id], [name], [value] FROM sys.server_event_session_fields

Back to Top


sys.server_event_session_targets

event target for an event session.

Column name Sql 2005 Sql 2008 Sql 2008 R2 Sql 2012 Type Description
event_session_id   int The ID of the event session. Is not nullable.
target_id   int The ID of the target. ID is unique within the event session object. Is not nullable.
name   sysname The name of the event target. Is not nullable.
package   sysname The name of the event package that contains the event target. Is not nullable.
module   sysname The name of the module that contains the event target. Is not nullable.

TSQL

Sql 2008
SELECT [event_session_id], [target_id], [name], [package], [module] FROM sys.server_event_session_targets
Sql 2008 R2
SELECT [event_session_id], [target_id], [name], [package], [module] FROM sys.server_event_session_targets
Sql 2012
SELECT [event_session_id], [target_id], [name], [package], [module] FROM sys.server_event_session_targets

Back to Top


sys.server_event_sessions

Lists all the event session definitions that exist in SQL Server.

Column name Sql 2005 Sql 2008 Sql 2008 R2 Sql 2012 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:
S. Maps to event_retention_mode_desc = ALLOW_SINGLE_EVENT_LOSS
M. Maps to event_retention_mode_desc = ALLOW_MULTIPLE_EVENT_LOSS
N. Maps to event_retention_mode_desc = NO_EVENT_LOSS
The default is S. Is not nullable.
event_retention_mode_desc   sysname Describes how event loss is handled. Is one of the following:
ALLOW_SINGLE_EVENT_LOSS. Events can be lost from the session. Single events are dropped only when all event buffers are full. Losing single events when buffers are full allows for acceptable SQL Server performance characteristics, while minimizing the loss in the processed event stream.
ALLOW_MULTIPLE_EVENT_LOSS. Full event buffers can be lost from the session. The number of events lost depends on the memory size allocated to the session, the partitioning of the memory, and the size of the events in the buffer. This option minimizes performance impact on the server when event buffers are quickly filled. However, large numbers of events can be lost from the session.
NO_EVENT_LOSS. No event loss is allowed. This option ensures that all events raised are retained. Using this option forces all the tasks that fire events to wait until space is available in an event buffer. This may lead to detectable performance degradation while the event session is active.
The default is ALLOW_SINGLE_EVENT_LOSS. Is not nullable.
max_dispatch_latency   int The amount of time, in seconds, 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:
G - NONE
C - PER_CPU
N - PER_NODE
The default partition mode is G. Is not nullable.
memory_partition_mode_desc   sysname Is one of the following:
NONE. A single set of buffers are created within a SQL Server instance.
PER_CPU. A set of buffers is created for each CPU.
PER_NODE. A set of buffers is created for each non-uniform memory access (NUMA) node.
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:
0 (OFF). The session does not start when the server starts.
1 (ON). The event session starts when the server starts.
The default is 0. Is not nullable.

TSQL

Sql 2008
SELECT [event_session_id], [name], [event_retention_mode], [event_retention_mode_desc], [max_dispatch_latency], [max_memory], [max_event_size], [memory_partition_mode], [memory_partition_mode_desc], [track_causality], [startup_state] FROM sys.server_event_sessions
Sql 2008 R2
SELECT [event_session_id], [name], [event_retention_mode], [event_retention_mode_desc], [max_dispatch_latency], [max_memory], [max_event_size], [memory_partition_mode], [memory_partition_mode_desc], [track_causality], [startup_state] FROM sys.server_event_sessions
Sql 2012
SELECT [event_session_id], [name], [event_retention_mode], [event_retention_mode_desc], [max_dispatch_latency], [max_memory], [max_event_size], [memory_partition_mode], [memory_partition_mode_desc], [track_causality], [startup_state] FROM sys.server_event_sessions

Back to Top

No comments:

Post a Comment

Total Pageviews