InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 15:51:14 GMT20http://www.sqlservercentral.com/Forums/Topic1409359-391-1.aspx[quote][b]SQL* (1/20/2013)[/b][hr]hi all,Where the Buffer pool will be allocated?[/quote] In RAM, by SQLOS.[quote]Is Buffer pool is different from Cache, if yes where this will be stored.[/quote]The buffer pool contains various caches.[quote]Is buffer pool allocated in RAM?[/quote]Yes.Buy the book [u][url=http://www.amazon.com/Microsoft%C2%AE-SQL-Server%C2%AE-2008-Internals/dp/0735626243]Microsoft SQL Server 2008 Internals by Kalen Dalaney[/url][/u] if you want to know more.Sat, 26 Jan 2013 07:53:29 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1409359-391-1.aspx[quote][b]Akkare (1/21/2013)[/b][hr]BufferPool[/quote]Pages of data stored in memory. Governed by 'max server memory' setting.[quote]VASMemtoleave[/quote]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.[u][url=http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/07/07/understanding-the-vas-reservation-aka-memtoleave-in-sql-server.aspx]Understanding the VAS Reservation (aka MemToLeave) in SQL Server by Jonathan Kehayias[/url][/u]Sat, 26 Jan 2013 07:48:28 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1409359-391-1.aspx[quote][b]Akkare (1/21/2013)[/b][hr]Can somebody differentiateBufferPoolVASMemtoleave[/quote] for buffer pool you can refer above link but for other google them , you will find a lots of article or linksMon, 21 Jan 2013 03:09:12 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1409359-391-1.aspxCan somebody differentiateBufferPoolVASMemtoleaveMon, 21 Jan 2013 02:46:54 GMTAkkarehttp://www.sqlservercentral.com/Forums/Topic1409359-391-1.aspxthis is the topis where aggressisevly , somebody can spend days , months or might be years but for start follow below links :-D[url]http://msdn.microsoft.com/en-us/library/aa337525(v=sql.105).aspx[/url] [url]http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/1b2ae966-1a9d-463b-9e05-3bbd99791d95[/url][url]http://support.microsoft.com/kb/321363/en-us[/url][url]http://support.microsoft.com/kb/319942/EN-US/#appliesto[/url][url]http://support.microsoft.com/kb/316749/[/url]Mon, 21 Jan 2013 01:20:40 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1409359-391-1.aspxhi 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?Sun, 20 Jan 2013 22:49:54 GMTSQL*