14,503 questions
SQL 2023 16.0.4065.3 When I use SQLSatellite.AppName in sql server extended events the trace stops capturing events
CUTHBERTSON, John
0
Reputation points
Works means that events are captured, fails means that the events are not captured. The works/fails state is switched by excluding/including SQLSatellite.AppName.
CREATE EVENT SESSION [RPC - Works1] ON SERVER
ADD EVENT sqlserver.rpc_completed(SET collect_statement=(1)
ACTION(sqlserver.database_name)
WHERE ([sqlserver].[equal_i_sql_unicode_string]([sqlserver].[database_name],N'SDIDIV')))
ADD TARGET package0.ring_buffer
WITH (MAX_MEMORY=8192 KB,EVENT_RETENTION_MODE=ALLOW_SINGLE_EVENT_LOSS,MAX_DISPATCH_LATENCY=5 SECONDS,MAX_EVENT_SIZE=0 KB,MEMORY_PARTITION_MODE=PER_CPU,TRACK_CAUSALITY=ON,STARTUP_STATE=OFF)
GO
CREATE EVENT SESSION [RPC - Fails1] ON SERVER
ADD EVENT sqlserver.rpc_completed(SET collect_statement=(1)
ACTION(SQLSatellite.AppName,sqlserver.database_name)
WHERE ([sqlserver].[equal_i_sql_unicode_string]([sqlserver].[database_name],N'SDIDIV')))
ADD TARGET package0.ring_buffer
WITH (MAX_MEMORY=8192 KB,EVENT_RETENTION_MODE=ALLOW_SINGLE_EVENT_LOSS,MAX_DISPATCH_LATENCY=5 SECONDS,MAX_EVENT_SIZE=0 KB,MEMORY_PARTITION_MODE=PER_CPU,TRACK_CAUSALITY=ON,STARTUP_STATE=OFF)
GO
CREATE EVENT SESSION [RPC - Fails2] ON SERVER
ADD EVENT sqlserver.rpc_completed(SET collect_statement=(1)
ACTION(SQLSatellite.AppName,sqlserver.database_name))
ADD TARGET package0.ring_buffer
WITH (MAX_MEMORY=8192 KB,EVENT_RETENTION_MODE=ALLOW_SINGLE_EVENT_LOSS,MAX_DISPATCH_LATENCY=5 SECONDS,MAX_EVENT_SIZE=0 KB,MEMORY_PARTITION_MODE=PER_CPU,TRACK_CAUSALITY=ON,STARTUP_STATE=OFF)
GO
SQL Server | Other
Sign in to answer