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.
Printable View
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.
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.
Thanks,
You gave me a real quick & prompt reply.