Configuring Monitoring in a Client/Server Configuration
OpenAccess SDK provides the following levels of monitoring for data access services, listed here from highest-level to lowest-level. Some of the monitoring levels are also supported for the OpenAccess SDK Agent service.
Service monitoring monitors these activities by service:
Statistics of received packets and sent packets
Sessions started and statements opened
Active statements and sessions
Fetched rows and affected rows
Transactions
Session monitoring monitors these activities by session within a service:
Statistics of received packets and sent packets
Statements opened and active statements
Fetched rows and affected rows
Transactions
Information about each session, such as start time, client information (network address, data source used by the client, and type of client), native database session identification, and database user
Statement monitoring monitors these activities by statement within a session:
Fetched rows and affected rows
SQL statements issued
To enable monitoring at one of the listed levels, higher-level monitoring must be enabled. For example, you cannot monitor Session information unless Service monitoring is enabled. Similarly, you cannot monitor Statement information unless both Service monitoring and Session monitoring are enabled.
On Linux/UNIX, the services created by the OpenAccess SDK Server installer have both a monitoring and an event trace profile enabled.
After installation, you can create a new monitoring profile or modify the existing profile.
You can configure only one monitoring profile for each service.
After changing the connection model for a service, you must delete any monitoring or event profiles for the service. For example, if you changed the connection model from Thread/Connection to Process/Connection, you must delete the monitoring and event profiles, and create new profiles.
You can integrate OpenAccess SDK monitoring with the Windows Performance Monitor tool, which allows you to access monitoring information from the Windows tool.
Service monitoring monitors these activities by service:
