* column description of sqlserver.query_thread_profile.[total_time_us] is following..
-- Cumulative time in microseconds, including waits
* and this is a query of my event session
create event session [somesession] on server
add event [sqlserver.query_thread_profile
( action (
sqlserver.database_id,
sqlserver.is_system,
sqlserver.plan_handle,
sqlserver.query_hash_signed,
sqlserver.query_plan_hash_signed,
sqlserver.sql_text)
where sqlserver.database_id > 4 -- all plan nodes from user database
and sqlserver.is_system = 0 -- non system queries
and [total_time_us] > 100000 -- all plans exceeding 100 milliseconds, I tried 10, 100, 5.
) add target package0.ring_buffer(SET max_memory=(4096))
and even I ran a stored procedure (simple select query) which took longer that 5 seconds, but data greater than 0 barely had been collected.
also sql version I tested is 'Microsoft SQL Server 2017 (RTM-CU17)'