Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Location
    Dubai
    Posts
    11

    Cool Unanswered: Invitation to all to discuss "sybase DB performance in 32 bit Vs 64 bit"

    Hi Greetings

    We are running sybase ASE 11.5 at present on HP 9000 D220 which is 32 bit .
    Our proposed new server is 64 bit (HP rp5470 with 2 processors) . And we are gonna install 12.5 on that server.

    How the performance is goona improve (if at all), and inviting DB experts to put there views on this topic , knowledgable discussions on this will help many people.

    Thanks in Advance
    Is

  2. #2
    Join Date
    Mar 2001
    Location
    Lexington, KY
    Posts
    606
    Simply 'upgrading' to a 64-bit version of the software should have little/no performance implications (e.g. you can run a 32 bit ASE on a 64 bit platform and compare performance).

    The performance implications are in the ability to use more memory and generally the better CPUs.

    ASE 12.5 has a lot of performance and other configuration changes which make it pretty easy to extract lots of performance from it -- or burn it to the ground if you're not careful. Read the release and migration docs extensively.

    One change which is huge is that you have to specify exactly the memory useage of the default cache (if I am remembering correctly). Otherwise it is tiny and people complain of horrible performance until they notice this.
    Thanks,

    Matt

  3. #3
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    Hiya,

    Here is a neat techdoc on the same;

    http://my.sybase.com/detail?id=1012280

    Cheers,

    Willy

Posting Permissions

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