Solved

Should you turn Paging file off in a SSD SQL Server with 80 Gigs of ram

Posted on 2012-03-19
3
502 Views
Last Modified: 2012-03-23
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?
0
Comment
Question by:Iconn31
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 42

Expert Comment

by:dqmq
ID: 37739695
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.
0
 
LVL 1

Author Comment

by:Iconn31
ID: 37739754
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.
0
 
LVL 10

Accepted Solution

by:
asavah earned 500 total points
ID: 37741479
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.
0

Featured Post

Free NetCrunch network monitor licenses!

Only on Experts-Exchange: Sign-up for a free-trial and we'll send you your permanent license!

Here is what you get: 30 Nodes | Unlimited Sensors | No Time Restrictions | Absolutely FREE!

Act now. This offer ends July 14, 2017.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

OfficeMate Freezes on login or does not load after login credentials are input.
This article provides a convenient collection of links to Microsoft provided Security Patches for operating systems that have reached their End of Life support cycle. Included operating systems covered by this article are Windows XP,  Windows Server…
This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

628 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question