Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Server 2008 R2 Pagefile.sys Grows and Fills up Disk

Posted on 2013-06-13
7
Medium Priority
?
1,033 Views
Last Modified: 2013-06-24
Hello Folks,

I am running an instance of Server 2008 R2 on a VMware ESXI host. I have 12GB of RAM allocated to it and the OS has SQL Server 2008 R2 & Sybase installed.

The problem is that since yesterday, the page file has suddently grown to complete fill the disk up and is currently amost 39GB in size. When I reboot the server it shrinks by well over half but then fills up again in a matter if hours. It is set to let windows manage the size by default. What might be going on here?
0
Comment
Question by:JohnnyD74
7 Comments
 
LVL 7

Expert Comment

by:ingetic
ID: 39244872
Sybase seems to eat memory....

Try to fix the size to 18 Gb , and sybase might release memory when pagefile will be full ?
0
 

Author Comment

by:JohnnyD74
ID: 39244882
Thanks...I though about that....but was curious to find out why windows would suddenly start running up such a huge pagefile. Anyone know why?
0
 
LVL 22

Expert Comment

by:Haresh Nikumbh
ID: 39244890
best practice would say to size your page file at 1 1/2 times the amount of configured RAM.  With that said, we let Windows manage our page file.  As stated, if your going to the page file, you may not have enough RAM assigned.  If this is a VM, it's easy to increase the RAM as well as extend out the C: drive.  You'll need to reboot for the RAM assignment, but not the increase of the C: drive

Source:

http://communities.vmware.com/thread/395259?start=0&tstart=0
0
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

 

Author Comment

by:JohnnyD74
ID: 39244897
We have 12 GB of ram assigned and windows is only using 4 according to task manager....I don't think this is the issue.
0
 
LVL 24

Expert Comment

by:Nagendra Pratap Singh
ID: 39246588
You can limit the max memory used in SQL Mgt Studio.

That said, I am not sure if this can be done for sybase.

Also if you are running two DB servers of even the moderate size then 12 GB is a bit less.
0
 

Accepted Solution

by:
JohnnyD74 earned 0 total points
ID: 39260407
Thanks for all the help, folks. I found that the problem was another program with a memory leak.
0
 

Author Closing Comment

by:JohnnyD74
ID: 39270696
Found my own solution
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

After seeing many questions for JRNL_WRAP_ERROR for replication failure, I thought it would be useful to write this article.
Resolving an irritating Remote Desktop connection that stops your saved credentials from being used.
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…
Suggested Courses

963 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