what is the architechure of sybase ASE?
Answers were Sorted based on User's Feedback
Answer / prabhu
The Sybase Server
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.
A database device stores the objects that make up
databases.
The term device does not necessarily refer to a
distinct physical device: it can refer to any piece of a
disk (such as a disk partition) or a file in the file
system that is used to store databases and their objects.
Each database device or file must be prepared and made
known to Adaptive Server before it can be used for database
storage. This process is called initialization.
A segment is a label that points to one or more database
devices. When you first create a database, Adaptive Server
creates three segments in the database,
System: Stores the database?s system tables.
Logsegment: Stores the database?s transaction log.
Default: Stores all other database objects?unless you
create additional segments and store tables or indexes on
the new segments by using create table...on segment_name or
create index...on segment_name
Is This Answer Correct ? | 18 Yes | 2 No |
Answer / dilip voora
SYBASE ASE conists of
1.ASE executable files
2.ASE internal threads
3.ASE databases
4.Backupserver
5.Shared memory(most important)
1.ASE executable files are RUN server file, contains certain parameters that are required to startup the dataserver(ASE) also it contains the path/ location of error log file(which logs all console/error messages), location of configuration file(helps us in giving the information of the configuration parameters that are currently being set for the functionality of ASE), location of interface file(gives us information related to the connectivity), logical page size of the server(default for ASE 15.7 is 4K). Inorder to start the servers either dataserver or backupserver we have to use RUN_SERVER -f <dataserver_name/ backupserver_name>
2.ASE iternal threads 'port manager, network handler, ASTC handlers, HK chores, HK wash, HK GC, checkpoint worker, checkpoint sleep, mirror handler, deadlock tune, license heartbeat'.
3.When ASE is installed by default master, model, sybsystem, tempdb and sybsystemprocs will be created. Alos we can create user databases and some other databases called sybmgmtdb, sybauditdb, dbcc db. From ASE 15.7 we can create multiple temp dbs to distribute the load among all the resources.
4.Backupserver is the instance of the ASE dataserver which will help in supporting the dump and load of database and transaction log(syslog).
5.Coming to shared memory, it is divided into three parts
a)Procedure cache b)Data cache c) Log cache
Procedure cache : As the name itslef tells that the cache will contains the stored procedures/ system procedures. In turn this will contain another component called 'statement cache' which holds the recently executed SQL query/ abstract plan.
Data cache: This contains the recently executed data. By holding the data in this cache i/o will be reduced thereby increasing the performance. If the data is being fetched from the disk, it is known as 'physical i/o' and if the data is being fetched from the cache it is known as 'logical i/o'.
Log cache: This will hold the logs that are being generated with respect to any DML statements happened on the data.
Use the below URL for pictorial representation of ASE's architecture.
https://talebzadehmich.files.wordpress.com/2012/02/ase15-7_architecture.pdf
Is This Answer Correct ? | 4 Yes | 1 No |
How do I connect to a sybase database?
Is sybase sql?
Is there a difference in storage type of numeric and decimal data types in sybase? If yes, what?
Why do my page locks not get escalated to a table lock after 200 locks?
Compare join and subquery in performance?
A single operation is failing to escalate?
Explain mirroring?
What is the default table size in sybase?
What is the default size of master database in sybase?
How to find the time taken for rollback of the processed?
What does –i option do in sybase tools?
List similarities and differences between oracle & sybase.