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; then click Properties.
3. Click the Memory tab.
4. In the Memory box, select 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.