Parameter
There are 3 main parameters that control how many users can log in at one time:
- Maximum connections in the connection pool. It controls the number of threads opened to a specific database from nqsserver.
- OBIEE - DbGateway (DB_GATEWAY_THREAD_RANGE) from dbgateway. It controls the number of threads opened to all databases defined in the repository from nqsserver.
- OBIEE - Server Thread. It controls the number of threads open for BI Server clients.
Articles Related
Example
Database | 5 |
Connection pool per database | 1 |
Maximum connections for each Connection Pool | 100 |
Total connections across the .rpd | 678 |
DB_GATEWAY_THREAD_RANGE | 40-200 |
- If all 678 Connection Pool connections are in use, only 200 will actually be active.
- The other 478 will be queued up waiting. When a query finishes, one of the waiting jobs will become active.