Pagefule.sys is getting too large on 1 drive. What are my options?

I have a database server that is used a lot through each day.  This server was originally setup by the vendor of the database program.  This server has 1 pagefile.sys on the C: Drive and a different page file.sys on the D: Drive.  The problem is that I am running out of space on the D: Drive.

screen2
screen1
I did free up around 5 GB on the D: Drive this moirning; but, as you can see it there is more than enough room on teh C: Drive.  I wonder if there is a way to just have 1 pagefile.sys for the C: Drive?  Or what else are my other options?

Before today, tehre was 17 GB of free space on teh D: Driove this morning there was 55 MB.
LVL 1
PkafkasNetwork EngineerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

JohnBusiness Consultant (Owner)Commented:
Set the Page File to System Managed Size and that will reduce it.
You may wish to check with the DB Vendor to ensure they agree with your action.
Tom CieslikIT EngineerCommented:
It's always depend from how much memory you have and If you're using SSD drive as a system drive.
If You have 16GB memory, swap file shouldn't be bigger that this so you can set this manually or like John said, let system decide.
If you have SSD drive you can disable Swam file because SDD speed is almost the same as memory speed.
Lee W, MVPTechnology and Business Process AdvisorCommented:
Add more RAM.  Pagefiles are SLOW - they take the place of RAM when you don't have enough.  While you CAN lower the pagefile amount (you can even control the amount of RAM SQL uses) and put another pagefile on the E: drive (or another physical disk), Adding RAM will likely improve performance.
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.

Lee W, MVPTechnology and Business Process AdvisorCommented:
Actually, you should probably look at how the disks are allocated?  Is this a VM?  One (set) of drives that's partitioned?  Putting the pagefile on a separate spindle can also improve performance.
Tom CieslikIT EngineerCommented:
Lee W,MVP
SQL should not use swap file in that amount, no matter how much physical memory server is using.

My SQL is using over 30GB physical memory but swap file is only 7GB. (3GB cash for SQL)
We don't know how much memory he has and what program is using  swap file so it's hard to say.

Capture.JPG
arnoldCommented:
You have almost 60GB allocated for pagefile
Depending on your OS, adding physical memory would improve the performance and reduce the need for such a large page file. AS lee and pointed out and John referenced

DB is an IO intensive process and positioning a page file on the same disk potentially D: is the data ..

What is the underlying OS on this system?
How big is the DB, look at the network settings, prioritizing the system for application. look at advanced settings, choose the option for performance, under advanced, performance settings, make sure the system is set for application/programs and not background .......

The reprioritization could minimize the number of times the system shifts DB server/db data out of memory and into the pagefile/disk before it handles another process/application....
PkafkasNetwork EngineerAuthor Commented:
I have 32 GB of RAM on this SQL Server.  it is. virtual server.
PkafkasNetwork EngineerAuthor Commented:
this virtual server has a Windows 2008 R2 operating system.
PkafkasNetwork EngineerAuthor Commented:
i can easily add a lot more RAM.  But i cannot add a lot of hard drive space.
JohnBusiness Consultant (Owner)Commented:
You can easily let the Server manage the page file size and that will reduce it. Try that as all should still work fine after that
PkafkasNetwork EngineerAuthor Commented:
if i let tge system manage tge page file, will that take away the page fime from the D:drive?
JohnBusiness Consultant (Owner)Commented:
Yes it should because Windows will manage it to a smaller size
arnoldCommented:
Page anagement IMHO shoukd not be left to the OS to manage.
Without analyzing the issue, page size can be larger.
Fixing the amount not sure why you chose to allocate 24 and 35 Gb of page file in the first place.
Your minimum page file size is large.

Once ram is added, the system should require less paging.
Identifying why your settings are so large

Usually, the settings provide a recomendation of what Windows page file shoukd be...., in your usage/case Windows recommends 50GB

Identifying the reason, and possibly adjusting ....

Look at resource manager dealing with how often data is being swapped. IMHO, increasing amount of ram shoukd reduce the demands on page file.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Tom CieslikIT EngineerCommented:
Or just assign permanent amount of disk space for Swap file, then you'll sure that windows will not increase it.
JohnBusiness Consultant (Owner)Commented:
Yes, and in addition, my experience on a well-running system is that System Managed is optimal and very likely smaller in the above situation.
Lee W, MVPTechnology and Business Process AdvisorCommented:
I agree with Tom and Arnold.  Set a static pagefile size.  System managed has a greater chance of fragmenting the pagefile causing additional performance issues.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows OS

From novice to tech pro — start learning today.