Skip to Content
avatar image
Former Member

Database Server Perfomance when using DI-API

Hi,

My customer have 100 SBO users. Among of them, there have 40 users online at the same time. All of them run add-on which is using DI-API. I wonder that my add-on effected to performance of database server. My database server spec. is 4CPUs, 8GB RAM.

My server performance is very bad at the moment. Thank you for your advise.

Tin Le.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Aug 22, 2007 at 02:09 AM

    Hi,

    Firstly I think you would need to analyse why the server performance is poor (ie you'll need to establish what the bottleneck is: Disk I/O, memory or CPU). In my experience, disk I/O is more commonly the problem and not memory or processor power.

    The DI API on its own won't cause poor performance but a poorly designed addon could cause undue workload for the server. Of course, it also depends on what the addon does. If the functions the addon provides create a large number of reads and writes and the addon uses transactions a lot then this could well be a problem.

    SAP do provide a sizing guide but it's not particularly comprehensive and won't tell you how to size for a site that uses complex addons.

    Kind Regards,

    Owen

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 21, 2007 at 01:44 PM

    Is there a tool to size up the hardware requirements in SBO?

    Lets assume 800-1000 entry per day. How much RAM and CPU will be required ?

    Add comment
    10|10000 characters needed characters exceeded