Skip to content

Instantly share code, notes, and snippets.

@arman-hpp

arman-hpp/UsedCpuCores.sql

Created September 20, 2016 07:20
Show Gist options
  • Save arman-hpp/3ee7f7f612c842553cfc4c5bde0ead96 to your computer and use it in GitHub Desktop.
Save arman-hpp/3ee7f7f612c842553cfc4c5bde0ead96 to your computer and use it in GitHub Desktop.
Download ZIP
SqlServer used cpu cores
Raw
UsedCpuCores.sql
select cpu_count from sys.dm_os_sys_info
select scheduler_id,cpu_id, status, is_online from sys.dm_os_schedulers where status='VISIBLE ONLINE'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment