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.

1. Open AWE switch

sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO

1. Set minimal & maximal RAM of SQL to 2G & 3.5G

sp_configure 'min server memory', 2048
RECONFIGURE
GO
sp_configure 'max server memory', 3584
RECONFIGURE
GO