Iconn31
asked on
Should you turn Paging file off in a SSD SQL Server with 80 Gigs of ram
Good morning,
We have a SSD Server running Windows 2008 64bit with a total of 111gigs of hard drive space. the current sql database is 32 gigs in size. we would like to turn the paging file off to utilize the amount of ram that is in the system. Is it Recommended?
We have a SSD Server running Windows 2008 64bit with a total of 111gigs of hard drive space. the current sql database is 32 gigs in size. we would like to turn the paging file off to utilize the amount of ram that is in the system. Is it Recommended?
ASKER
The reason i asked is because we have 80 gigs of ram. So the page file can really only be around 16 gigs. which causes the available amount of ram being shown is 32 gigs. so we have more then 40 gigs of ram sitting there not being used.
just seeing if the benefits would still be negligible.
just seeing if the benefits would still be negligible.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Off the cuff, SSD seems like an ideal use for page space, but if you aren't utilizing it, then perhaps it's better deployed in other ways.