Purpose

The purpose of this article is to teach you the process of setting minimum query memory in Microsoft SQL Server 2000.

To Set Minimum Query Memory

Minimum memory per query option is used to specify the minimum amount of memory (in kilobytes) that will be allocated for the execution of a query. You can set min memory per query to any value from 512 through 2,147,483,647 KB (2 GB). The default value for minimum query memory is 1,024 KB.

Following steps describe you the step by step details of setting up the minimum query memory:

1. Click Start, then go to Programs, then go to Microsoft SQL Server, and click Enterprise Manager. 

2. Right click the registered SQL Server i.e. PC54, then click Properties, now click the Memory tab.

3. Now, in choose or type a value for memory against Minimum query memory (KB) from 512 KB to 2 GB.

4. Click OK.