SQL Server 2008 | Need to change no. of CPU

Question

Hi,

We have a Win Server 2008 machine on which SQL Server 2008 is installed.

Now I need to reduce the no. of CPUs for testing purpose using MSCONFIG -> Boot option

Will this change cause any issues in the existing SQL Server. We cant afford any issues.

What is the best way to reduce the no. of CPUs in this case.

Thanks,

Raghava

Answer 1

Hi,

Select your instance in SSMS (SQL Server Management Studio)-> Right Click-> Properties:

You can change the configuration in the window below:

Cheers

---

MCP, MCTS, MCITP

Answer 2

Hi Soheil,

Actually I need to reduce the No. of CPUs applicable for the whole Win Server.

That can be done by using command MSCONFIG.

but I'm worried this may raise issues in SQL Server running in that machine. Can I proceed in this way.

---

Raghava

Answer 3

You need to remove CPU physically from Server board. Windows will consume all CPU avilable in board & SQL server will use all CPU visible for windows. As per me, No other way of reducing CPUs at windows & SQL server level.

---

Please click the Mark as Answer or Vote As Helpful if a post solves your problem or is helpful!

Answer 4

@Rohit: Removing the CPU physically is not possible, so this option is out.

@Soheil & Rohit : I forgot to mention earlier , I have to reduce the #CPU and also RAM memory in 2 Physical servers in which SQL Cluster is made.

This reduction in #CPU and RAM should be applicable to entire machine not only for SQL Server instance.

I've to repeat again, there should not be any issues after doing the changes to CPU & RAM :(

Please suggest me a feasible solution.

Thanks

---

Raghava

Answer 5

• Before doing this you need to analysis your CPU & memory uasge to decide the effect of reducing memory & CPU. If this is done without analysis then you can face slow server responce, server hung kind of issue.
• As mention before, removing CPU physically  is the only option

---

Please click the Mark as Answer or Vote As Helpful if a post solves your problem or is helpful!