ganci.mark (1/31/2012)

---

Great article David. Thank you.

I thought that there were limits imposed on the various memory components based on on the total amount of memory given to SQL Server.

For example: Proc Cache limits

SQL Server 2005 SP2

75% of server memory from 0-4GB +

10% of server memory from 4Gb-64GB +

5% of server memory > 64GB

So 14GB given to a SQL SERVER 2005 SP2 would yield a 4GB Proc Cache.

Is it correct in stating that the limits do not exist and proc cache for example can consume additional memory?

Thanks

Mark