Sql-server – SQL Server Memory for Backup Buffer

sql serversql-server-2008sql-server-2008-r2sql-server-2012

In SQL Server 2012 memory for backup buffer comes from buffer pool or non buffer pool (VAS)? Is this behavior changed between SQL server 2008 R2 and SQL 2012?

EDIT: Does MAX Server Memory configuration setting now controls memory for backup buffer? Historically, this was coming out of MemToLeave (or Virtual Address Space) outside SQL Server buffer pool?

Best Answer

In SQL Server 2012 nothing comes from buffer pool anymore, except data pages. This is a change from SQL Server 2008R2. See Memory Manager surface area changes in SQL Server 2012. The buffer pool is just another client of the Memory Manager client for allocations, just like any other memory consumer. So the question is basically unasked in SQL Server 2012.