2

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?

asked May 27, 2013 at 19:45

1 Answer 1

4

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.

Glorfindel
2,2095 gold badges19 silver badges26 bronze badges
answered May 27, 2013 at 20:06
3
  • 1
    Remus, my question should be does max server memory now controls memory for backup buffer?... Historically this was coming out of memtoleave (or virtual address space)....If I read late great Ken Henderson's book "SQL Server Practical TroubleShooting" it was mentioned but again that book was SQL 2005 era. Commented May 27, 2013 at 21:00
  • afaik max server memory does not account for backup buffers. Commented May 28, 2013 at 6:05
  • ... even in 2008 (if I'm reading this correctly) the buffers for backup operations did not come from the buffer pool. Commented Mar 19, 2014 at 3:37

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.