Details | |
Product: | SQL Server |
Event ID: | 8651 |
Source: | MSSQLServer |
Version: | 9.0 |
Component: | SQLEngine |
Symbolic Name: | MEMGRANT_ERR |
Message: | 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 | |
Other processes are consuming server memory (exerting memory pressure in the server). |
|
User Action | |
Either decrease the configured value for the min memory per query’ server configuration option or reduce the query load to the server. The following list outlines general steps that will help in troubleshooting memory errors:
The following actions may make more memory available to SQL Server:
Run the following DBCC commands to free several SQL Server memory caches.
If the problem continues, you will need to investigate further and possibly reduce workload. |