SQL Server Performance Forum – Threads Archive

Increasing virtual memory(page file) in Cluster

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.

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

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.

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.

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 />

]]>