701

Product Name

Event ID

701

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic Name

NOSYSMEM

Message Text

There’s insufficient system memory to run this query.

Error 701 occurs when SQL Server has failed to allocate sufficient memory to run a query.

Insufficient memory can be caused by a number of factors that include operating system

settings, physical memory availability, other components use memory inside SQL Server, or

memory limits on the current workload. In most cases, the transaction that failed isn’t the cause

of this error. Overall, the causes can be grouped into three:

External pressure refers to high memory utilization coming from a component outside of the

process that leads to insufficient memory for SQL Server. You have to find if other applications

on the system are consuming memory and contribute to low memory availability. SQL Server is

ﾉ

Expand table

７

Note

For information on troubleshooting out of memory

issues in Azure SQL Database, see.