Solved

What are the ramifications of reducing the number of CPUs in a Windows 2012 virtual server

Posted on 2014-09-03
4
261 Views
Last Modified: 2014-09-08
We have a Windows 2012 R2 server running SQL server 2012.  The server is a virtual machine in ESXi 5.5.

One of the other engineers here gave the Virtual machine all 12 cores of the ESXI host.

My question is, Can I reduce the number of cores from12 back down to 4?

What impact would that have on either Windows Server 2012 R2 or SQL 2012?

Is it even possible or will I need to build a new server and migrate the databases?
0
Comment
Question by:Joel Parmer
4 Comments
 
LVL 14

Accepted Solution

by:
Brad Groux earned 500 total points
ID: 40301623
Windows Server 2012 has no problem handling changes to the number of CPUs assigned (or any other hardware components). Simply shutdown the server, make the changes in ESX and restart the server.

Obviously you want to monitor the health of the system once you bring it back up to insure that you didn't tune it down too much.
0
 
LVL 16

Expert Comment

by:DcpKing
ID: 40303692
There's also a benefit to reducing the number of cores associated with the VM - look at the licencing for your SQL Server instance. You may find (depending on the edition) that it's considerably cheaper to use 4 or 8  cores than it is to use all 12. Look at the MS Licencing Guide.

hth

Mike
0
 
LVL 1

Expert Comment

by:Ryan Mangan
ID: 40303871
Hi,

Have a read of the following article about CPU allocation.

http://ryanmangansitblog.com/2014/01/18/deciding-on-how-many-vcpus-should-a-virtual-machine-be-allocated/ 

Rule of thumb is start with one and add more if required, With regards to SQL always start with two vCPU's.

VMware does have a few artcles on Virtualising SQL which may also be of some use.

Have a look at the following:

http://www.vmware.com/files/pdf/solutions/SQL_Server_on_VMware-Best_Practices_Guide.pdf
0
 
LVL 8

Expert Comment

by:Ratnesh Mishra
ID: 40309656
It is really easy to understand how the CPU allocation works in HYPER-V of Microsoft virtualization and ESXi of VMWare virtualization.

http://sangnak.com/cpu-calculation-for-virtual-machine-in-hyper-v-and-esxi/

Hyper-V really works on core and limitation is of 4 core per VM  where as VMWare works on processing capacity means it will be in MHz or say GHz . Calculation of processing capacity can be find in the link mentioned above.
Now on to your question ,
Can I reduce the number of cores from12 back down to 4?
The best method or approach I would suggest is to check with the performance logs of the VM and its consumption during peak hours. If it never reaches to the total capacity allocated you can reduce it to the maximum limit it had achieved ever.
For example , you have installed ESXi on 12 core 3.2 GHz processor so total processing capacity allocated is  3.2x12 = 38.4 GHz and if you see in the performance log that it had reached maximum processing capacity of 12.6 Ghz . So allocating 4 core will be suggested. Apart from this ESXi also has a feature of giving more than the allocated processing capacity if its available on the ESXi and once the requirement goes down it reclaims it.

What impact would that have on either Windows Server 2012 R2 or SQL 2012?
Lowering of CPU doesnot always impact unless its a very high CPU intensive application is running. If you check and find that the usage of CPU doesnot exceed beyond a limit then lowering of CPU will not make much of a difference however if lowering of CPU is done even beyond the expected value or calculative value and not much of CPU processing is free then you may observe latency in SQL server or guest windows 2012.

Is it even possible or will I need to build a new server and migrate the databases?
Yes changing of CPU is possible. However change in number of CPU to the running VM is not allowed in ESXi , you can change it after shutting down the VM . Just for CPU changing its worthless to create new server or migrating database.

I would suggest you to change the CPU number and check if its working fine with you or not and if you find the CPU utilization is quite high in Windows server then you can revert back the changes.

If this much information doesn't provide you enough information ,please let me know so that either we can share the screenshot and suggest you the best solution.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Issue: One Windows 2008 R2 64bit server on the network unable to connect to a buffalo Device (Linkstation) with firmware version 1.56. There are a total of four servers on the network this being one of them. Troubleshooting Steps: Connect via h…
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
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

911 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now