Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
Differentiate between clustered and non-clustered index.
Is sybase owned by sap?
How do I open a sybase database?
What is procedure cache and data cache in sybase?
What is coalesce in sybase?
How do I turn off marked suspect on my database in sybase?
Are you doing the updates from within a cursor?
What is isql in sybase?
What is rollback trigger in a trigger?
Given a table which contains some rows with duplicate keys, how would you remove the duplicates?
What do you mean by adaptive server enterprise?
Does sybase support row level locking?
How would you improve throughput in sybase?
How do I force an index to be used in sybase?
How do I pipe the output of isql to a file in sybase?
