Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

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

Independent Software Vendors: 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

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how the fundamental information of how to create a table.

972 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