Results 1 to 5 of 5
  1. #1
    Join Date
    May 2007
    Posts
    2

    Question Unanswered: Is there any database/table size limitation?

    We use Adaptive Server Enterprise/12.5.3 and we have a table that is 80 million rows large.
    I was wondering, is there any space limitation or guideline for how large a table/database can be?

    Thanks.

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    A maximum the table can grow in 12.5.x is 4TB, the same size as the database.

    The largest device size ASE 12.5.x supports 32GB

  3. #3
    Join Date
    May 2007
    Posts
    2
    Thank you. What do you mean the largest device size it supports is 32GB?

    My understanding if I have a machine with 4TB of space then sybase would be able to handle that size. right?

  4. #4
    Join Date
    Feb 2007
    Location
    India
    Posts
    56

    Hi,

    I have one doubt about willy's answer.

    According to you(willy) I can have a table with 4tb and can i also
    contains other tables of some space?



    Thanks
    pvvsnaveen.

  5. #5
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    ASE 12.5.x has a limit of 256 devices (including master)
    The maximum device size is 32 GB.
    So the maximum size for a user database is
    (256 devices * 32GB/device) - (size of system databases)
    i.e, just a little under 8 terabytes.

    But, One database may have up to 2^31 (2,147,483,648) logical pages.
    so its maximum size also depends on its logical page size:

    on a 2K page server is 4TB
    on a 4K page server is 8TB

Posting Permissions

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