Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

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

SQL Server 2000

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.