none
new SQL server setup

    Question

  • Hi,

    based on my general knowledge of setting up SQL server on VM, I remember a best practice (or Right thing to do) about appropriate planning for number of processors. Especially, adding processors to production SQL set on VM.

    I need a confirmation if it is really sensitive matter about adding processors to SQL server Virtual machines.

    Don't think that hypervisor make any difference. But just in case, I am talking about VMWare platforme.

    Please provide a link to a document describing the impact of adding processors or just simple explanation why it is not recommended or just MUST not be done.

    Thanks.


    --- When you hit a wrong note its the next note that makes it good or bad. --- Miles Davis

    Wednesday, February 1, 2017 7:35 PM

Answers

  • It depends on the version of SQL Server.

    SQL Server 2008+ fully supports "hot add" CPUs and memory on Windows Server 2008 R2+.

    SQL Server is rarely CPU dependent.  So it usually has little affect.

    https://www.mssqltips.com/sqlservertip/3040/how-to-hotadd-a-vcpu-to-a-virtual-sql-server/

    • Marked as answer by pob579 Wednesday, February 1, 2017 10:03 PM
    Wednesday, February 1, 2017 7:39 PM

All replies

  • It depends on the version of SQL Server.

    SQL Server 2008+ fully supports "hot add" CPUs and memory on Windows Server 2008 R2+.

    SQL Server is rarely CPU dependent.  So it usually has little affect.

    https://www.mssqltips.com/sqlservertip/3040/how-to-hotadd-a-vcpu-to-a-virtual-sql-server/

    • Marked as answer by pob579 Wednesday, February 1, 2017 10:03 PM
    Wednesday, February 1, 2017 7:39 PM
  • Thanks!

    --- When you hit a wrong note its the next note that makes it good or bad. --- Miles Davis

    Wednesday, February 1, 2017 10:04 PM