> > Here's something u can look at:
> > - Check the swap space on the server. Rule of thumb (for any Unix
> > server with a database engine running on it): Have twice as much swap
> > space as real memory.
> Rubbish. ASE uses shared memory. Swap space isn't really required
> by it. Other processes, however, would be a different issue.
> > On Sun, u can use these commands to check:
> > swap -l ==> List allocated swap space/
> > swap -s ==> List free swap space.
> > If the Sybase is the only thing running on the server, I'd give Sybase
> > 90% of the real memory.
> Which has what, exactly, to do with swap? You can also configure
> Solaris without swap.
One more thing. I got interrupted while typing my first response.
Sybase DOES use paging space. Do u remember those timeslice errors
Sybase used to have in version 11 and earlier versions?
Some of those errors were caused by lack of swap space. Sybase did fix
most of their timeslice errors, but its use of paging space did not
stop and still part of the core db engine.
As a matter of fact, lack of swap space not only affects performance
of both the Sybase and Unix servers, it could also cause db corruption
on rare occasions under Sybase 11.
Problems related with lack of swap space are not immediate. The
affects usually show up when a server has been up for along time
Again, Swap space can be looked IF all means were used of searching
for slow response casues inside the Sybase server.