How to set minimum query memory (Enterprise Manager)

How to Install SQL Server 2000

How To

How to set minimum query memory (Enterprise Manager)

To set minimum query memory

  1. Expand a server group.

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

  3. Click the Memory tab.

  4. In the Minimum query memory box, type or select a value from 512 through 2147483647 kilobytes (KB).

    The default value is 1024 KB.