I want to create a new session in Extended Events to track Queries that use lots of CPU_Time, but whats the Unit of CPU_TIME? ms? Microseconds?...

Duration seems to be Microseconds but I don't really know CPU_TIME and can't find any information regarding this...

Thanks, Jimm

  • CPU time is in miliseconds or here
    – Kin Shah
    Sep 1, 2016 at 16:10
  • I believe it is ms (i.e. millisecond)
    – jyao
    Sep 1, 2016 at 16:27
  • I guess for "cpu_time rpc_completed NULL", it means microsecond. But why the description is NULL? Jun 26, 2019 at 20:49

1 Answer 1


The sys.dm_xe_object_columns DMV shows metadata for each of the columns available for each event. Included is a "description" column, which is useful in answering your question.

    , object_name
    , type_name
    , description 
    name = 'cpu_time' -- any XE column name here

This will show you all of the extended event objects that have a cpu_time column, and the description will tell you what unit of measure the column uses.

You can see here that units may vary depending on the object. For example:

  • sql_statement_completed: Indicates the CPU time (in microseconds) that is consumed by the statement.
  • sql_batch_completed: The CPU time (in milliseconds) used by the batch.
  • fwiw cpu_time for my SQL 2019 server is microseconds for ALL events except perhaps vdw_statement_execution and vdw_backend_execution where the description says 'CPU time (ms)'.
    – Rory
    Sep 12, 2020 at 18:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.