Kbase P99630: What does "Needed" and "Peak" Connections mean within the dataserv.lg file?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
07/01/2005 |
|
Status: Unverified
GOAL:
What does "Peak Connections" mean within the dataserv.lg file?
GOAL:
What does "Needed Connections" mean within the dataserv.lg file?
FACT(s) (Environment):
MS SQL DataServer
OpenEdge 10.0B
FIX:
In OpenEdge 10.0B, at startup, the number of managed connections initialized is written to the log file. It connections are rejected, this is logged. If a connection from the ODBC connection pool cannot be used, the ODBC driver issues the message "DEAD Connection" which is written to the log file.
At the end of a session, the DataServer writes summary information about firehose cursor use. The summary contains the following information
-Needed Connections
-Peak Connections
"Needed connections" is the recommended setting for the requested connections at startup. It is based on feedback from application's execution. If the application were to change, the averaging during execution might also change so you should only take the log's recommendation when code is stable.
"Peak connections" lets you know the maximum number of simultaneous connections used during the session. This number will always be the same or higher than the needed connections. It may represent a one time or temporary spike in connections used during the session and may not be representative of what the application demands overall.
The purpose in reporting all this information is to optimize the number of connections declared at startup to match the number needed by the application at run-time without leaving a lot of unused connections (and unused resources) outstanding.
For more information on connections and firehose cursors, please refer to PDF, "New Features for the DataServer for MicroSoft SQL Server in OpenEdge 10.0B".
Please note that a lot of cursor information gets written to the log independent of the firehose implementation when qt_debug,CURSOR is selected in your connect parameters.