SQLblog.com - The SQL Server blog spot on the web
Memory Allocated To Plan Caching
I could complain about Entity Framework, but there is probably nothing that has not already been aired. So instead, I will complain about the lack of tuning options in SQL Server's Memory Allocated To Plan Caching. As of SQL Server versions 2005 SP2 and 2008, the formula is 75% from the first 0-4GB, 10% from 4-64GB and 5% of the remaining over 64GB, all referring to visible target memory. There was a different formula in version 2005 RTM and SP1 that allowed even more memory for the plan cache. Does...(read more)
No comments:
Post a Comment