SQL Server Performance

the order to restart sql cluster server

Discussion in 'SQL Server Clustering' started by danan_xu, May 18, 2005.

  1. danan_xu New Member

    hi, guys:

    want to ask you a question which might be quite simple for you. I need to restart cluster server ( windows 2003 & sql 2000 sp3, active/passive two nodes), I am wondering what's the order to restart it.
    Is it to
    1. shutdown passive node
    2. stop sql server on activenode
    3. shutdown active node
    4. start up active node
    5.start up passive node

    For I am new and don't have such experience. Please share your experience and any help will be appreciated
  2. danan_xu New Member

    can anyone give me a clue?
  3. deepakontheweb New Member


    Well, when I have to restart both A/P cluster nodes.. I do like this way..


    Restart Passive Node (Name: MacP).
    Once passive (MacP) node boot up, I use Cluster Admin and move SQL services from active (MacA) to Passive (MacP) Node.
    Confirm SQL is running fine (on MacP), then I do restart previously Active (MacA) node.


    This practice require very less downtime for application.. Its just like restart of SQL services.. It also test cluster services during moving SQL service; whether working fine or having troubles.


    Note: Using this way you get change in Active node to Passive and vice-versa.




    Deepak Kumar

    --An eye for an eye and everyone shall be blind
  4. Argyle New Member

    Yes no need to have both nodes offline at the same time. Follow procedure that Deepak mentions.
  5. danan_xu New Member

    thanks deepakontheweb & argyle.

    your infomation is quite useful.
    I am still wondering if there is any difference between restart two nodes as Deepakontheweb mentioned and shutdown.
    For there is a problem with sql server memoery leak, I want to restart totally to fresh the cluster system.

    thanks
  6. Argyle New Member

    There is no difference, one is faster that is all. You sure you have a memory leak? SQL Server will take all availabe memory on the system if it think it needs it. You can cap the max memory setting to leave 200-300 for the OS.
  7. danan_xu New Member

    thanks, Argyle

Share This Page