Is there a DMV that report to total CPU time consumed by all SQL sessions (maybe even just user sessions)?
I am looking for total CPU consumption similar to what dm_os_wait_stats gives for wait events.
I know that I can query dm_exec_query_stats but not all queries are cached.
This info is critical so I am sure there is an easy way to get it from one of the DMVs (I know that I can get it using profiler). In Oracle it is on the top of the AWR report …
Thanks in advance
View Complete Post