# Increasing MS-SQL 2000 RAM

The MS-SQL 2000 only using 2G RAM by default. If there is a SQL server with huge RAM, than maybe we could increasing the RAM amount of SQL by open the AWE switch.

Here is the method that open it.

<ol>
<li>Open AWE switch</li>
</ol>

<pre><code>sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
</code></pre>

<ol>
<li>Set minimal &amp; maximal RAM of SQL to 2G &amp; 3.5G</li>
</ol>

<pre><code>sp_configure 'min server memory', 2048
RECONFIGURE
GO
sp_configure 'max server memory', 3584
RECONFIGURE
GO
</code></pre>