Skip to Content

Poor performance in productive system

Hi experts.

At november 2014 we have migrate our platform from iSeries/DB2_400 to Wintel/ASE. The new server has 16 CPU, 64 GB RAM and flash disk.

The first months the performance of the system was fantastic, but since the 3th or 4th month it slow down more and more until now, when the performance is very very poor.

We have check lots of parameters, update ASE and kernel to the last version (kernel 7.02 SP500, ASE 15.7.0.133) but the problem persists. The only thing we can see at the dbacockpit is that from time to time there is a very poor performance at the I/O devices. Attached I send you an screenshot about that times. Can anybody sujects what can be the problem?.

IOTimes.jpg (161.1 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    Posted on May 18, 2015 at 11:05 AM

    Francisco,

    Kindly provide me the below 2 outputs during the peak time when you are finding this performance issues:

    1>sp_monitorconfig "all"

    2>go

    and

    1>sp_sysmon "00:05:00"

    2>go

    Regards

    Kiran K Adharapuram

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 18, 2015 at 12:41 PM

    HI,

    Do you have any errors in your database log file?

    /sybase/SID/ASE-15_/install/SID.log ?


    Kind Regards,


    J

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 18, 2015 at 11:44 AM

    Hi Franscisco,

    Check your parameter seems fully utilized.

    number of open partitions144998699.97500000

    SyBooks Online (Archive)

    Kind Regards,

    Johan

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 18, 2015 at 12:00 PM

    HI,


    If you can output to file you can attach, click on use advanced editor option when you reply on the message then you can attach as file.

    Set your CMD scrollback large enough and then copy to text file to attach.

    Johan

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 18, 2015 at 12:06 PM

    HI,

    Just a silly question do you have db statistics job running?

    Kind Regards,

    Johan

    Add a comment
    10|10000 characters needed characters exceeded

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.