I went into the properties of the session and added the client_app_name. I never closed my live data viewer and never stopped the session. IF EXISTS (SELECT name FROM sys.dm_xe_sessions WHERE Name = 'PySoup tracing')ĪDD EVENT sqlserver.rpc_completed (ACTION(sqlserver.sql_text )),ĪDD EVENT sqlserver.sp_statement_completed (ACTION(sqlserver.sql_text )),ĪDD EVENT sqlserver.sql_batch_completed (ACTION(sqlserver.sql_text )),ĪDD EVENT sqlserver.sql_statement_completed (ACTION(sqlserver.sql_text ))ĪDD TARGET package0.event_file(SET filename=N'tracing.xel')-, I created the event session using SQL Server 2012 instance and SSMS version, minus the application name event. This is just my take on it, with a bit of testing. Not that this would be deemed the answer in your situation, since you already marked it. However, I don't see sqlserver.client_app_name column when I view the event data in the GUI.
I thought that the ACTION clause was supposed to list the columns that were returned by the event. ADD TARGET package0.ring_buffer(SET max_events_limit=(1000000))ĪLTER EVENT SESSION ON SERVER
I have the following event session: IF EXISTS (SELECT name FROM sys.dm_xe_sessions WHERE Name = 'PySoup tracing')ĭROP EVENT SESSION ON SERVERĬREATE EVENT SESSION ON SERVERĪDD EVENT sqlserver.rpc_completed (ACTION(sqlserver.client_app_name, sqlserver.sql_text )),ĪDD EVENT sqlserver.sp_statement_completed (ACTION(sqlserver.client_app_name, sqlserver.sql_text )),ĪDD EVENT sqlserver.sql_batch_completed (ACTION(sqlserver.client_app_name, sqlserver.sql_text )),ĪDD EVENT sqlserver.sql_statement_completed (ACTION(sqlserver.client_app_name, sqlserver.sql_text ))ĪDD TARGET package0.event_file(SET filename=N'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log\PySoup tracing.xel')-,
I am trying to examine some T-SQL with extended events like I used to with SQL profiler.
0 kommentar(er)
