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

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

    • No data for service and process in Windows server monitor

      If you see "No Data" for process and service metrics (such as CPU or memory usage of monitored services) in the Site24x7 Windows server monitor user interface, follow the troubleshooting steps below. Run PowerShell Commands Open PowerShell as ...

    • Difference between a website monitor and a SOAP Web Service monitor

      Website monitor will support monitoring of any web application via POST, GET and HEAD methods of configuration. Learn more on the performance metrics provided for a website monitor. SOAP Web Service monitors , on the other hand, lets you to ...

    • Setting up a website monitor w.r.t content match and HTTP configuration

      Regarding the website defacement (content match) configuration, you can set keyword checks to find the existence and non-existence of keywords in your HTML response. As far as the HTTP configurations are concerned, we support HEAD, GET, and POST ...

    • Site24x7 Real User Monitoring (RUM) - Data Collection

      When you include Site24x7 RUM beacon script in your web pages, the following data is collected. All data that's being collected is in accordance with GDPR compliance. Performance details of web page load time - Metrics like response time of web page ...