ALTER EVENT SESSION |
Modifie la session d'événement |
|---|---|
| Microsoft SQL Server |
Syntaxe
|
ALTER EVENT SESSION event_session_name ON SERVER { [ [ { add_drop_event [ ,...n] } | { add_drop_event_target [ ,...n ] } ] [ WITH ( event_session_options [ ,...n ] ) ] ] | [ STATE = { START | STOP } ] } add_drop_event::= { [ ADD EVENT event_specifier [ ( { [ SET { event_customizable_attribute = value [ ,...n ] } ] [ ACTION ( { [event_module_guid].event_package_name.action_name [ ,...n ] } ) ] [ WHERE predicate_expression ] } ) ] ] | DROP EVENT event_specifier } event_specifier ::= { [event_module_guid].event_package_name.event_name } predicate_expression ::= { [ NOT ] predicate_factor | {( predicate_expression ) } [ { AND | OR } [ NOT ] { predicate_factor | ( predicate_expression ) } ] [ ,...n ] } predicate_factor::= { predicate_leaf | ( predicate_expression ) } predicate_leaf::= { predicate_source_declaration { = | < > | ! = | > | > = | < | < = } value | [event_module_guid].event_package_name.predicate_compare_name ( predicate_source_declaration, value ) } predicate_source_declaration::= { event_field_name | ( [event_module_guid].event_package_name.predicate_source_name ) } value::= { number | 'string' } add_drop_event_target::= { ADD TARGET event_target_specifier [ ( SET { target_parameter_name = value [ ,...n] } ) ] | DROP TARGET event_target_specifier } event_target_specifier::= { [event_module_guid].event_package_name.target_name } event_session_options::= { [ MAX_MEMORY = size [ KB | MB] ] [ [,] EVENT_RETENTION_MODE = { ALLOW_SINGLE_EVENT_LOSS | ALLOW_MULTIPLE_EVENT_LOSS | NO_EVENT_LOSS } ] [ [,] MAX_DISPATCH_LATENCY = { seconds SECONDS | INFINITE } ] [ [,] MAX_EVENT_SIZE = size [ KB | MB ] ] [ [,] MEMORY_PARTITION_MODE = { NONE | PER_NODE | PER_CPU } ] [ [,] TRACK_CAUSALITY = { ON | OFF } ] [ [,] STARTUP_STATE = { ON | OFF } ] } |
Description
Cette instruction permet de débuter ou d'arrêter une session d'événement ou change la configuration de session d'événement.
Dernière mise à jour : Vendredi, le 19 Juin 2020