DX Application Performance Management

Expand all | Collapse all

How to reduce SQL Metrics?

Jump to Best Answer
  • 1.  How to reduce SQL Metrics?

    Posted 12-29-2010 02:25 PM
    Hi,

    We are seeing too many SQL metrics reporting to EM from Agent, where 55% of Agent Metrics are sql metrics. We dont want to disable sql,but still we want to Troubleshhot the SQL metric explosion problem. Is there any ways to reduce the SQL Metrics.

    Thanks,
    Madhu


  • 2.  RE: How to reduce SQL Metrics?
    Best Answer

    Posted 01-04-2011 02:37 PM
      |   view attached
    Madhu,
    Consider placing the following in your agent profile:

    introscope.agent.sqlagent.sql.maxlength=N

    Where N equals 0-999. The default is 999 for the SQLAgent.

    Try starting with a value of 500 and see if this doesn't help you to diagnose the problem. I'm also attaching a KB article which may help you to identify the issue.

    -Hiko

    Attachment(s)