Results 1 to 7 of 7
  1. #1
    Join Date
    Oct 2002
    Posts
    3

    Question Unanswered: FILE SYSTEM OR RAW DEVICE on ASE 12.5

    Hi;

    We are going to migrate our database version 11.0.3 to ASE 12.5 on Solaris 8.
    Our problem is that S.O support told us that we couldn't have more than 8 raw partition in the array, but We have more than 8 databases.
    I know it is now safe to place the Sybase devices on Unix filesystem
    (using dsync option) or on traditional rawdevices.
    I want to know if I could get some performance problems if We'll decide to use File System using dsync option.

    thanks

  2. #2
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524
    The question is to know if it's possible to use the asynchronous mode in a file system on Sun Solaris 8.

    If it's yes, choose file systems !

  3. #3
    Join Date
    Nov 2002
    Posts
    833

    Re: FILE SYSTEM OR RAW DEVICE on ASE 12.5

    Originally posted by Maricel
    Hi;

    We are going to migrate our database version 11.0.3 to ASE 12.5 on Solaris 8.
    Our problem is that S.O support told us that we couldn't have more than 8 raw partition in the array, but We have more than 8 databases.
    I know it is now safe to place the Sybase devices on Unix filesystem
    (using dsync option) or on traditional rawdevices.
    I want to know if I could get some performance problems if We'll decide to use File System using dsync option.

    thanks
    but raw devices will still do the job faster - abount 30 %

    bernd

  4. #4
    Join Date
    Oct 2002
    Posts
    3

    Re: FILE SYSTEM OR RAW DEVICE on ASE 12.5

    How do you know that?

    did you test the file system with asyn true in compared with raw partition?

    thanks

  5. #5
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524

    Re: FILE SYSTEM OR RAW DEVICE on ASE 12.5

    Originally posted by osy45
    but raw devices will still do the job faster - abount 30 %

    bernd
    From the best to the worst :

    1) File System (old) : because it's able to use the OS cache, but it's dangerous in a crash situation

    2) Raw device : but not accessible via the OS (except using Admin tools ;-))

    3) Secure File Systems : till v.12. Easier to manage, but a little bit slower

  6. #6
    Join Date
    Nov 2002
    Posts
    833

    Re: FILE SYSTEM OR RAW DEVICE on ASE 12.5

    Originally posted by Maricel
    How do you know that?

    did you test the file system with asyn true in compared with raw partition?

    thanks
    hi,

    we had setup database on sun solaris 2.8 on e3500 with sybase ase 12.5 and file system devices and figured out that it was much slower than the 11.9.2 with raw devices. We moved back and got a gain of about 30% althouth what I learned afterward that jeffrey garbus' stated in his book sybase ase tuning ... a 40 to 50% gain (see chap 2 page 15)

    bernd

  7. #7
    Join Date
    Jul 2002
    Posts
    2

    Re: FILE SYSTEM OR RAW DEVICE on ASE 12.5

    Hi there,

    You probably should run disksuite 4.2.1 with forcedirectio for that mount point to get optimum performance from your disk pack.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •