Unknown SQL metrics

Document ID : KB000005454
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

The APM SQL Agent has "unknown SQL" metrics under it in the investigator. These metrics increase the response time calculated in the total SQL transactions report .

 

Environment:
Win2008 sql server .
Cause:

 

 When the SQL agent cannot receive all data in time from the JDBC driver about a monitored transaction (due to SQL server overloaded, network overload, etc.) it creates an "unknown SQL" metric .

 

 

 

 

Resolution:

 

 

 When the APM SQL agent log is set to use DEBUG logging , the agent log will give information about the JDBC class which created the "Unknown SQL" metric. For example:

 

 [DEBUG] [IntroscopeAgent.Agent] Please insert "SkipClass: com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement" in .pbd to suppress "Unknown SQL" metrics.

 

 You can skip this class from the the SQLagent pdb to avoid the creation of new "unknown SQL” metrics

  Any existing "Unknown SQL” metrics will be purged when they reached the aging limit for metric data