DX Application Performance Management

Expand all | Collapse all

18000 Stored Procedures and CA APM Performance

  • 1.  18000 Stored Procedures and CA APM Performance

    Posted 07-01-2015 08:20 AM

    Hello,

     

    We have severe performace degradation because one of our databases has 18000 stored procedures in it.

    What can we do to improve performance?

    It takes 2 hours to get a response from CA APM.

    I did not find anything relevant in the log files.

     

    There is a normalization procedure, but I'm not sure if it is applicable to stored procedures.

    What do you suggest?

     

    Regards,

    // Gokhan



  • 2.  Re: 18000 Stored Procedures and CA APM Performance

    Broadcom Employee
    Posted 07-01-2015 11:13 AM

    Hi Gokhan,

     

    in this case I would set

    introscope.agent.sqlagent.sql.turnoffmetrics=true

    in the IntroscopeAgent.profile to turn off metrics for individual SQL statements. .

     

    Another possibility would be to define regular expressions to reduce the number of generated metrics to around 1000-2000, i.e. 200-400 unique metric paths if you want all five metrics or set

    introscope.agent.sqlagent.sql.artonly=true

    to get only Average Response Time metrics.

     

    Ciao,

    Guenter



  • 3.  Re: 18000 Stored Procedures and CA APM Performance

    Broadcom Employee
    Posted 07-28-2015 01:19 PM

    @Hanger18

     

    Dear Gokhan:

     

    Is any further assistance needed in this area?

     

    Thanks

    Hal German

    APM Support