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?