How can I find out what my SqlServer 2005 CPU is mostly working on?
Ref: https://docs.microsoft.com/en-us/sql/t-sql/statements/set-statistics-time-transact-sql

You can use SET STATISTICS TIME ON.

You can get a breakdown of:


SQL Server parse and compile time
SQL Server Execution Times


You can turn this on in Management studio for all queries or per session.