Monitor parameters in SQL queries | APM Insight

APM Insight provides information on the parameters it sends to the SQL queries

The parameters in slow SQL queries can be tracked and displayed under the traces tab.

We have the option to obfuscate the values of SQL query parameters using a configuration Obfuscate SQL Parameters. It will be enabled by default. The screenshot below shows the configuration for parameterizing the SQL queries.



Please find the below screenshots for both inline SQL queries and stored procedure calls. 

When the option is enabled, the parameter values will be obfuscated as given below:   
  1. SQL inline query with obfuscated parameter values



  1. SQL stored procedure with obfuscated parameter values



When the option is disabled, the parameter values will not be obfuscated as given below:

  1. SQL inline query without obfuscating the parameter values


  1. SQL stored procedure without obfuscating the parameter values





Info

Customers also searched this KB for the below problem statements:

  1. Can we get the Login ID, Session No, and Type details from an SQL Statement for APM Monitoring?
  2. Do the values of HTTP requests or DB queries get removed before they are transmitted?
  3. Can query strings be captured as part of APM transactions?
  4. The obfuscated alphanumeric values are not visible. Why?
  5. Ability to mask PII data from Traces/Snapshots.

Top Phrases/Keywords used: Obfuscate SQL parameters, configuration profile, SQL query parameters, Site24x7 server, query strings, APM transactions, APM Insight monitor, Edit APM Agent configuration profile, obfuscate sensitive data, SQL details in APM, PII accidentally exposed.



    • Related Articles

    • How to identify and resolve conflicts between other APM products and the APM Insight .NET agent

      Problem statement: You are experiencing either of the below issues and suspect that another APM product is interfering with the Site24x7 .NET agent. 1. The .NET monitor is not created under APM > APM Insight > Applications, even after the .NET agent ...

    • Basic troubleshooting tips for the APM Insight Node.js agent

      If you are experiencing issues after installing the APM Insight Node.js agent, follow these troubleshooting tips. Verify agent installation and connectivity To verify the agent installation status, you can execute the following command from the root ...

    • OpenTelemetry Licensing

      The OpenTelemetry (OTel) Service license usage applies when traces are stored and indexed in AppLogs. The cost is tied to trace storage, rather than the number of OTel services or monitors created. Suppose you have purchased 100GB of log storage. If ...

    • Unable to add SQL insight monitor

      If the SQL Insight monitor is not getting added even after entering your credentials, try these troubleshooting steps: Ensure that the Auto-discover applications feature is enabled. If not, you will need to trigger discovery using the Discover ...

    • APM Insight integration for Next.js in Kubernetes

      To integrate the Site24x7 APM Insight Next.js agent into your Kubernetes application using initContainers with the prebuilt agent image, follow the steps below: Prerequisites A Next.js application container image The Site24x7 APM Insight license key ...