How to set minimum query memory (Enterprise Manager)
To set minimum query memory
- Expand a server group.
- Right-click a server; then click Properties.
- Click the Memory tab.
- In the Minimum query memory box, select a value from 512 through 2,147,483 KB.
The default value is 1024 KB.
(c) 1988-98 Microsoft Corporation. All Rights Reserved.