Post reply

CPUU increase and database engine

  • December 10, 2014 at 10:19 pm

    #293391

    Hi,

    We are using Sql server 2008R2 and windows server 2008R2.

    To increase the vCPU for the server and the server need to be restarted.

    Do we need to shut down the database first before server restart?

    And do we need to start the database again after the server is up or it is automatically started?

    To shut down the database what kind of permissions do we need?

    Do we need to have serveradmin or sysadmin permissions?

  • December 10, 2014 at 11:25 pm

    #1763950

    ramana3327 (12/10/2014)

    Hi,

    We are using Sql server 2008R2 and windows server 2008R2.

    To increase the vCPU for the server and the server need to be restarted.

    Do we need to shut down the database first before server restart?

    I don't know much about the intricacies of VM but rumor has it that you can add virtual CPUs without shutting down the server. If you're talking about flipping the switch to shut down the server, that's never a good idea. If you do a normal Windows shutdown on the server, then you won't need to manually shut down SQL Server, although I can't get over the habit of doing so.

    And do we need to start the database again after the server is up or it is automatically started?

    It depends on whether you have the SQL Server Service setup for a manual or automatic start.

    To shut down the database what kind of permissions do we need?

    Do we need to have serveradmin or sysadmin permissions?

    It depends on how you want to shut down the server. If you do it via Windows, you'll need to be logged into Windows as someone that can control the Windows Server. You'll need to do that anyway, I would imagine.

    To shut down SQL Server, you can have either priv depending on how you want to shut SQL Server down.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply