Skip to main content

DB, SQL

It provides the DB and SQL related options of the .NET agent.

  • trace_sql_normalize_enabled Boolean

    Default true

    It enables the function to normalize any SQL statements by extracting the literal part from each SQL statement. The literal part is denoted with "#."

  • profile_sql_resource_enabled Boolean

    Default false

    It traces the CPU and memory usages during collection of SQLs in the transaction trace.

  • profile_sql_param_enabled Boolean​

    Default false

    It is used to record SQL parameters in the transaction trace details. The parameters can be viewed by entering a separate security key.

    Note

    Specify the security key to a 6-letter value in the WAS server's %PROGRAMFILES%/WhaTap .NET\paramkey.txt file. If paramkey.txt does not exist, it is automatically created as a random value.