Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question
add comment

1 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.

share|improve this answer
    
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. –  SQL Learner May 27 '13 at 21:00
    
afaik max server memory does not account for backup buffers. –  Remus Rusanu May 28 '13 at 6:05
    
... even in 2008 (if I'm reading this correctly) the buffers for backup operations did not come from the buffer pool. –  zlatan Mar 19 at 3:37
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.