Viewing 2 posts - 1 through 2 (of 2 total)
Justin Manning SA (11/19/2015)You have a lot of the cache allocated to ad hoc statements?Have you identified these and suggested making them stored proc's at least?
Justin Manning SA (11/19/2015)
Have you identified these and suggested making them stored proc's at least?
Yes. This is some...
November 19, 2015 at 6:47 am
#1840964
OK.
Result is:
select
counter_value = cast(round(t.cntr_value * 8 / 1024.0, 2) as decimal(19, 2))
from
sys.dm_os_performance_counters as t
where
t.object_name = 'SQLServer:Plan Cache' and
t.counter_name = 'Cache Pages' and
...
November 19, 2015 at 5:02 am
#1840939