Question : Issue: I have few queries which is requesting huge memory grants(~7GB).These queries are run often and this is […]
Tag: memory-grant
Huge Memory Grant resulting in RESOURCE SEMAPHORE waits for other queries
Question : Issue: I have few queries which is requesting huge memory grants(~7GB).These queries are run often and this is […]
Why does CCI creation on an empty table request a huge memory grant?
Question : On a QA server with very low memory, I experienced error 8545 when creating clustered columnstore indexes on […]
Why does estimated memory have a three phase shape?
Question : The graph for this other question is for a 1 million row table. When drawn for 10,000 rows […]
Execution plan doesn’t show memory grant
Question : I installed SQL Server 2019 on a VM on Azure (DS11). I am trying to illustrate adaptive query […]
Does the query still run even when SQL Server can’t grant the requested memory for the query?
Question : I was thinking about something like this today but I couldn’t find this piece of information. When the […]
Large memory grant for joined tables
Question : When I select columns from both joined tables a get a huge memory grant (529808). If I query […]
Excessive memory grants from indexed foreign key cascade delete
Question : Each day, stores can enter sales information into our OLTP application. The app calls a stored procedure in […]
Huge Memory Grant resulting in RESOURCE SEMAPHORE waits for other queries
Question : Issue: I have few queries which is requesting huge memory grants(~7GB).These queries are run often and this is […]
Memory Grant Warning on what appears to be a better query?
Question : OK, I was looking at potentially reducing this (as more of an exercise than a need mind you) […]
- 1
- 2