Upgrading Sybase to the next major revision may be the problem. Most database revisions, especially a major revision, will likely require CPU resources. The D-220 with 512 megs of RAM is extremely undersized for all but a simple database and a few users. You can see if you are severely out of memory with vmstat. If the po column (page outs) is 2 digits or more, you need to double or triple your RAM. And read the Sybase 12.5 release notes to find the minimum requirements for RAM.
I had already suggested my friend the same thing, like comparing the minimum requirements of the old version and the new version.
Do you think there would be any kernel parameter change required for the upgrade?
Or any kind of additional patches patches? If patchaes are required which all should I apply.
Mean while I am going through the minimum requirements of Sybase. But I remember that the minimum memroy required is less than 512MB. Let me refresh myself and confirm the same. Will come back to you with my findings after 15 Hrs.
Sybase support is the only place where you can get answers about possible kernel changes. As with all OS patches, they should be current (wihtin the last 6 months).
