DX Application Performance Management

  • 1.  How to reduce SQL Metrics?

    Posted Dec 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

    Broadcom Employee
    Posted Jan 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)