We are upgrading our hardware for Sybase ASE and minor upgrade in the Sybase ASE Service Pack Version.
Upgrades are as follows:
1.Number of Cores - From 4 core to 8 core
2.Physical memory - 64 GB to 128GB.
3.ASE - Upgraded from "Adaptive Server Enterprise/15.7/EBF 21707 SMP SP110 /P/ia64/HP-UX B.11.31/ase157sp11x/3546/64-bit/FBO/Fri Nov 8 08:40:39 2013" to "Adaptive Server Enterprise/15.7/EBF 27351 SMP SP139 /P/ia64/HP-UX B.11.31/ase157sp138x/4041/64-bit/FBO/Tue Aug 8 07:33:11 2017"
I have configured number of engines from 4 to 8 and max memory from 60GB to 100GB.
can someone please advise what additional parameters should be changed in order to enhance performance of Sybase on the new server
Asked by Learning_DBAdmin
(3924 rep)
Jul 1, 2018, 11:25 AM