?
Solved

paging file using up c: ?   server 2008 r2

Posted on 2012-04-09
9
Medium Priority
?
399 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

 
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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Redirected folders in a windows domain can be quite useful for a number of reasons, one of them being that with redirected application data, you can give users more seamless experience when logging into different workstations.  For example, if a use…
I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…
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…
Suggested Courses

777 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