8645

Product

Name

Event ID

8645

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic

Name

MEMTIMEDOUT_ERR

Message Text

A timeout occurred while waiting for memory resources to execute the query in resource

pool ‘%ls’ (%ld). Rerun the query.

This error is raised if a SQL Server request has waited for a query execution (QE) memory grant

for an extended period of time and memory wasn’t available. Query execution memory is

primarily used for sort operations, hash operations, bulk copy operations, and index creation

and population. A query that performs one of these operations requests a memory grant. If no

memory is available, the query is set to wait on a

RESOURCE_SEMAPHORE

until memory

becomes available.

If the memory isn’t available after waiting for a timeout period dynamically determined by the

query cost as estimated by the query optimizer, then SQL Server terminates the query with

error 8645

The timeout value varies slightly between versions of SQL

Server, but has a max wait timeout value of 24 hours. You can see the timeout value set at the

server level by looking at

in

sys.dm_exec_query_memory_grants.

For a detailed explanation with troubleshooting steps, review

Slow performance or low

memory issues caused by memory grants in SQL Server.

ﾉ

Expand table

A timeout occurred while waiting for memory resources to execute the query in the resource pool 'default'.
timeout_sec