Dynamic Management Views (DMV)

DMV	Function
sys.dm_os_wait_stats	Verifying the extent of CPU pressure via signal waits.
sys.dm_os_wait_stats sys.dm_os_schedulers	Diagnosing a CPU-bound system according the types of wait observed.
sys.dm_exec_query_stats sys.dm_exec_sql_text	Identifying high-CPU cached plans, and associated queries.
sys.dm_os_waiting_tasks	Identifying currently waiting tasks, especially ones waiting on CPU-related wait types.
sys.dm_exec_requests	Observing the resource usage of currently executing queries.
sys.dm_exec_connections sys.dm_exec_sessiosn	Check connections (technical) & sessions (user related) to the server