Buffer pool

Question

Buffer pool

SQL*

SSCertifiable

Points: 6638
More actions
January 20, 2013 at 10:49 pm

#273056

hi all,
Where the Buffer pool will be allocated? Is Buffer pool is different from Cache, if yes where this will be stored.
Is buffer pool allocated in RAM?
🙂

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 1

this is the topis where aggressisevly , somebody can spend days , months or might be years but for start follow below links 😀

http://msdn.microsoft.com/en-us/library/aa337525(v=sql.105).aspx

http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/1b2ae966-1a9d-463b-9e05-3bbd99791d95

http://support.microsoft.com/kb/321363/en-us

http://support.microsoft.com/kb/319942/EN-US/#appliesto

http://support.microsoft.com/kb/316749/

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

Akkare SSCrazy Points: 2848 More actions · Answer 2

Can somebody differentiate

BufferPool

VAS

Memtoleave

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 3

Akkare (1/21/2013)
Can somebody differentiate
BufferPool
VAS
Memtoleave

for buffer pool you can refer above link but for other google them , you will find a lots of article or links

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

Orlando Colamatteo SSC Guru Points: 182279 More actions · Answer 4

Akkare (1/21/2013)
BufferPool

Pages of data stored in memory. Governed by 'max server memory' setting.

VAS
Memtoleave

Two names for the same thing. Describes bon-buffer-pool memory, i.e. amount is not governed by 'max server memory' setting. Think of this as memory SQL Server needs to support things like CLR objects and Linked Server requests.

Understanding the VAS Reservation (aka MemToLeave) in SQL Server by Jonathan Kehayias

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

Orlando Colamatteo SSC Guru Points: 182279 More actions · Answer 5

SQL* (1/20/2013)
hi all,
Where the Buffer pool will be allocated?

In RAM, by SQLOS.

Is Buffer pool is different from Cache, if yes where this will be stored.

The buffer pool contains various caches.

Is buffer pool allocated in RAM?

Yes.

Buy the book Microsoft SQL Server 2008 Internals by Kalen Dalaney if you want to know more.

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato