T-SQL: Check cpu usage SQL statements
To identify the queries that are responsible for high-CPU activity currently, run the following statement: If queries aren’t driving the CPU at this moment, you can run the following statement to look for historical CPU-bound queries: