AnsweredAssumed Answered

SQL normalization and URL grouping

Question asked by Karthik Nalliyappan on Sep 1, 2015
Latest reply on Sep 3, 2015 by danta01

Hello All,

 

I just found SQL metrics are of high count on my environment and thinking to initiate SQL normalization.

I would like to know the exact process and procedures for doing this. I just found a wiki link which describe the steps

 

https://wiki.ca.com/display/APMDEVOPS97/Configure+SQL+Monitoring+for+Java#ConfigureSQLMonitoringforJava-HowPoorlyWrittenSQLStatementsCreateMetricExplosions

 

Can someone tell me whether this information is enough to start? or do we have any other docs available?

 

Also I see lot of URL's reported like below under front ends. What is the best way to stop receiving this? What about grouping URL's? Will that work in these situations?

 

 

Thanks,

Karthik

Outcomes