Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2013-12-09
1
Medium Priority
?
236 Views
Last Modified: 2013-12-09
Is there a script to find how many CPUs are alloacted to each VM for SQL Server 2008R2?
0
Comment
Question by:JGH5
1 Comment
 
LVL 19

Accepted Solution

by:
jss1199 earned 2000 total points
ID: 39707051
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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

972 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question