asked on

Server 2008 R2 Pagefile.sys Grows and Fills up Disk

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?

Ludovick Lagrevol

Sybase seems to eat memory....

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

JohnnyD74

ASKER

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?

Haresh Nikumbh

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

JohnnyD74

ASKER

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.

Nagendra Pratap Singh

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.

ASKER CERTIFIED SOLUTION

JohnnyD74

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

JohnnyD74

ASKER

Found my own solution