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

book

Article ID: 222810

calendar_today

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.*