Answer the question
In order to leave comments, you need to log in
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 request
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question