How to set a fixed amount of memory (Enterprise Manager)

How to Install SQL Server 2000

How To

How to set a fixed amount of memory (Enterprise Manager)

To set a fixed amount of memory

  1. Expand a server group.

  2. Right-click a server, and then click Properties.

  3. Click the Memory tab.

  4. Click Use a fixed memory size (MB), and then position the fixed memory slider.

Note  If you use the default settings, Microsoft® SQL Server™ configures memory dynamically.