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
How to find the time taken for rollback of the processed?
What is the use of 'with check' option in views?
How would you replicate col = col + 1 in sybase?
Compare in and exists?
What is sybase infomaker?
What are the best monitoring tools for the sybase database?
For synchronizing the logins from lower version to higher version, just take the 11.9.2 syslogins structure, go to 12.5 higher version server?
Explain the features of sybase.
Why place tempdb and log on low numbered devices?
How do check the current running processes?
Can two tasks be assigned to the same partition in sybase?
What is the difference between 'dump tran database to physical name' 'dump tran database with truncate_only' and dump tran database with no_log'and in real time when we go to truncate the log?
You need to remove duplicate rows from a sybase table. How would you do that?
What are the vital features of sybase?
What measures are there to increase the db space?
