CREATE EVENT SESSION [DB_Name SP execution] ON SERVER

ADD EVENT sqlserver.rpc_starting
(
    ACTION
    (
        sqlserver.database_id,sqlserver.database_name,
        sqlserver.server_instance_name,
        sqlserver.session_id
    )
    WHERE
    (
        [package0].[greater_than_uint64]([sqlserver].[database_id],(4))
            AND [package0].[equal_boolean]([sqlserver].[is_system],(0))
            AND [sqlserver].[database_id]=(34))
),

ADD EVENT sqlserver.sp_statement_starting
(
    SET collect_statement=(1)
    ACTION
    (
        sqlserver.database_id,sqlserver.database_name,
        sqlserver.server_instance_name,
        sqlserver.session_id
    )
    WHERE
    (
        [package0].[greater_than_uint64]([sqlserver].[database_id],(4))
            AND [package0].[equal_boolean]([sqlserver].[is_system],(0))
            AND [sqlserver].[database_id]=(34)
    )
),

ADD EVENT sqlserver.sql_batch_starting
(
    ACTION
    (
        sqlserver.database_id,sqlserver.database_name,
        sqlserver.server_instance_name,
        sqlserver.session_id
    )
    WHERE
    (
        [package0].[greater_than_uint64]([sqlserver].[database_id],(4))
            AND [package0].[equal_boolean]([sqlserver].[is_system],(0))
            AND [sqlserver].[database_id]=(34)
    )
)

ADD TARGET package0.event_file
(
    SET filename=N'D:pathtolog.xel',
    max_file_size=(5120)
)
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=ON
)

GO