There was a question in this forum about Extended Event module_end
duration unit, which I answered. Details here.
Is it always in microseconds for all events?
extended-eventssql server
There was a question in this forum about Extended Event module_end
duration unit, which I answered. Details here.
Is it always in microseconds for all events?
Best Answer
It is a mix of Millisecond, Microsecond and some are unknown. Easiest way to find I used below tsql code to determine which is what.
Here is the result set from a SQL 2016 SP1 server. I only posting part of it. Look at the DurationUnit column and you can see 3 different values.
For NULL ones I find the best option is to run (if possible with start and end time) and find what the unit is.
I ran the same query against vnext SQL Server and confirmed we will carry the same confusion to the future.