<div>
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.
</div>


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.

<div>
But why would it not exhaust the physical ram first?
</div>


But why would it not exhaust the physical ram first?

<div>
<div class="content wysiwyg-content">
I have a server running SQL Server 2000 Enterprise Edition with a large database (350GB). &nbsp;The server has 4GB of RAM. &nbsp;I monitor this server with a 3rd party performance monitoring tool. &nbsp;Very often I notice that Windows is paging and there is still free memory (about 1.6GB). &nbsp;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. &nbsp; Can anyone give me reasons why this would be happening?<br />
<br />
Thanks<br />

</div>
</div>


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


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

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Windows Server 2003 was based on Windows XP and was released in four editions: Web, Standard, Enterprise and Datacenter. It also had derivative versions for clusters, storage and Microsoft’s Small Business Server. Important upgrades included integrating Internet Information Services (IIS), improvements to Active Directory (AD) and Group Policy (GP), and the migration to Automated System Recovery (ASR).