Jean_Dagenais

Enabling/Disabling monitoring of SQL or Stored Procedures

Discussion created by Jean_Dagenais on Apr 15, 2010
Latest reply on Apr 27, 2010 by Chris_Hackett
Hello,  Sergio asked me to upload these 2 files which enable the Java agent to either:  - Monitor only the SQL Statements       -> sqlagent.pbd.monitor_only_sql_statements- Monitor only the Stored Procedures -> sqlagent.pbd.monitor_only_stored_procedures  Our app does about 5,000,000 SQL per day, so we where looking at ways to reduce the number of metrics captures (~ 25,000).  We got  one file  from Introscope development to investigate different ways of reducing the number of metrics, and I created the other one for testing. (Introscope 8.2.0)  Thanks,Jean  

Attachments

Outcomes