Purpose

The purpose of this article is to teach you the process of setting up a fixed amount of memory in Microsoft SQL Server 2000.

To Set a Fixed Amount of Memory

SQL Server can be configured to use a fixed amount of memory used based on demand. The minimum amount of memory you can specify for max server memory is 16 MB.

Following steps describe you the process of setting up a fixed amount of memory:

1. Click Start, go to Programs, then go to Microsoft SQL Server, and then click Enterprise Manager.

2. Right click on the registered SQL Server i.e. PC54, then click the Memory tab.

3. Now, select the Use a fixed memory size (MB), and set a value from 16 MB to 511 MB.

4. Click OK.