CDS Database pool settings

[neilprince]

Hi

With regard to CAP databse pools (https://cap.cloud.sap/docs/node.js/databases), is there an approach to determing the correct values to configure in the cds.requires.db section of the package.json?

We had a job fail in production recently where a client could not be acquired from the pool. We are running with the default settings, but how do we know if those settings are sitting at 95% or we were just unlucky with load at the time?

I guess I am just seeking an approach rather than simply increasing our max connections and acquiistion timeouts with no real evidence/understanding.

Regards

Neil

[gregorw · Accepted solution]

Please check my question Monitoring DB pool usage, the answer and my improved sample implementation.

You can also test my version example bookshop-demowith some load using:

artillery run tests/catalog.yml

when you run it with HANA Cloud you can access

http://localhost:4004/pool/getInfo()

while running the load test and see the pool usage.