Solved

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

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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
A safe way to clean winsxs folder from your windows server 2008 R2 editions
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

707 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now