Recently, i am going through the memory concepts of sql server 2008 and i need some clarifications from expericenced folks to get better clarity on below terms and objects.
What is Memory object and memory node and where does the memory clerks and single allocators and Multi page allocators fit in Memory Allocations.
Basically, How does sql server allocates memory for a request and also interested to know who all are the memory consumers? is the ones which are present in sys.dm_os_memory_clerks(bpool,sqlutilities.. ) are the memory consumers
or else is there anything like external memory consumers. Need clarifications on this.
Any brief descriptions with example would be a great help. Looking forward for your valuable comments.
Thanks in advance.