Trying to view all executions of a named stored procedure where execution time exceeds a given number of seconds. How do you filter on execution time (seconds)? This is what I have cobbled together so far
CREATE EVENT SESSION [Slow SP Executions]
ON SERVER
ADD EVENT sqlserver.module_end
(SET collect_statement = (1)
ACTION
(
sqlserver.host,
sqlserver.database_name,
sqlserver.client_app_name,
sqlserver.session_server_principal_name,
sqlserver.username,
sqlserver.sql_text,
sqlserver.tsql_stack
)
WHERE (
[object_type] = 'P '
AND [sqlserver].[database_name] = N'MyDB'
AND [object_name] = N'MySproc'
)
)