InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 11:07:08 GMT20http://www.sqlservercentral.com/Forums/Topic911587-360-1.aspxThe buffer pool is basically all remaining memory. You can't really manage it at all beyond setting the min & max values. Other than that, you manage how data is accessed, how the procedure cache is used, etc. Is there something specific you're looking for in this area or just general guidelines?Wed, 28 Apr 2010 06:26:12 GMTGrant Fritcheyhttp://www.sqlservercentral.com/Forums/Topic911587-360-1.aspxWhen SQL-Server request a data page it checks the in-memory buffer cache before looking for the data page on the disk subsystem. If the data page is found in the buffer pool, the processor will retrieve the data and then perform the work required. My question is what are some of the key factors I should take into account to ensure I am setting the size of the buffer pool? Ideal ways for buffer pool management?Tue, 27 Apr 2010 20:15:03 GMTJStevenson1