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

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

    • Troubleshooting steps when no data is received from the SQL server

      As we use "Perfmon" to fetch data for Microsoft SQL monitoring, please check if the counters related to SQL are present in the user's perfmon. Please follow the steps below: Open the server machine in which the issue is occurring. Start -> Run and ...

    • What are Incident Parameters and Custom Parameters?

      Incident and Custom parameters get passed along with the body of the URL during an HTTP request invocation. Incident Parameters Incident Parameters are predefined system parameters passed in the invoked URL's body. In the HTTP response, the Incident ...