Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 memory sqlserver 2008 clarifications

Author  Topic 

frank.svs
Constraint Violating Yak Guru

368 Posts

Posted - 2013-01-11 : 01:00:47
Hi All,

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.

serverdba
Starting Member

4 Posts

Posted - 2013-01-15 : 13:14:49
Hello:

Please refer this link. will help.

http://blogs.msdn.com/b/slavao/

Thanks
Go to Top of Page
   

- Advertisement -