AnsweredAssumed Answered

18000 Stored Procedures and CA APM Performance

Question asked by Hangar18 on Jul 1, 2015
Latest reply on Jul 28, 2015 by Hallett_German

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

Outcomes