Memory in management console in Activity -> Query Montioring
I am monioring queries using MC in Activity -> Query Montioring.
I am confused when i look at Memory (MB) column of it.
It shows much more than what i can seee in the system tables like RESOURCE_ACQUISITIONS (MEMORY_INUSE_KB).
Is there any diffrence in both of them?
Can somebody clear the picture for me?
What is the correct way/system table/query to get the memory acquired by a query and memory used by a quey?