Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Buffer pool Expand / Collapse
Author
Message
Posted Sunday, January 20, 2013 10:49 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Sunday, August 17, 2014 11:59 PM
Points: 415, Visits: 1,584
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?


Post #1409359
Posted Monday, January 21, 2013 1:20 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 12:26 AM
Points: 2,840, Visits: 3,963
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
Post #1409395
Posted Monday, January 21, 2013 2:46 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 1:08 AM
Points: 102, Visits: 416
Can somebody differentiate

BufferPool
VAS
Memtoleave

Post #1409441
Posted Monday, January 21, 2013 3:09 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 12:26 AM
Points: 2,840, Visits: 3,963
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
Post #1409453
Posted Saturday, January 26, 2013 7:48 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:08 PM
Points: 7,097, Visits: 12,599
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
Post #1412030
Posted Saturday, January 26, 2013 7:53 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:08 PM
Points: 7,097, Visits: 12,599
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
Post #1412033
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse