Skip to Content
avatar image
Former Member

Sybase ASE 15.5

What is the maximum database size in 15.7 for 2K page server? Is it 8TB or 4TB?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Nov 01, 2015 at 03:52 AM

    Thanks Mark, It is very much clear.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Akhilesh,

      dbcc traceon(3604)

      go

      dbcc serverlimits

      go

      Will also give you your database size limits as well as other limits on the server.

  • Oct 31, 2015 at 06:59 PM

    15.5 and 15.7-pre-ESD#2 : size of database limited to 2billion pages * @@maxpagesize, so for 2KB max db size was 4TB; NOTE: 2billion => max signed int value

    From the ASE 15.5 Configuration Guide (UNIX) (pg 116):

    15.7 ESD#2+ : size of database limited to 4 billion pages * @@maxpagesize, so for 2KB max db size is now 8TB; NOTE: 4 billion => max unsigned int value

    From the ASE 15.7 ESD #2 New Features manual (p 59):


    pastedImage_4.png (21.5 kB)
    pastedImage_0.png (15.7 kB)
    Add comment
    10|10000 characters needed characters exceeded