Solved

Pagefile.sys consuming much of C: drive ?

Posted on 2016-07-19
9
107 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
  • 3
  • 2
  • 2
  • +2
9 Comments
 
LVL 92

Expert Comment

by:John Hurst
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 7

Author Comment

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

Expert Comment

by:John Hurst
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
 
LVL 4

Assisted Solution

by:Dash Amr
Dash Amr earned 170 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
Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

 
LVL 7

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 170 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 92

Assisted Solution

by:John Hurst
John Hurst earned 110 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 95

Assisted Solution

by:Lee W, MVP
Lee W, MVP earned 110 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 78

Assisted Solution

by:David Johnson, CD, MVP
David Johnson, CD, MVP earned 110 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

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?
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

919 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now