Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.

Former Member
replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question