Database Server Perfomance when using DI-API
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.
Owen Slater replied
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.