Are you sure that is correct? There value I am talking about is the value listed on the 'Runtime Configuration' page of the model settings in the designer, as shown in this picture:
It is documented on this page:
and the documentation for the 'Compiled Query Cache' option says the following;
Compiled Query Cache
- specifies whether to cache compiled queries.
The settings you are talking about are in the 2nd Level Cache settings dialog box, which controls where query results are cached, and how many of them are cached.
So I am pretty sure I am right in that the setting I am talking about controls how the compiled query cache is configured, and by default is set to a value of 0. I have assumed 0 means the cache is turned off, and that setting it to a non-zero value will enable it and allocate that many slots for the compiled query cache. All I really need to know now is what is considered a good value for this?