Memory Limit Exceeded — Dont understand the figures quoted properly! Uploaded the plan again as it wouldnt open!
The select statement has a red cross. Reason For Early Termination:Memory Limit Exceeded. So when I lookat the other figures iver the SELECT part, the memory grant says 222,376 KB, Desired Memory 222,376 KB, Granted Memory 222,376 KB Max memory used 44,672, Requested memory 222,376 Where from those figures do I conclude that the memory limit has been Exceeded ? I'm reading this as sql server has requested 222,376 kb for the query and has been granted the 222,376 KB but used 44,672 KB – So why has the memory limit been exceeded ?