Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2001
    Posts
    7

    Unanswered: device fragment limit

    Is there is a maximum limit for number device fragements per database ? If so, how many for ASE 11.9.2 and 12.0.

    Thanks

  2. #2
    Join Date
    Sep 2002
    Location
    Sydney, Australia
    Posts
    255
    Theoretically, no. But you will reach the limit of several configuration parameters (eg. open objects, devices, file descriptors) well before then. In my experience, a badly neglected db had > 500 dev fragment per db, before it was cleaned up. You will also have problems with system procs being slow, as the most critical system tables will get unreasonably large. You will also be using unnecessary locks.

    I use a MINIMUM
    - (raw partition) dev size of 2gb
    - dev/db fragment size of 500mb.

    If you are expanding the db in (eg) 50mb fragments, you will have a fragmentation problem, which seriously affects performance. It is a simple matter to clean this up.
    Last edited by DerekA; 09-17-02 at 04:54.
    Derek Asirvadem
    Senior Sybase DBA/Information Architect derekATsoftwaregemsDOTcomDOTau
    Anything worth doing is worth doing Right The First Time
    Spend your money on standards-compliant development or spend 10 times more fixing it

  3. #3
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    Top of the day

    Find whitepaper on device size limits available here for ASE 11.9.x and 12.0

    http://my.sybase.com/detail?id=800

    Cheers
    Willy

  4. #4
    Join Date
    Sep 2002
    Location
    Sydney, Australia
    Posts
    255
    Originally posted by willy_and_the_ci
    Top of the day

    Find whitepaper on device size limits available here for ASE 11.9.x and 12.0

    http://my.sybase.com/detail?id=800

    Cheers
    Willy
    Device sizes and and device size limits are quite separate to device fragments within a database (or device fragments within a server). The question relates to the latter.

    Cheers
    Derek Asirvadem
    Senior Sybase DBA/Information Architect derekATsoftwaregemsDOTcomDOTau
    Anything worth doing is worth doing Right The First Time
    Spend your money on standards-compliant development or spend 10 times more fixing it

Posting Permissions

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