asked
Is plan cache included in Buffer Pool?
Hello community, I’m facing with a question that drives me crazy: I try to figure out if plan cache (like other memory areas) are included in buffer pool. I consider the output of **sys.dm_os_memory_clerks**, where MEMORYCLERK_SQLBUFFERPOOL, MEMORYCLERK_SQLCONNECTIONPOOL, CACHESTORE_SQLCP seem to be distinct memory areas. From that I understand that plan cache (CACHESTORE_SQLCP + CACHESTORE_OBJCP + CACHESTORE_PHDR + CACHESTORE_XPROC) is not included in MEMORYCLERK_SQLBUFFERPOOL because they are different clerk types. Moreover, I run DBCC FREEPROCCACHE, and I noticed that MEMORYCLERK_SQLBUFFERPOOL clerk memory is not changed at all, while the above mentioned CACHESTORE_SQLCP,CACHESTORE_OBJCP,CACHESTORE_PHDR, CACHESTORE_XPROC become ZERO. So, I suppose that plan cache is not include, but I read that some authors say the opposite. Which is the correct answer? Thanks a lot Ale
What version of SQL Server are you running / asking about? A couple of articles that may help, or at least give a starting point:
https://blogs.msdn.microsoft.com/sqlosteam/2012/07/12/memory-manager-configuration-changes-in-sql-server-2012/
https://blogs.msdn.microsoft.com/sqlosteam/2012/07/11/memory-manager-surface-area-changes-in-sql-server-2012/
I am talking about SQL 2012, but it not important. It seems that plan cache is included in Buffer Pool, but Why there is a specific clerk named MEMORYCLERK_SQLBUFFERPOOL that suggests that every other clerk is NOT buffer pool? The root cause of this doubt is such clerk, that is related only to a part of the memory
18 People are following this question.
