Sign in
 

none
SQL VM - Decrease quantity of Virtual CPU assigned

 > 

    Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi -

    For the following scenario:

    Hyper-V on Windows Server 2012 R2 Host

    VM running Server 2012 R2 with SQL 2012 (non-R2) installed.

    Is it possible to decrease the number of virtual CPU assigned to the Hyper-V VM from 4 to 2?

    Thanks!

    Thursday, March 9, 2017 9:52 PM
    |

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Strongbad2,

    Technically, it is possibly for a VM.

    But I'm not sure if there would be any effect on SQL application.

    You may post in SQL forum to see if anyone have tested the operation before.

    Best Regards,

    Leo

    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    • Proposed as answer by Leo HanModerator Wednesday, March 22, 2017 5:45 AM
    • Marked as answer by strongbad2 Wednesday, March 22, 2017 12:04 PM
    Friday, March 10, 2017 2:20 AM
    |
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    "Is it possible to decrease the number of virtual CPU assigned to the Hyper-V VM from 4 to 2?"

    As Leo says, yes it is possible.  Open the settings for the VM and change the value.

    But, as Leo says, it may impact the performance.

    . : | : . : | : . tim

    • Proposed as answer by Leo HanModerator Wednesday, March 22, 2017 5:45 AM
    • Marked as answer by strongbad2 Wednesday, March 22, 2017 12:04 PM
    Friday, March 10, 2017 2:27 PM
    |

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Strongbad2,

    Technically, it is possibly for a VM.

    But I'm not sure if there would be any effect on SQL application.

    You may post in SQL forum to see if anyone have tested the operation before.

    Best Regards,

    Leo

    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    • Proposed as answer by Leo HanModerator Wednesday, March 22, 2017 5:45 AM
    • Marked as answer by strongbad2 Wednesday, March 22, 2017 12:04 PM
    Friday, March 10, 2017 2:20 AM
    |
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    "Is it possible to decrease the number of virtual CPU assigned to the Hyper-V VM from 4 to 2?"

    As Leo says, yes it is possible.  Open the settings for the VM and change the value.

    But, as Leo says, it may impact the performance.

    . : | : . : | : . tim

    • Proposed as answer by Leo HanModerator Wednesday, March 22, 2017 5:45 AM
    • Marked as answer by strongbad2 Wednesday, March 22, 2017 12:04 PM
    Friday, March 10, 2017 2:27 PM
    |
  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi,
    Are there any updates?
    You could mark the reply as answer if it is helpful.
    Best Regards,
    Leo

    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Wednesday, March 22, 2017 5:44 AM
    |
    Moderator