Error 8651

Troubleshooting SQL Server

Troubleshooting

Error 8651

Severity Level 17
Message Text

Could not perform the requested operation because the minimum query memory is not available. Decrease the configured value for the 'min memory per query' server configuration option.

Explanation

SQL Server has computed the amount of memory that this query requires to complete. This amount of required memory is not currently available; the min memory per query option may be too high.

Action

Resubmit the query. If resubmitting the query does not allow the query to run, you can:

  • Add additional memory to the server.

  • Create one or more indexes.

  • Reduce the value of min memory per query.

  • Increase the query wait configuration option if it is a nonzero value.

See Also

Index Tuning Wizard

min memory per query Option

query wait Option

sp_configure