asked on

Is ity possible to find how many processors SQL server is using ? What is HIDDEN ONLINE mean ?

When I execute this below Query I got the following output. It saying 3 of them are VISIBLE ONLINE and remaining two it saying HIDDEN ONLINE. Does SQL server uses the Hidden CPUs ?

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

scheduler_id      cpu_id      status        is_online
0        0        VISIBLE ONLINE        1
1        1        VISIBLE ONLINE        1
1048578        0        HIDDEN ONLINE        1
1048579        1        HIDDEN ONLINE        1
1048576        0        VISIBLE ONLINE (DAC)        1

SOLUTION

Steve Wales

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

Vitor Montalvão

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Vitor Montalvão

But for knowing how many CPU's there's a simple query for that:

select cpu_count from sys.dm_os_sys_info

Open in new window