January 27, 2014 at 8:34 pm
hi all:
we set up 2012 always on in our production . now there is a strange question :
the cache plan cleared quickly in Memory(Include SQL Cache(Ad hoc…), Object Cache(SP, UDF, FUNC…), etc. ) , our RAM is 128GB, according below article ,the max plan cache should have 12.2GB
75% of visible target memory from 0-4GB + 10% of visible target memory from 4Gb-64GB + 5% of visible target memory > 64GB
It should not happen if only several SPs get recompiled. It seems most of SPs are affected.
I tried to trace DBCC FREEPROCCACHE, but got nothing. It looks triggered by some mechanism inside.
You know, it happens generally when there is a memory pressure. But we can’t see any memory pressure.
Currently, we install SQL Server SP1 CU5. The fix package above is in CU7, but NOT in CU5.
Anyone have good suggestions ? thanks 🙂
January 28, 2014 at 12:33 am
Not following, could you explain more what the problem is?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 19, 2014 at 2:30 am
solution :
it may caused by memory leak .
after patching CU8 , it seems fixed .
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply