Memory Requirements for SQL Anywhere 
Author Message
 Memory Requirements for SQL Anywhere

To All,

Does anyone know of any documentation stating the cache requirements of
starting up a SQL Anywhere server, depending on the size and number of
databases to be started by the one server. Also takeing this into
consideration, the amount of memory required for an NT or Novell server
to give optimum performance to sybase.

Thanks in advance
John Katsoudas
InfoComp Pty Ltd



Mon, 10 Apr 2000 03:00:00 GMT
 Memory Requirements for SQL Anywhere

Quote:

> To All,

> Does anyone know of any documentation stating the cache requirements of
> starting up a SQL Anywhere server, depending on the size and number of
> databases to be started by the one server. Also takeing this into
> consideration, the amount of memory required for an NT or Novell server
> to give optimum performance to sybase.

I'm not sure of the documentation, but from personal experience in
setting up and maintaining various systems...I would suggest setting the
cache at 10-15% of the database size. So the larger the database...the
larger the cache allocated. We've used this guide for both NT and Novell
environments....

Lena

Solutions Consultant



Sat, 15 Apr 2000 03:00:00 GMT
 Memory Requirements for SQL Anywhere

We had a SQLA database running on an NT server that had 64 megs.  At that
time, the database was only about 16 or 17 megs and was using the default
buffer size.  I was not happy with performance and bumped the buffer up to
20 megs.  Performance improved dramatically.

When we ordered a new server, I got 256 megs of RAM in it because I was
going to be loading more data into the database.  When I did that, the
database size was about 88 megs.  I set the buffer at 100.  Because I have
ample memory anyway, I have not tested smaller buffer settings.

Quote:


>> To All,

>> Does anyone know of any documentation stating the cache requirements of
>> starting up a SQL Anywhere server, depending on the size and number of
>> databases to be started by the one server. Also takeing this into
>> consideration, the amount of memory required for an NT or Novell server
>> to give optimum performance to sybase.

>I'm not sure of the documentation, but from personal experience in
>setting up and maintaining various systems...I would suggest setting the
>cache at 10-15% of the database size. So the larger the database...the
>larger the cache allocated. We've used this guide for both NT and Novell
>environments....

>Lena

>Solutions Consultant



Wed, 19 Apr 2000 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Memory requirements for SQL Server?

2. Memory requirements for new SQL Server

3. Question about SQL 7.0 vs. 6.5 Memory Requirements

4. SQL Server Memory Requirements

5. Memory requirements for SQL 7.0

6. SQL Server 2000 memory requirements

7. Extreem memory requirements for SQL*FORMS 4.5 character mode

8. sql anywhere memory leak

9. DELPHI with SYBASE SQL ANYWHERE------ DELPHI with SYBASE SQL ANYWHERE

10. Memory Requirement Update

11. Memory requirements

12. replication memory and disk requirements


 
Powered by phpBB® Forum Software