Performance in Production vs Quality

[Former Member]

Hi Experts,

I have seen a strange issue i.e. MB51 transaction is giving TIMEOUT  error in production system. The same transaction is able to display the results in quality. In both systems the overall no.of records is same which will be around 15lacs, SAP is wrote an innerjoin which is optimized as much as possible.

So in this case I would like to explore the configuration differences between the production system and quality system. I know it can be changed from organization to org, but sharing your experiences may find some kind of helpful answers for me.

As per my analysis in my issue the resources and speed which is given for SELECT in production is poorer than the quality.

Please correct me if im wrong and suggest the possibilities.

Thanks and Regards,

Bhaskar

[arivazhagan_sivasamy]

Hi,

Please create a Z program, that is copy of MB51.

Once execute the program, that goes to directly detail list instead of header and detail.

Then you can ask them run in background.

Arivazhagan S.

[Former Member]

Hi Siva,

Thanks for the reply.

We have tried to do it in the background also but things are not working in that way too.

Regards,

Bhaskar

[Former Member]

Hi Bhaskar,

Normally I would discuss this type of problem with a Basis or Performance team.

There could be many Basis or database settings that may affect the performance.  Additionally there are normally more things happening on the production system that are competing for resources than there would be in a Quality system.

Regards and good luck,

Steve

[Former Member]

Hey Steve,

Thats really helpful reply from you.

I would be glad if you can eloberate your comments on Basis and Database settings which are really impacting the data extraction through Select statements.

Awaiting for your reply,

Bhaskar

[arindam_m]

Hi,

If you know the SQL that is causing the issue can you check the ST05 SQL Query analysis of the same in two servers. Does the Execution plan of the SQL vary? I think the execution plan is different in Quality and Production.

Check each part of the execution plan. If its Oracle DB run RSANAORA to update DB stats sometimes this can impact how CBO chooses the execution plan of the SQL.

Cheers,

Arindam

[Former Member]

Hey Arindam,

I have tried with the trace, but as the transacion in production goes to dump, I am unable to record the SQL trace. Is there any other way to get this trace done even incase of dumps also.

Can you please tell me more about the execution plan, like any example criteria or any common settings and preferences ?

Thanks,

Bhaskar

[Former Member]

Hi Bhaskar,

As mentioned by Steve too, Basis is the best team to reach too.

Moreover if you suspect that resources are different in both the systems then go to transaction SM51 and check yourself.

BR.