Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2001
    Location
    South Africa
    Posts
    33

    Unanswered: ase performance problem

    I have 2 sun boxes E450's same spec 512MB ram and 400MHz cpus (2)

    On the one I have:
    Adaptive Server Enterprise/11.9.3/64bit/1193/P/SWR 8647 ESD 3/Sun_svr4/OS 5.7/FBO/Sat Sep 25 00:46:43 1999

    and the other:
    Adaptive Server Enterprise/12.5/SWR 9610 GA/P/Sun_svr4/OS 5.8/main/1647/64-bit/FBO/Sat Jun 2 01:55:25 2001

    The 11.9.3 and 12.5 are setup exactly the same - wherever possible.
    BUT the 11.9.3 runs WAY faster with queries and inserts and updates -

    Can someone please explain this to me ??
    Maybe suggest something to improve the 12.5 server ??

    THANKS

  2. #2
    Join Date
    Apr 2003
    Posts
    5

    Re: ase performance problem

    Hi tag
    Have you tune "default data cache" values,that default values is 8M.
    Originally posted by tag
    I have 2 sun boxes E450's same spec 512MB ram and 400MHz cpus (2)

    On the one I have:
    Adaptive Server Enterprise/11.9.3/64bit/1193/P/SWR 8647 ESD 3/Sun_svr4/OS 5.7/FBO/Sat Sep 25 00:46:43 1999

    and the other:
    Adaptive Server Enterprise/12.5/SWR 9610 GA/P/Sun_svr4/OS 5.8/main/1647/64-bit/FBO/Sat Jun 2 01:55:25 2001

    The 11.9.3 and 12.5 are setup exactly the same - wherever possible.
    BUT the 11.9.3 runs WAY faster with queries and inserts and updates -

    Can someone please explain this to me ??
    Maybe suggest something to improve the 12.5 server ??

    THANKS

  3. #3
    Join Date
    Apr 2003
    Posts
    2
    Update statistics.

  4. #4
    Join Date
    Sep 2002
    Location
    Hong Kong
    Posts
    159

    Re: ase performance problem

    Procedure cache is now allocated as a fixed amount and may need to(probably should) be changed from the default.

    Join the club. I've seen a number of 12.5 newbies with slow ASEs because of the way ASE ships with it's default settings. Including one organisation that said ASE 12.5 was slower than ASA!

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

    Unlike ASA, ASE is extremely parameter sensitive.

    I could ponder all day and then realize that the slow performance on a bigger, meater machine was due to someone forgot to turn on "Fast Write Cache" at the operating system level.

    Doh!!!

    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
  •