Don't know if I can add on this thread. let me know for future reference. Anyway just have a question:
my 'Prepared' size is more than 'adHoc'. should I run dbcc freesystemcache ('sql plans') to minimize size of the 'Prepared' plan Cache Object? Is 'Prepared' as bad as 'adHoc'?