Wyciągając różne informacje z Extended Events a zwłaszcza event_name dotyczące czasów można zaobserwować, że wartości zwracane są w różnych jednostkach czasu (milisekundy, mikrosekundy).
Poniżej przedstawiam zestawienie takich zdarzeń
| package_name | event_name | DurationUnit |
|---|---|---|
| sqlos | wait_info | milliseconds |
| sqlos | wait_completed | milliseconds |
| sqlos | wait_info_external | milliseconds |
| sqlserver | sql_statement_completed | microseconds |
| sqlserver | sp_statement_completed | microseconds |
| sqlserver | rpc_completed | microseconds |
| sqlserver | module_end | microseconds |
| sqlserver | sql_batch_completed | microseconds |
| sqlserver | logout | microseconds |
| sqlserver | attention | microseconds |
| sqlserver | existing_connection | microseconds |
| sqlserver | sql_statement_post_compile | milliseconds |
| sqlserver | lock_acquired | microseconds |
| sqlserver | lock_deadlock | microseconds |
| sqlserver | query_post_compilation_showplan | microseconds |
| sqlserver | query_post_execution_showplan | microseconds |
| sqlserver | query_plan_profile | microseconds |
| sqlserver | query_post_execution_plan_profile | microseconds |
| sqlserver | progress_report_online_index_operation | microseconds |
| sqlserver | columnstore_tuple_mover_end_compress | milliseconds |
| sqlserver | columnstore_tuple_mover_compression_stats | milliseconds |
| sqlserver | sql_transaction | microseconds |
| sqlserver | execution_warning | microseconds |
| sqlserver | blocked_process_report | microseconds |
| sqlserver | blocked_process_report_filtered | microseconds |
| XtpEngine | xtp_ckptctrl_storage_array_grow | microseconds |
