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
Solved

Pagefile.sys consuming much of C: drive ?

Posted on 2016-07-19
9
123 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 93

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 93

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
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 
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
 
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 93

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 80

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

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.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

809 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