I am using APM 6.6 to monitor application performance along with Elasticsearch and Kibana but the thing is that i want to show the sql parameters as well. How can i achieve this
We do not capture parameters as they may contain sensitive information.
For now you would need to log these separately. Depending on the agent and logger you use, you could then correlate your traces and logs to find this additional context, e.g. for Java: https://www.elastic.co/guide/en/apm/agent/java/current/config-logging.html#config-enable-log-correlation