?
Solved

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

Posted on 2007-12-03
3
Medium Priority
?
372 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 2000 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

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
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Suggested Courses

616 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