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
What is cmaxpktsz good for in sybase?
What is trace flags — 5101 and 5102 in sybase?
What is cis and how can I use it?
How do I add a sybase driver to sql developer?
How to find the time taken for rollback of the processed?
Differentiate between db-lib and ct-lib?
What do you mean by deferred update in sybase?
What is sybase ?
How would you replicate col = col + 1 in sybase?
You need to remove the affected rows and dashes. How would you do that?
Is there any advantage of last_name varchar(50) over this last_name varchar(255)?
Explain timestemp datatype in sybase.
What are triggers? Why do we use them? Diff types of triggers? What are magic tables?
We have lost the sa password, what can we do?
How to check if sybase database is up and running?
