Presumably bad performance of MaxDB (on BDLS, select,...)

[former_member214380]

Hello Helpers,

we are actually facing a perfomance issue with a MaxDB 7.9.08.017 on Windows 2008 R2 Server and a DB-Size of 780 GB. We were doing a system copy from PRD to QAS and everything went just fine - more or less 😉

One of the follow-up activities is running the BDLS (conversion of the logical system name) on this system. Starting this action on 02.05.2015 and checking the result on 04.05.2015 we were facing the issue that it had only reached the table GLPCA ans so leaving the rest of the letters in the alphabet still open.

We were doing some basic testing with a SELECT statement on the table catsdb on the source system PRD:

sql_execute SELECT COUNT(*) from sapprd.catsdb where MANDT = 010 and LOGSYS ='MAND010'

This took around 30 seconds to execute and deliver a value. Executing the same statement on the QAS system takes around 10 Minutes. We also created some indexes on big tables like GLPCA, COES, GLPCP and COEP to possibly speed up the process by parallelization of the BDLS... with no luck. Creating the index on COEP took about 30 minutes.

Both systems do not differ in hardware too much from each other. While the statement was running on the QAS system the CPU utilization was arountd 1-2% for the kernel.exe. The other 98/99% were on the idle process. Same with RAM: 11 GB of 16 GB are used.

We believe that there is some kind of bottleneck in the configuration somewhere. Unfortunately it is not obvious to us where to look for it.

We would greatly appreciate your help in this case 🙂

Regards

Daniel

[JamesZ · Accepted solution]

Hi Daniel,

Please check if the database parameters were set as per SAP note 1346964 firstly. If the parameters

were already correct, please raise a ticket for SAP, because it is difficult to do the performance analysis in this discussion.


If the performance is not correct, please adjust them as per the note.

Best regards,
James

[former_member214380 · Accepted solution]

Hey James,

now it looks like this was a direct hit from you. Select statement ist running through in about 45 seconds and the restarted BDLS is already at letter "C".

Thanks in advance! I will keep you updated here 🙂

Daniel

[former_member214380 · Accepted solution]

Runs great - Correct answer, thank you!

So remember: Check your parameters 😉