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.