Why place tempdb and log on low numbered devices

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

Why place tempdb and log on low numbered devices?

System 10 and below.
In System 10 and Sybase 4.X, the I/O scheduler starts at logical device (ldev) zero and works up the ldev list looking for outstanding I/O's to process. Taking this into consideration, the following device fragments (disk init) should be added before any others:
1. tempdb
2. log

(Continued on next question...)

Other Job Interview Questions

• What is Trace Flags -- 5101 and 5102 in Sybase ?
• Explain about the Sybase group?
• Which version of Open Client works with which ASE in Sybase?
• What is the difference between an LTM and a RepAgent in Sybase?
• What is Open Server in Sybase?
• I have upgraded to MS SQL Server 7.0 and can no longer connect from Sybase's isql.
• How to clear tempdb when the tempdb gets filled in Sybase?
• How do I find the oldest open transaction in Sybase?
• How to implement database security ?
• How to manually drop a table in Sybase
• More...