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?
LVL 1
Iconn31Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

dqmqCommented:
Not recommended to turn off paging and not worth the negligible benefits, if any.  Seems like the more relevant question is what's the best use for your SSD storage:  paging file or database storage.  

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.
Iconn31Author Commented:
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.
Member_2_6373554Commented:
What's your OS version/edition?

If you see 32 gigs available then I suppose you have windows server 2008r2 standard which has physical memory limit of 32GB, if it's true then you need to upgrade your OS in order to use 80GB ...

http://msdn.microsoft.com/en-us/library/windows/desktop/aa366778%28v=vs.85%29.aspx#physical_memory_limits_windows_server_2008_r2

Paging file would add to available memory, it never limits it.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Server Hardware

From novice to tech pro — start learning today.