A
A
Andrey Gubsky2013-05-11 14:39:38
SQL
Andrey Gubsky, 2013-05-11 14:39:38

The query had to wait X seconds for MemoryGrant during execution and slow query execution in SQL Server Web Edition 2012?

Good afternoon!
I ran into the following problem: the query began to run for a very long time, while the query plan on the SELECT block displays an exclamation point and the message: "The query had to wait 25 seconds for MemoryGrant during execution" .
The query itself is relatively simple, there are indexes on the fields.
I haven't been able to figure out what the problem could be yet, I haven't had similar situations before.
I will be grateful for help.
Snapshot of the parameters of the problematic area of ​​the requestec72eea54dd61d29233b8c31ef8af361.png

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question