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