Solved

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

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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL 2012 AOG and SQL2014 AOG 76 59
Upgrading to SQL Server 2015 Express 2 29
Shared files and folders migration 2 26
SQL Distinct Question 3 13
ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
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…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to shrink a transaction log file down to a reasonable size.

735 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