- 138,787 hits
- January 2016 (1)
- July 2015 (2)
- June 2015 (3)
- September 2013 (2)
- October 2012 (4)
- September 2012 (1)
- June 2012 (2)
- May 2012 (2)
- April 2012 (2)
- March 2012 (16)
- February 2012 (15)
Join 222 other subscribers
.Net 1118 15581 @schema_option @stream_blob_columns allocations AUTO Buffer Pool Catalog Change Data Capture COLLECTION ColumnStore Index create subscription report server Data Alerts Date types disk free space Dymanic Email enhancement excel EXPLICIT File information FILESTREAM FOR XML Indirect Checkpoint SQL Server 2012 Master Key Memory memory Clerk MemoryStatus Merge Merge Replication modified MTL multiple NESTED OPENXML PATH permissions Programming Proxy Class RAW Render rendering Report Reporting Services Reporting Service Web Service Reference report Items reports Report Server roles SCHEMA Server Audit Singleton sp_addmergearticle SQL Server SQL Server 2000 SQL Server 2005 SQL Server 2008 SQL Server 2012 SQL Server XML sys.sp_cdc_enable_db sys.sp_cdc_enable_table TDE TempDB Trace Flag Traget_Recovery_Time tree view Web Service What New word WSDL XML XML. SQL Server XML Indexes XQuery
As i aware there are two components in SQL Server with respective to SQL Memory Management.
Question : In 64 Bit Machine how BPool and MTL Allocation being calculated by the server.
Yes there are two components in SQL(BPool and Non-BPool). The allocations are calculated in the same way as 32 bit system (with some minor changes) but the overall allocation algorithm remains similar.
1) Allocated Non-BPool Memory as Reserved (256 + Thread Stack(128))
2) Allocated BPool Memory Max BPool = Min(Min(Max Server Memory, RAM), (VAS – Non Bpool – MemoryforDLL_EXE – M_pbuf))
3) Remove the Reserved flag from the Non Bpool memory allocated in Step 1 and mark it free.
4) Any remaining VAS area is also marked as Free memory (used as non BPool memory).