Unanswered: Migration 15.03 to 15.5 - Performance issues
We have migrated one server from 15.03 to 15.50. All the migration went well, but now we have performance issues, the customer sequence of sps is taking now 2x what it was before.
We kept the same configuration.
Changing the optimization level to ase_current did not changed anything.
The overall CPU usage is at 30%, spinlocks are fine, hit ratio on the cache is 99,9%.
Caches have also been increased.
From what we see the query plan has the same steps, however they are executed in a a diferent order.
Making the Sps to have much more LReads, increasing their running time.