Unknown SQL metrics

Products

• CA Application Performance Management Agent (APM / Wily / Introscope)
• INTROSCOPE

Issue/Introduction

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