Unknown SQL metrics

book

Article ID: 5454

calendar_today

Updated On:

Products

APP PERF MANAGEMENT CA Application Performance Management Agent (APM / Wily / Introscope) CUSTOMER EXPERIENCE MANAGER 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 .

 

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 .

 

 

 

 

Environment

Win2008 sql server .

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