Skip to Content
avatar image
Former Member

Maximum DB size for SAP on ASE?

Hello ASE experts,

If I'm not wrong, a ASE database can be up to 32TB when a pagesize of 16KB is used - which is the case for the SAP BusinessSuite.

Nevertheless, this seems to be a pretty hard limit, which does not exist for the other available databases like Oracle or SQL Server.

Am I correct? Any other comments?

Thanks,

Uli

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Best Answer
    May 04, 2012 at 03:05 PM

    Hello Uli.

    Yes, there is a limit in ASE for 32TB in the current version, but I expect changes to this limit.

    Please also take into account that this is the size of compressed data. Data compression is part of the standard ASE license for SAP customers. If you calculate with a 50% compression rate (rough guess, that really depends on the type of data in the system) we are talking about 64TB data in the system.

    Regards,

    Jan

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Jan Stallkamp

      I will post what I have done tomorrow and walkthrough my experience but thanks for the tip! I will dig into that note and yes I have read the blog but I am quite the newbie with Sybase 😊

  • avatar image
    Former Member
    May 07, 2012 at 05:39 PM

    This message was moderated.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 23, 2012 at 04:24 PM

    ASE 15.7 ESD#2 which is released in Aug 2012 supports maximum single ASE database of size 8TB ( for 2k logical page size server) or 64TB (for 16K page logical page size server).

    If you want it to confirm , please check in Rob's forum/blogs. Thanks.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 11, 2015 at 08:17 PM

    Greetings,

    The database size does not depend on the page size specified for the server.


    I believe that SAP no longer supports 32 bit version ASE servers, so, the page size depends only on the version of ASE that you are currently using. It is either 32 Terrabytes, or 64 Terrabytes, depending on wether you have a version of ASE < 15.7 or a version of ASE >= 15.7 .


    See.

    http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc32300.1600/doc/html/title.html

    Regards,

    Jean-Pierre

    Add comment
    10|10000 characters needed characters exceeded

    • Hello,


      This thread was initially about the maximum database size on SAP ASE.

      The maximum database size allowed does depend on the logical page size specified for the dataserver, you can find detailed information about this in the Configuration Guide (Database Specifications).

      Please note this thread has more than two years old, so please open a new thread if you'd like to start a new discussion on this or similar subject.

      Thanks

      Regards,

      Cris