Solved

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

Posted on 2007-12-03
3
355 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
  • 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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Learn about cloud computing and its benefits for small business owners.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

760 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