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
Solved

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

Posted on 2012-03-19
3
495 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
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

Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

Suggested Solutions

You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
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 …

809 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