Solved

paging file using up c: ?   server 2008 r2

Posted on 2012-04-09
9
390 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
 
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
Is Your AD Toolbox Looking More Like a Toybox?

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.

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

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…
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 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 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…

920 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

12 Experts available now in Live!

Get 1:1 Help Now