SQLTeam.com | Weblogs | Forums

Extended Events


#1

Hi. I need to Capture stored procedure which shows error (User defined- Example - DB error in executing query) using extended events features . Could someone help on this. Thanks.


#2

Could you please help me on this requirement , Below is the query am using but not capturing , Please help on this. Thanks

CREATE EVENT SESSION [Error] ON SERVER
ADD EVENT sqlserver.rpc_completed(
ACTION(sqlserver.sql_text,sqlserver.tsql_stack)
WHERE ([sqlserver].like_i_sql_unicode_string))
ADD TARGET package0.event_file(SET filename=N'E:\XEvents\Error.xel',metadatafile=N'E:\XEvents\Error.xem')
WITH (MAX_MEMORY=40960 KB,EVENT_RETENTION_MODE=ALLOW_SINGLE_EVENT_LOSS,MAX_DISPATCH_LATENCY=30 SECONDS,MAX_EVENT_SIZE=0 KB,MEMORY_PARTITION_MODE=NONE,TRACK_CAUSALITY=OFF,STARTUP_STATE=OFF)
GO


#3

Could someone please help on my requirement.