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

    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.


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

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


    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.