Queries and connections that cannot get the memory they need.
701
There is insufficient system memory in resource pool to run this queryA query could not get memory in the named resource pool; the cause is usually elsewhere on the instance.
802
There is insufficient memory available in the buffer poolThe buffer pool is full and cannot grow; find what fills it before changing memory settings.
8645
A timeout occurred while waiting for memory resources to execute the queryA query timed out waiting in the memory grant queue; tune the queries holding large grants.
8651
The requested memory grant was not available in resource poolA query could not get its memory grant in the named pool; check grants, pool limits and memory pressure.
17803
There was a memory allocation failure during connection establishmentA new connection was closed because the server could not allocate memory for it; the instance as a whole is short of memory.
17890
A significant part of SQL Server process memory has been paged outInformational: Windows paged out over half of SQL Server committed memory, so performance drops; find the competing memory demand.
No errors in this category match your search. Search the whole library.
Other categories
- Constraint & Integrity 5
- Logins & Permissions 19
- Connectivity 9
- Syntax & Object Resolution 22
- Data Type & Conversion 15
- Concurrency & Locking 2
- Transactions 5
- Log & Storage Space 3
- Backup & Restore 15
- Database State & Recovery 13
- Corruption & Consistency 8
- Query Processing & Performance 7
- High Availability 8
- SQL Server Agent 4
- Linked Servers 7