paging file using up c: ? server 2008 r2

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?
LVL 1
it_medcompAsked:
Who is Participating?
 
it_medcompAuthor Commented:
Answered my own question.
It was volume shadow copies.

Set size limits.
Problem solved!
0
 
chakkoCommented:
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
 
AnuroopsunddCommented:
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
Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

 
Darius GhassemCommented:
Download Windirstat see what is eating up the space http://windirstat.info/
0
 
it_medcompAuthor Commented:
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
 
AnuroopsunddCommented:
can you check with filtree what folder is taking space.

http://www.jam-software.com/freeware/
0
 
Darius GhassemCommented:
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
 
Darius GhassemCommented:
How did you find this information out? With one of the tools we posted?
0
 
it_medcompAuthor Commented:
A ridiculous amount of volume shadow copies used up the disk space. Nobody gave the suggestion to check it.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.