Monitor CPU usage MS SQL Server

Ensure the user has permission

1
2
3

USE master;
GRANT VIEW SERVER STATE TO username;
GO

Select from view sys.dm_os_sys_info

1	select * from sys.dm_os_sys_info