We run 2 sybase databases and 1 Arbiter process on a machine.
One of the databases is 1.5gb in size (not replicated), the other is
about 500mb (replicated).

Neither databases are what you might call very busy, they process a
moderate to medium amount of transactional data. CPU usage is
relatively low.

I notice one of the databases (the replicated one) constantly has
about 1.5Gb of RAM used ,I can check dbserv.exe in task manager. This
sounds a lot to me, should it be so high and what can we do to make it
use less RAM ? I can see the buffer size is set at 100M. What decides
how much RAM dbserv uses ? It seems to be a constant 1.5Gb for one
database, it doesnt seem to free up memory when the database is not
being hit. Can we make it allocate less RAM for dbserv.exe.

We have 4Gb memory on the machine. Does it sound like enough to run 2
databases ? I know it depends on a lot of factors, but on average
does it sound reasonable ?

Today we tried to run a third database, the system became really slow,
are we trying to do too much with limited resourses.

Apologies about the relatively naive questions.

Task manager isn't a good way of determining how much cache the server
is currently using. See

http://iablog.sybase.com/paulley/200...-task-manager/

Glenn

Roshintosh wrote:
--
Glenn Paulley
Director, Engineering (Query Processing)
Sybase iAnywhere

Blog: http://iablog.sybase.com/paulley

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://case-express.sybase.com

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the
Sybase iAnywhere pages at
http://www.sybase.com/products/datab...chnicalsupport