Spotfire Server Diagnostics – Minimum Connections vs. Idle connections for Spotfire Database at Startup
Article ID: KB0137791
Updated On:
| Products | Versions |
|---|---|
| Spotfire Server | All Version |
Description
The server.default option displays only two current idle connections in the Data source information under Server Diagnostics. However, the minimum data connections for the Spotfire database data source is five.
Please refer to the below screenshot (Monitoring & Diagnostics-->Server diagnostics-->View data sources-->Data source information for xyz.cloud.com)
Resolution
This behavior is expected. To optimize server startup time, idle connections are not pre-created. Instead, connections are established on demand as needed. The configured minimum number of connections still plays a role—it defines the threshold below which idle connections are retained. Only idle connections exceeding this minimum will be closed when the system load decreases.
Note: The minimum data connections created for other data sources will be when the data source is initialized and not on the server startup.
Issue/Introduction
This article explains why under the Server Diagnostics >>Data Source Information panel >>server.default shows only two idle connections at startup.
