ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
Advantage SQL DB Performance issues
Article ID: 222810
Updated On:
Products
DX SaaS
Issue/Introduction
We still observe performance overhead on the calls made to Advantage SQL DB.
Cause
Certain Classes / Methods causing the loop
Environment
Release : SAAS
Component : Integration with APM
Resolution
1) Turn off SQL Agent tracing group:
# TurnOn: SQLAgentConnections
2) We can configure a skips.pbd with entries as below :
#######################################
# Skips.pbd
#######################################
#####################################################################
# Skip classes that may be contributing to the overhead.
# ===================================================================
#
SkipPackagePrefix: com.extendedsystems.jdbc.advantage.*
SkipPackagePrefix: com.zaxxer.hikari.*
Feedback
Yes
No
Powered by
