Skip to Content
author's profile photo Former Member
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 a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 07, 2012 at 05:39 PM

    This message was moderated.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on 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 a 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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.