SQL Server 2012 扩展事件（1）XE向导

xuke123

　　CREATE EVENT SESSION [TestTrace] ON SERVER
　　ADD EVENT sqlserver.error_reported(
　　ACTION(sqlserver.client_app_name,sqlserver.database_id,sqlserver.query_hash,sqlserver.session_id,sqlserver.sql_text)
　　WHERE ([package0].[greater_than_uint64]([sqlserver].[database_id],(4)) AND [package0].[equal_boolean]([sqlserver].[is_system],(0)) AND [package0].[not_equal_boolean]([sqlserver].[is_system],(1)))),
　　ADD EVENT sqlserver.rpc_completed(
　　ACTION(sqlserver.client_app_name,sqlserver.database_id,sqlserver.query_hash,sqlserver.session_id,sqlserver.sql_text)
　　WHERE ([package0].[greater_than_uint64]([sqlserver].[database_id],(4)) AND [package0].[equal_boolean]([sqlserver].[is_system],(0)) AND [package0].[not_equal_boolean]([sqlserver].[is_system],(1)))),
　　ADD EVENT sqlserver.rpc_starting(
　　ACTION(sqlserver.sql_text)
　　WHERE ([package0].[not_equal_boolean]([sqlserver].[is_system],(1)))),
　　ADD EVENT sqlserver.sql_batch_completed(
　　ACTION(sqlserver.client_app_name,sqlserver.database_id,sqlserver.query_hash,sqlserver.session_id,sqlserver.sql_text)
　　WHERE ([package0].[greater_than_uint64]([sqlserver].[database_id],(4)) AND [package0].[equal_boolean]([sqlserver].[is_system],(0)) AND [package0].[not_equal_boolean]([sqlserver].[is_system],(1))))
　　ADD TARGET package0.ring_buffer
　　WITH (MAX_MEMORY=4096 KB,EVENT_RETENTION_MODE=ALLOW_SINGLE_EVENT_LOSS,MAX_DISPATCH_LATENCY=30 SECONDS,MAX_EVENT_SIZE=0 KB,MEMORY_PARTITION_MODE=NONE,TRACK_CAUSALITY=ON,STARTUP_STATE=OFF)
　　GO