AX / Dynamics 365 For Finance and Operations blog

To check how many CPU’s SQL Database Server is able to use, run the following SQL Query:

select scheduler_id,cpu_id, status, is_online from sys.dm_os_schedulers

the CPUs used are those with status = Visible online