Sybase tutorial

[djbbenn]

hey I am required to go through some good tutorial for sybase sql server. Actually I don't have any experience on

Really need to go through 1 as soon as possible.

Thanks in advance.

[Xeusion]

Sybase

A Sybase server consists of:
A) two processes, data server and backup server ;
B) devices which house the databases; one database (master) contains system and configuration data ;
C) a configuration file which contains the server attributes .

Memory Model
The Sybase memory model consists of:
A) the program area, which is where the dataserver executable is stored;
B) the data cache, stores recently fetched pages from the database device
C) the stored procedure cache, which contains optimized sql calls

The Sybase dataserver runs as a single process within the operating system; when multiple users are connected to the database, only one process is managed by the OS. Each Sybase database connection requires 40-60k of memory.
The "total memory" configuration parameter determines the amount of memory allocated to the server. This memory is taken immediately upon startup, and does not increase.

[djbbenn]

Thanks,

You gave me a real quick & prompt reply.