Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

paging file using up c: ?   server 2008 r2

Posted on 2012-04-09
9
Medium Priority
?
406 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Question has a verified solution.

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

Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
This article explains how to install and use the NTBackup utility that comes with Windows Server.
This tutorial will give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…

578 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