SQL Server Performance

Increasing virtual memory(page file) in Cluster

Discussion in 'SQL Server Clustering' started by Hover, Apr 22, 2006.

  1. Hover New Member

    There is some urgent need arised to increase the page file on the nodes of cluster .This is an active passive SQL server cluster. Is it good to increase page file in cluster enviorment.Will increasing the page file can affect the sql server.Moreover if I increase the page file of one node will it be reflected/or needed in other node.
  2. simondm New Member

    You will need to do it on each node of the cluster - the change will not replicate between nodes.

    When you go into the page file settings make sure the size is as big as Windows is recommending. If not grow it (providing you have the disk space).

    SQL will only use the additional page file space if Windows requires it. growing it will not have an adverse effect on SQL.

    Simon

  3. Luis Martin Moderator

    I've moved to relevant forum.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
    Leonardo Da Vinci

    Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte


    All postings are provided “AS IS” with no warranties for accuracy.



  4. satya Moderator

    We had lot of problem when attempted on the Clustered environment.
    Hover, is that suggestion referred by a MS Expert or it has been found from your investigations.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  5. simondm New Member

    I've done this at least 2 or 3 times in a clustered/AWE environments and haven't seen any problems (that I know of <img src='/community/emoticons/emotion-5.gif' alt=';)' />). What problems have you seen?<br /><br />

Share This Page