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.
| 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 |
|
|
|
|
|
memory sqlserver 2008 clarifications