Export (0) Print
Expand All
Expand Minimize

How to: Set Minimum Query Memory (SQL Server Management Studio)

Use the min memory per query option to specify the minimum amount of memory (in kilobytes) that will be allocated for the execution of a query. For example, if min memory per query is set to 2,048 kilobytes (KB), the query is guaranteed to get at least that much total memory. You can set min memory per query to any value from 512 through 2,147,483,647 KB (2 gigabytes (GB)). The default is 1,024 KB.

To set minimum query memory

  1. In Object Explorer, right-click a server and select Properties.

  2. Click the Memory node.

  3. In the Minimum memory per query box, enter the minimum amount of memory (in kilobytes) that will be allocated for the execution of a query.

    The default value is 1024 KB per query.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft