?
Solved

Pagefile.sys consuming much of C: drive ?

Posted on 2016-07-19
9
Medium Priority
?
196 Views
Last Modified: 2016-08-04
People,

I have just finished upgrading my physical server with additional RAM totalling 32 GB now.

C: drive is just running 2x 72 GB RAID-1 hence it is 68 GB formatted as NTFS

Now I'm getting disk space alert on C: drive because the pagefile.sys is now 32 GB !

How can I turn it off or reduce the size to create some more disk space ?
This physical box is running SQL Server 2012 Standard Edition.
0
Comment
[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
  • 2
  • 2
  • +2
9 Comments
 
LVL 97

Expert Comment

by:Experienced Member
ID: 41720025
Click Start, type Advanced System Settings then to the Advanced tab You can change Virtual disk settings here. Try 16 GB to see if that works to help you with space.
1
 
LVL 8

Author Comment

by:Senior IT System Engineer
ID: 41720032
Is there any impact if I reduce it to just say... 4 GB ?
0
 
LVL 97

Expert Comment

by:Experienced Member
ID: 41720033
It depends on what is running. If no memory intensive applications (like Exchange) then you should be fine.

Try 4 GB and see. If you get excessive paging or slow performance, up it to 8 GB and try again.
1
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 4

Assisted Solution

by:Dash Amr
Dash Amr earned 680 total points
ID: 41720044
Hi
as John mentioned before it depends on whats running and This article may provide more information you need:

How to determine the appropriate page file size for 64-bit versions of Windows
http://support.microsoft.com/kb/889654

have a look at the link below as well hope it helps
https://askleo.com/what_is_pagefilesys_and_can_i_move_it/

Cheers
Dash
1
 
LVL 8

Author Comment

by:Senior IT System Engineer
ID: 41720049
It is running SQL Server, so the memory is awlays used 100% when looking at the Task Manager | Performance tab.
0
 
LVL 4

Accepted Solution

by:
Dash Amr earned 680 total points
ID: 41720058
Memory is basically two types the physical random access memory (RAM) and virtual memory. A process has to be first mapped to Virtual memory and then to physical memory. All programs use RAM, but when there isn't enough RAM for the program you're trying to run, Windows temporarily moves information that would normally be stored in RAM to a file on your hard disk called a paging file. The amount of information temporarily stored in a paging file is also referred to as virtual memory. Now error page file is less can have multiple meanings

    You are running some processes which is heavily utilizing memory and since OS cannot find enough RAM for it it has to use Page file as temporary area for storage.

    Since SQL Server is running with Locked pages in memory privilege this memory cannot be paged out to disk and OS cannot directly used this memory by asking SQL Server to release it heavily. So in this case you need to lower max server memory of SQL Server a bit and give more memory to OS so that it can function properly. use how to set optimum value for max server memory to set correct value for max server memory ( http://dba.stackexchange.com/questions/84234/what-is-a-deterministic-method-for-evaluating-a-sensible-buffer-pool-size/84246#84246 )

Problem may be not SQL Server memory or memory allocated by AWE API( Locked pages) problem here is windows page file size is less. You need to act on this. Page file is temporary area which is used to hold temporary data which is swapped in and out of physical memory in order to provide a larger virtual memory set. Page file space is reserved when the pages are initially committed, however the page file locations are not chosen until the page is written to disk.

have a look at the link Below
http://dba.stackexchange.com/questions/84510/os-paging-too-high-in-sql-server
1
 
LVL 97

Assisted Solution

by:Experienced Member
Experienced Member earned 440 total points
ID: 41720059
SQL server will not be happy with a 4 GB page file. Go back to 16 Gb (with your 32 GB of memory) may work.
1
 
LVL 96

Assisted Solution

by:Lee W, MVP
Lee W, MVP earned 440 total points
ID: 41720079
Set it to 2 GB on the C: drive, then set it to 30 GB on another drive.  Ideally one not used by the SQL databases or logs.  But if you must, you must.
0
 
LVL 82

Assisted Solution

by:David Johnson, CD, MVP
David Johnson, CD, MVP earned 440 total points
ID: 41720089
SQL server will use memory set it to use no more than 75% of your available memory - 8GB for the OS
1

Featured Post

Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

Question has a verified solution.

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

I have a large data set and a SSIS package. How can I load this file in multi threading?
For anyone that has accidentally used newSID with Server 2008 R2 (like I did) and hasn't been able to get the server running again because you were unlucky (as I was) and had no backups - I was able to get things working by doing a Registry Hive rec…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Suggested Courses

764 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