Time unit used to measure CPU usage

  • Which is the unit of time used to show in "Activity Monitor"? CPU time, or...

    in the column total_worker_time from sys.dm_exec_query_stats.

    I need to convert this value in second, minutes, etc?

    Thanks in advance

  • SQL Server Books Online is your friend.

    sys.dm_exec_query_stats:

    total_worker_time

    bigint

    Total amount of CPU time, in microseconds, that was consumed by executions of this plan since it was compiled.

    └> bt



    Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • Yes ... I think I need glasses :$

    Because it checked about 3 times and not found it.

    Thanks

  • microseconds, just in case anyone else can't find it.

    BOL can be hard to read. I would think they'd have included an abbreviation "mu" for the reading as well.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply