Time unit used to measure CPU usage

Question

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

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

Ben Teraberry SSChampion Points: 11845 More actions · Answer 1

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]

leonardo_gt Old Hand Points: 382 More actions · Answer 2

Yes ... I think I need glasses :$

Because it checked about 3 times and not found it.

Thanks

Steve Jones - SSC Editor SSC Guru Points: 737204 More actions · Answer 3

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.