asked on

The importance of swap file pagefile.sys ?

Hi All,

suppose I have one very powerful server which runs:

2x 12 core Xeon 5650
64 GB RAM
4x RAID 10 SAS 15k rpm HDD

Do I still need to use pagefile.sys or I can just turn it off completely ?

it is a physical server and it runs SQL Server 2008 Enterprise DB for OLAP

Thanks.

SOLUTION

tsmgeek

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

jjoz

ASKER

oh. so do you mean no SWAP could means BSoD ?

tsmgeek

i think its more likley you will have non-critical processes die first (sql included) but if it went too far then eventualy the system will grind to a halt
i cant remember 100% what happens on MS server as i always give them the same ammount as the ram but when you have such large ram mabey its not so much required

SOLUTION

Danny McDaniel

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

jjoz

ASKER

ok, can I make it approximately 16 GB for the current 64 GB server ?
so if the drive got zero disk space left, I can just reduce the size to 8 GB and then reboot the server ?

ASKER CERTIFIED SOLUTION

tsmgeek

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

jjoz

ASKER

ah ok, so I was wondering if using Guest OS swap file could potentially slowing it down, perhaps if it is WIndows Server it would be better to just disabling the swap file at all and then increasing the "paging size"

jjoz

ASKER

thanks !