Details | |
Product: | SQL Server |
Event ID: | 701 |
Source: | MSSQLServer |
Version: | 10.0 |
Component: | SQLEngine |
Symbolic Name: | NOSYSMEM |
Message: | There is insufficient system memory in resource pool ‘%ls’ to run this query. |
Explanation | |
SQL Server has failed to allocate sufficient memory to run the query. This can be caused by a variety of reasons including operating system settings, physical memory availability, or memory limits on the current workload. In most cases, the transaction that failed is not the cause of this error. Diagnostic queries, such as DBCC statements, may fail because server the does not have sufficient memory. |
|
User Action | |
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. |