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
Explain the role of replication server in sybase.
How to view the log files in sybase?
How to clear tempdb when the tempdb gets filled in sybase?
How do I open sybase control center?
Explain mirroring?
What is a good example of a transaction in sybase?
What is server replication?
Explain about the sybase group?
State some of the products of sybase?
Explain bind cache?
How do I bcp null dates in sybase?
How do you use workspace in sybase?
How would you replicate col = col + 1 in sybase?
You need to add a notnull column in a table by using alter command (without using default command). How would you do that?
What is sybase ?
