Sybase Question:

Why place tempdb and log on low numbered devices?

Tweet Share WhatsApp

Answer:

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

Download Sybase PDF Read All 123 Sybase Questions
Previous QuestionNext Question
Should I run 32 or 64 bit ASE with Solaris?How do I force an index to be used in Sybase?