Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2005
    Posts
    7

    Lightbulb Unanswered: How much ram Sybase 12.0 on Solaris 8 can handle ?

    We have two Sun E420 currently with 4GB ram(memory) & going to upgrade our servers to Sun Fire V490 with 8GB ram(memory).

    The machine would have Sybase 12.0 with solaris 2.8.

    We would like to know what limitations there may be (if any) on Sybase ability to use this additional memory. What is the maximum memory which can be allocated to the database instance in each case ?

    e.g. - Are Solaris 8, and Sybase 12.0 32 bit ? If so does this mean there is a limit of 4GB on addressable memory ?

  2. #2
    Join Date
    Sep 2005
    Location
    France, Paris
    Posts
    34
    Hello,

    HERE is your answer.
    To know if your dataserver is 32 or 64bits run:
    select @@version at isql prompt or dataserver -v at unix prompt.
    Regards.

  3. #3
    Join Date
    Oct 2005
    Posts
    7

    Lightbulb Our main concern is with memory handeling and CPU

    We would like to know what limitations there may be (if any) on Sybase ability to use this additional memory. What is the maximum memory which can be allocated to the database instance ?

    Also, Sun fire have Hyper-thread CPUs will the O/S and database (Sybase) view the proposed system as a true 4 CPU platform?

  4. #4
    Join Date
    Sep 2005
    Location
    France, Paris
    Posts
    34
    Hello,

    Quote Originally Posted by amitabh_kaushal
    We would like to know what limitations there may be (if any) on Sybase ability to use this additional memory. What is the maximum memory which can be allocated to the database instance ?
    The answer is in the document linked in the previous post...
    You can clearly see that ASE 12 32bits on solaris 8 (sparc processor) cannot handle more than 3.78 GB. if you have ASE 12 64bits you can handle 16 Exabytes (theorical maximum)


    Quote Originally Posted by amitabh_kaushal
    Also, Sun fire have Hyper-thread CPUs will the O/S and database (Sybase) view the proposed system as a true 4 CPU platform?
    I'm not aware about Hyper-thread technology but if you can see 4 CPU on unix side (using top for instance) you can setup 4 engines with sybase. (1 engine per cpu)

    Hope this help.
    Regards.

  5. #5
    Join Date
    Oct 2005
    Posts
    7

    Cool Thanks !

    Hi jflebon,
    Thanks a lot for your help and valuable time :-)

Posting Permissions

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