Thank you for your update Grant, appreciate the quick response.

Im probably misunderstanding something here but ;

Can I just add that 'Optimize for ad hoc Workload' is set to true.

I am...

Apologies but accidentally submitted before i got finished;

to reiterate when comparing the output of;

SELECT objtype AS [CacheType]

, count_big(*) AS [Total Plans]

...