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.
Open AWE switch
sp_configure 'show advanced options...
yonny.yoning.com1 min read