Slow query statement

Select
C.last_execution_time,c.exe cution_count, C. total_logical_reads, C. total_logical_writes, C. total_elapsed_time, C. last_elapsed_time,
Q. [text]
From
(Select top 50 Qs .*
From SYS. dm_exec_query_stats Qs
Order by QS. total_worker_time DESC) as C
Cross apply SYS. dm_exec_ SQL _text (plan_handle) as Q
Order by C. total_worker_time DESC

Queries statements with high CPU usage

Select top 10
Total_worker_time/execution_count as avg_cpu_cost, plan_handle,
Execution_count,
(Select substring (text, statement_start_offset/2 + 1,
(Case when statement_end_offset =-1
Then Len (convert (nvarchar (max), text) * 2
Else statement_end_offset
End-statement_start_offset)/2)
From SYS. dm_exec_ SQL _text (SQL _handle) as query_text
From SYS. dm_exec_query_stats
Order by [avg_cpu_cost] DESC