I have a question regarding the use of raw partitions and filesystems using Sybase databases, my current scenario has the main database on raw volumes, with the transaction log on filesystem and temp also on filesystem, and I also remember having conversations in the past with DBA's stating that this setup is prefered as it performs better.
Can anyone clear up for me if the transaction log performs better on filesystem than raw disk, or why a database setup in this way is preferred by DBA's (if at all????)
I'm running Sybase 12.5.3 on Linux, with all devices on an ext3 filesystem (located on a RAID 1+0 fiber disk Dot Hill SAN). We ran benchmarks between ext3 fs devices and raw, and did not notice any significant difference in performance. For the tempdb devices, we're running with dsync turned off.
FYI- up until 12.5.3 ESD #4, there was a bug that caused even dsync=on devices to be unsafe, but it's fixed in EBF 12876.