SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 memory sqlserver 2008 clarifications
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

frank.svs
Constraint Violating Yak Guru

368 Posts

Posted - 01/11/2013 :  01:00:47  Show Profile  Reply with Quote
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 - 01/15/2013 :  13:14:49  Show Profile  Reply with Quote
Hello:

Please refer this link. will help.

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

Thanks
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.14 seconds. Powered By: Snitz Forums 2000