I've been having a tough time with testing two interconnected ASA10 databases I've rebuild in version 16. On much of the testing I've done, the databases perform fine, even sometimes better than on 10. But certain queries run almost impossibly slow after the upgrade.
I've read about and modified the max_query_tasks values and rebuilt statistics to no avail. For example, a query that normally takes 6 minutes on the version 10 database has been running since 10:55AM and hasn't finished yet. So something is very off.
Is there something special I need to know about upgrading remotely connected databases? The machine I'm running the testing on has 32GB of RAM, and a 4Ghz processor, as well as both databases running on a solid state drive using the current EBF of ASA16.
asked 30 Aug '16, 18:46