CLEAN UP ONLY ADHOC SQL CACHE

————————————
–    CLEAN UP ONLY ADHOC SQL CACHE
———————————–

declare @size_in_MBs int
select @size_in_MBs = (select size_in_MBs from
(select
objtype,
count(*)as number_of_plans,
sum(cast(size_in_bytes as bigint))/1024/1024 as size_in_MBs,
avg(usecounts)as avg_use_count
from sys.dm_exec_cached_plans
group by objtype) as AXA1
where objtype = ‘Adhoc’)
select @size_in_MBs

if @size_in_MBs > 200
dbcc freesystemcache (’SQL Plans’)