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.