• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 240
  • Last Modified:

Find how many CPUs are alloacted to each VM SQL Server 2008R2

Is there a script to find how many CPUs are alloacted to each VM for SQL Server 2008R2?
0
JGH5
Asked:
JGH5
1 Solution
 
jss1199Commented:
1. Count CPUs - select cpu_count from sys.dm_os_sys_info
2. Count cores - 1
select scheduler_id,cpu_id, status, is_online from sys.dm_os_schedulers where status='VISIBLE ONLINE'
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now