I have a question for all the people using Sybase v 7.0. I have a database which is 600MB and the SQL manager is using up 1.5G of RAM to manage the databse. I read through an article which said that I could direct Sybase to use a limited quantity of the RAM. But, I dunno how. Can anyone please help me with my question.
Adaptive Server Anywhere Database Administration Guide
PART I : STARTING AND CONNECTING TO YOUR DATABASE
CHAPTER 5 : The Database Server
The database server (Page 124, and more especially 136)