We have a sql server 2008 R2 on physical server with RAM-- 512 gb.
we have around 300 gb of data in disk, the sql server memory has been set to 485gb.
sql server is using around 300gb of the memory.
the question here is, the plan cache hit ratio is only 65%.
can u please help me resolve this and increase the plan cache hit ratio to 100%
we are doing around 7000 batches/sec
we have enabled optimize for ad-hoc workloads to true and forced parameterization.
thanks for the help,