In order to avoid Artifactory slowness problems like slower response times for requests, dropped connections, connection pool depletion, timeouts, and node synchronization issues, it's crucial that Artifactory and the database have a stable and quick connection.
Things to consider checking:
Things to consider checking:
- Check whether there are high CPU spikes and the database is overloaded.
- Number of open connections from the database to the Artifactory so that the database is not completely utilized and is able to handle the requests sent via Artifactory.
Generally, we will need a certain number of connections from the DB based on
Total # of connections = (number of nodes) * ((artifactory.database.maxOpenConnections * 2) + access.database.maxOpenConnections + metadata.database.maxOpenConnections) + 50;3. Check whether the connectivity between the database and Artifactory is okay