Solved

paging file using up c: ?   server 2008 r2

Posted on 2012-04-09
9
396 Views
Last Modified: 2012-04-15
I inherited a windows server 2008 R2. It has 18GB of Ram.
There are several Drives. C:, D:, E:, F:, and G:
This server has MS SQL 2008 and runs several different instances.
The C:\ drive is 68GB and is full or near full. The folders on this drive only add up to about 40 GB of used space. I was thinking maybe the paging file was using the remainder.  [RAM is nearly used up @ 16GB]
I need to free this space. However when I checked the paging file settings they are a bit screwy.
C:\ has a custom size of 1024-1024
And E:\ has a custom size of 18000- 18000
I have never seen two separate paging files on two separate drives.
Also Perf mon shows that pagefile % Usage is 0 for both C:\ and E:\.
Also I was always taught that the paging file should be 1.5 times the total memory. In this case 27648 MB.

Can I just set a custom paging file of 27648 27648 on E:\ without any adverse effects on SQL 2008?
And is that all there is to it?
0
Comment
Question by:it_medcomp
  • 3
  • 3
  • 2
  • +1
9 Comments
 
LVL 22

Expert Comment

by:chakko
ID: 37823596
You can have a paging file on different drives, and also you can have multiple pagefiles on multiple drives.

You can adjust the pagefile size for drive E if you like.   the 1.5 x RAM is a recommended setting, but you can have a different value for it.

I would looks at the C:\pagefile.sys file and check the size of it.  It should be about 1GB in size.  If it is larger then sounds like the server needs a restart to reset the pagefile to the correct size.

Changing the pagefile setting (making it larger) will not have any adverse effect for SQL as long as your E: drive has sufficient space
0
 
LVL 17

Expert Comment

by:Anuroopsundd
ID: 37823599
that is fine to have 2 page files to save space on c drive.

you can reduce the page file on c drive to 256-256 (mb)  also to make more 750 MB of space.

please download and install filetree and check what application or files are taking space...

http://www.jam-software.com/freeware/
0
 
LVL 59

Expert Comment

by:Darius Ghassem
ID: 37823627
Download Windirstat see what is eating up the space http://windirstat.info/
0
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
LVL 1

Author Comment

by:it_medcomp
ID: 37823845
ok so i checked both paging files and they are correct.
C:\ is only a 1024
and E:\ is 18,000

but what else could be taking up the rest of the volume?

I installed Windirstat and it reports that only 45gb is used [confirming my own findings]

but windows reports the drive is almost full. 66.55 of 68.3 total...
0
 
LVL 17

Expert Comment

by:Anuroopsundd
ID: 37823858
can you check with filtree what folder is taking space.

http://www.jam-software.com/freeware/
0
 
LVL 59

Expert Comment

by:Darius Ghassem
ID: 37823886
Empty the recycling bin. Check the recycling bin properties to see how much space is taking up.

Winstat will show you the folder as well
0
 
LVL 1

Accepted Solution

by:
it_medcomp earned 0 total points
ID: 37828208
Answered my own question.
It was volume shadow copies.

Set size limits.
Problem solved!
0
 
LVL 59

Expert Comment

by:Darius Ghassem
ID: 37828258
How did you find this information out? With one of the tools we posted?
0
 
LVL 1

Author Closing Comment

by:it_medcomp
ID: 37847982
A ridiculous amount of volume shadow copies used up the disk space. Nobody gave the suggestion to check it.
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

Normally after a failure of Domain Controller, when promoting new DC the DC is renamed, we will discuss the options in Dcpromo to re-create the DC with the same name. Scenario: You are a small IT shop with two Domain Controllers (Domain Contr…
I was asked if I could set up a fax machine so that incoming faxes were delivered to people's Exchange inboxes and so that they could send faxes from their desktops without needing to print the document first.  I knew it was possible but I had no id…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…
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 …

697 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