find out most CPU resouces consuming queries in SQL SERVER

Find queries that are consuming the most CPU resources and query plans

SELECT TOP 50 qs.total_worker_time/qs.execution_count as [Avg CPU Time],

SUBSTRING(qt.text,qs.statement_start_offset/2, (case when qs.statement_end_offset = -1 then len(convert(nvarchar(max), qt.text)) * 2

else qs.statement_end_offset end -qs.statement_start_offset)/2) as query_text,

qt.dbid, dbname=db_name(qt.dbid), qt.objectid, qp.query_plan

FROM sys.dm_exec_query_stats qs cross apply sys.dm_exec_sql_text(qs.sql_handle) as qt

cross apply sys.dm_exec_query_plan(qs.plan_handle) as qp

ORDER BY [Avg CPU Time] DESC