Avatar of PaRamirez
PaRamirez
Flag for United States of America asked on

SQL Cluster had 2 CPUs Removed or Disabled due to licensing, can we put them back?

We have a SQL cluster and to comply with licensing we either disabled in the BIOS or physcially removed CPUs. Im not sure which yet. In either case can it kill the cluster or create any issues, to take a SQL cluster and just either re-add CPUs when it is down or re-enabled a CPU in the BIOS?

To perform this process on a 2 node SQL cluster is there any special steps or things to make sure of or watch out for? Whats the best way to do this if possible?
Microsoft SQL Server 2008Microsoft SQL ServerServer Hardware

Avatar of undefined
Last Comment
andyalder

8/22/2022 - Mon
Wouter Boevink

Didn't you limit the number of processor sql uses in the sql configuration?

To find out how your SQL Server is currently configured, right-click on the server in Enterprise Manger or Management Studio, and select “Properties”. Next, select the “Processor Tab” from the “SQL Server Properties” dialog box.
 
Here, you should see an option under “Parallelism” called “Use all available processors”. By default, after installing SQL Server, this option is selected. When this option is selected, SQL Server will automatically take advantage of all the CPUs in your server. The other option user “Parallelism” is “Use x processor(s)”, where the x refers to the number of processors in your server.
PaRamirez

ASKER
I was told what counts is what the OS sees, and the merely disabling how may procs are used in SQL does not make you compliant? And really this is for re-enabling missing CPUs in the BIOS or putting back in place the physical CPU's that were most likely physically removed. I am farily sure there are 2 CPUs now physcially in place per node, we will be most likely adding 2 CPUs to each member of the cluster, hence adding 4 procs in total to a 2 node cluster. [adding 2 new procs to each node for total of 4 procs per each node or 8 total procs in the cluster, where as now there are 4 total Procs at 2 a piece]

So really I am asking what will happen if I re-Add physical procs back to the server, do I have to make any changes to anything? Changes in SQL, changes in the OS, changes in the BIOS, what and where???
ASKER CERTIFIED SOLUTION
Wouter Boevink

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
PaRamirez

ASKER
1. Do the CPUs that go back in have to match 1:1 what is already in place?

2. How do you change to a multiprocessor HAL???
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
andyalder

Very few boards support two different speed CPUs, they're normally fussy enough to want them to be all/both the same stepping (bit like firmware level). You probably have MP HAL already, what CPUs or make/model server is it?