|
Service
|
Description
|
|---|---|
|
SetDatabaseConnectionTracking
|
This service enables or disables the database connection tracking functionality, where the database connection consuming stack traces are logged. Enabling tracking allows to capture the stack traces of a database connection consuming threads.
• When the service reaches the configured connection pool size, then it automatically starts logging the stack trace in the error log 5 times with a frequency of every 10 seconds for the connections which are active for more than 1000 milliseconds.
• The cooling period for this service is 1 hour.
|
|
LogDatabaseConnectionStacktraces
|
This service logs the stack traces of a database connection consuming threads. This service is called explicitly when stack traces are needed in the error log.
• If SetDatabaseConnectionTracking is disabled, the service will not log the stack traces in the error log file.
• If SetDatabaseConnectionTracking is enabled and LogDatabaseConnectionStacktraces service is called, stack traces will be logged in the error log.
|
|
GetDatabaseConnectionTrackingInfo
|
This service returns the current configuration of database connection tracking functionality as follows:
• This service returns if SetDatabaseConnectionTracking is enabled or disabled.
• This service also returns current values of Database connection tracking configuration.
◦ Threshold Database Connection Pool Saturation to trigger Stack Traces (in Percent)
◦ Count of Set of Stack Traces logged once triggered
◦ Interval at which the Stack Traces will be logged (in Seconds)
◦ Minimum elapsed time before Stack Trace logging triggers again (in Minutes)
◦ Duration the connection is held for Stack Traces to be logged (in milliseconds)
|