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

SQLServer 2012 always on cache plan cleared quickly Expand / Collapse
Author
Message
Posted Monday, January 27, 2014 8:34 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Yesterday @ 2:39 AM
Points: 7, Visits: 77
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
[url=http://msdn.microsoft.com/en-us/library/dn148262.aspx][/url]

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








Post #1535282
Posted Tuesday, January 28, 2014 12:33 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: Today @ 11:52 AM
Points: 41,530, Visits: 34,446
Not following, could you explain more what the problem is?


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 #1535321
Posted Wednesday, February 19, 2014 2:30 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Yesterday @ 2:39 AM
Points: 7, Visits: 77
solution :
it may caused by memory leak .
after patching CU8 , it seems fixed .
Post #1542896
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse