Database Server Perfomance when using DI-API

[Former Member]

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.

[former_member201110 · Accepted solution]

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

[Former Member · Accepted solution]

Hi Owen,

Would appreaciate if you can provide the link to the sizing tool.

KC

[Former Member]

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 ?