https://community.sap.com/t5/technology-q-a/how-to-query-the-initial-cache-size/qaa-p/13845393#M4876236 <P>As a workaround, one might create a DatabaseStart event that captures CurrentCacheSize when db_id() returns 0, i.e. when the database is the first started on the server. I guess that may not always return the initial cache size because the event is called when the database has been loaded which might have already adjusted the cache size - but it is good enough for my purpose...</P> Fri, 26 Jan 2018 04:20:07 GMT VolkerBarth 2018-01-26T04:20:07Z https://community.sap.com/t5/technology-q-a/how-to-query-the-initial-cache-size/qaq-p/13845391 <P>There are several properties for current, minimum, maximum and peak cache size but how can I query the initial size?</P> <P>(Other than looking at the server's starting console log entries or checking whether option -c was contained in the engine's command line, which is available as property...) </P> Thu, 25 Jan 2018 08:04:23 GMT https://community.sap.com/t5/technology-q-a/how-to-query-the-initial-cache-size/qaq-p/13845391 VolkerBarth 2018-01-25T08:04:23Z https://community.sap.com/t5/technology-q-a/how-to-query-the-initial-cache-size/qaa-p/13845392#M4876235 <P>Hi, Volker. The server does not provide a property to query the initial cache size. It doesn't even keep track of the value after startup.</P> Thu, 25 Jan 2018 08:13:54 GMT https://community.sap.com/t5/technology-q-a/how-to-query-the-initial-cache-size/qaa-p/13845392#M4876235 johnsmirnios 2018-01-25T08:13:54Z https://community.sap.com/t5/technology-q-a/how-to-query-the-initial-cache-size/qaa-p/13845393#M4876236 <P>As a workaround, one might create a DatabaseStart event that captures CurrentCacheSize when db_id() returns 0, i.e. when the database is the first started on the server. I guess that may not always return the initial cache size because the event is called when the database has been loaded which might have already adjusted the cache size - but it is good enough for my purpose...</P> Fri, 26 Jan 2018 04:20:07 GMT https://community.sap.com/t5/technology-q-a/how-to-query-the-initial-cache-size/qaa-p/13845393#M4876236 VolkerBarth 2018-01-26T04:20:07Z