Try OpenEdge Now
skip to main content
DataServer for Microsoft SQL Server
Additional Features to Enhance DataServer Performance : Connection pooling : Monitoring cursor and connection use
 

Monitoring cursor and connection use

Monitor the use of your managed connections to tune the number of connections you allocate. If you regularly exceed your allocation, consider increasing the number of managed connections. If you never use your total allocation, consider decreasing the number of managed connections.
You can monitor connections either through using OpenEdge logging or by enabling logging using the "-Dsrv qt_debug,cursor" switch.
Note: The OpenEdge logging infrastructure offers more extensive reporting capabilities than qt_debug. For details on enhanced logging, see Analyzing application execution with Enhanced Logger.
* Monitoring connections with qt_debug
* Cursor downgrades
* Statement cache