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?
in this case I would set
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
to get only Average Response Time metrics.
Is any further assistance needed in this area?