Solved

Windows is paging even though there is plenty of RAM available?

Posted on 2007-12-03
3
363 Views
Last Modified: 2012-06-27
I have a server running SQL Server 2000 Enterprise Edition with a large database (350GB).  The server has 4GB of RAM.  I monitor this server with a 3rd party performance monitoring tool.  Very often I notice that Windows is paging and there is still free memory (about 1.6GB).  I thought that Windows would not start paging until it ran out of Physical Memory, but yet it does so quite consistently when there is still plenty of memory left on the server.   Can anyone give me reasons why this would be happening?

Thanks
0
Comment
Question by:BillPowell
[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
  • 2
3 Comments
 
LVL 7

Expert Comment

by:Rob Siddell
ID: 20399360
unless you go into the system properties of the machine and tell it to disable the page file it will always utilize it no matter how little ram is in use.
0
 
LVL 11

Author Comment

by:BillPowell
ID: 20399440
But why would it not exhaust the physical ram first?
0
 
LVL 7

Accepted Solution

by:
Rob Siddell earned 500 total points
ID: 20411773
When legacy OS's would max out the ram or try to use more than was there it would crash the system so i'm guessing it is a precautionary measure. I believe some applications specifically use paged memory for certain things as i know i've had programs that require it to be enabled. Typically it might store infrequently accessed variables in paged memory to prevent a program from hogging all the resources which would allow their program to run on lower end computers. I hope this sheds some light on your question but let me know if you need to know anything else.
0

Featured Post

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

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

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

626 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