First I would look at how complex the policy is and ensure that the route assertion is taking that long (there are variables you can audit post route to see what it thinks the time is).You can also add audits to check after other assertions as here,https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/layer7-api-management/api-gateway/9-3/policy-assertions/assertion-latency.htmlIf this is RDS related I have to wonder after thinking about it if you are having RDS connection issues.You may want scope What size rds are you using? What are the max connections? What is the gateways io.coreconcurrency (And how many gateways) can the rds take all the connections you are loading at it? Is it the default max connections settings?
Then I would probably go with policy debugger or policy traces OR finer log levels.Thats probably how I would try to do it.Charlie.
I did the tcpdump and figured out that the gateway is creating a new tcp connection after a delay of 15 seconds almost.
Once a connection is open all the future request are not showing any latency.
That is why the issue is intermittent because the new tcp connection open is taking time.
Not sure, how to troubleshoot this further because we have not setup any connection maxconcurrency values.
And the gateway 2 (clustered server) works fine without any connection latency.
Amit Jaiswal CA-API Team
ITC Infotech India Ltd. ITC Infotech Park, 18 Banaswadi Main Road, Maruthiseva Nagar P.O, Bangalore - 560005 Mobile No.: +91 9739973343
Disclaimer: This communication is for the exclusive use of the intended recipient(s) and shall not attach any liability on the originator or ITC Infotech India Ltd./its Holding company/ its Subsidiaries/ its Group Companies. If you are the addressee, the contents of this e-mail are intended for your use only and it shall not be forwarded to any third party, without first obtaining written authorization from the originator or ITC Infotech India Ltd./ its Holding company/its Subsidiaries/ its Group Companies. It may contain information which is confidential and legally privileged and the same shall not be used or dealt with by any third party in any manner whatsoever without the specific consent of ITC Infotech India Ltd./ its Holding company/ its Subsidiaries/ its Group Companies.