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

VAS/MemToLeave and the Plan Cache Expand / Collapse
Author
Message
Posted Wednesday, July 17, 2013 6:41 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 7:10 AM
Points: 1,055, Visits: 711
Hello,

Could someone let me know if the plan cache is located within MemToLeave or is separate?

I know that MemToLeave is reserved before the buffer pool when SQL starts up, but what about the plan cache?

Thanks in advance,

Andrew
Post #1474557
Posted Wednesday, July 17, 2013 6:51 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 11:47 AM
Points: 41,525, Visits: 34,442
The plan cache, as well as all the other caches are part of the buffer pool.

The pre-allocate of MemToLeave is only on 32-bit SQL and the memory management has changed significantly in 2012 anyway



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1474569
Posted Wednesday, July 17, 2013 6:56 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 7:10 AM
Points: 1,055, Visits: 711
Thank you Gail
Post #1474576
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse