Archives for June, 2012

Memory Grant Mystery

“Add more memory” was in the early days of SQL server often the solution to all problems, and for some people, it still is. But even if you think there is a memory bottleneck, adding more RAM isn’t always solving the issue. When inspecting the sys.dm_exec_query_memory_grants view, we noticed one session was queued because SQL […]