cancel
Showing results for 
Search instead for 
Did you mean: 

SAP CRM Performance

Detelin_Nedev
Explorer
0 Kudos

Hello SAP Performance Experts,

What is your opinion of SAP CRM system performance? Do you have an experience with slow systems?

What is normal value of the average dialog response times you have in your systems in ST03?

What is the normal value you have for Logical Reads / User Calls in ST04?

We would like to compare with our system, because we have complains from the end users.

Best regards,

Detelin

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Detelin,

Dialog response time is around 1500 - 2000 ms and Log.Reads/User Calls is something around 50, on our CRM system. Most of the time is spending on inbound and outbound message processing. Actually, it depens what components you are running on CRM system, such as BI, WEBCUIF and so on...

What about your numbers? At the first stage make sure what component is causing the performance problem? SAPGUI or CRM WebUI. This is, because if they are complaining on WebUI, you can find the notes, below;

Note 1162685 - SAP CRM Webclient Performance

Note 1162605 - Network performance for CRM (IC) Webclient

Best regards,

Orkun Gedik

Detelin_Nedev
Explorer
0 Kudos

Hi Orkun,

In our system we have:

average dialog response time - around 1300 ms up to 1800 ms in some days.

Log.Reads/User Calls is now 75 and we are trying to find the expensive SQL in order to reduce to 20 as it is recommended by SAP, however I am wondering is it possible into CRM environment.

We do not use CRM WebUI and access the system via SAPGUI.

Best regards,

Detelin

former_member524429
Active Contributor
0 Kudos

Dear Detelin,

Average dialog response time - around 1300 ms up to 1800 ms in some days.

The well -tuned SAP system without expensive SQL statements should shows Average Dialog Response time less than or equal to 1000 ms.

If your SAP system is showing High Dialog Response Time, then there is something wrong in the execution at Application Server Level or at Database Level. Dialog Response time is only measured at Application server & DB level. It does not include any GUI time/ network time in calculation unless GUI time is showing very high values.

Log.Reads/User Calls is now 75

Your SAP system is showing very high value. The recommended value of Log.Reads/User Calls should not be more than 30. If its showing above 30, then definitely your SAP system is having very Expensive SQL statements in execution.

Please keep this in mind,

Performance Optimization is Ongoing Activity. You can not complete it within one hour/day. It is joint efforts of BASIS+ ABAP + Responsible Functional Consultants.

To initiate, I would recommend you to keep watch on SM50/SM66 and catch those statements which are showing continues action as "sequential reads" for long durations on target table. You can catch such running sessions by using Process ID at ST04 -> Performance ->Wait Event Analysis -> Session Monitor. Prepare a list of such expensive SQL statements which are showing high CPU costs/ IO costs on so and so Table/Indexes and Try to evaluate them with ABAPers & Concerned Functional Consultant for possible tuning.

Also you can get information about all expensive SQL statements under ST04 -> Performance -> SQL Statement Analysis - >Shred Cursor Cache. Take Top 10 SQL statements based on "Disk reads" / "Buffer Gets" / Executions and evaluate its execution plan for possible tuning.

If you attend training on SAP Performance tuning/ ABAP workload analysis  (ADM315), then it will beneficial you more with proper direction of tuning.

I hope the above information will be helpful to you.

--

Regards,

Bhavik G Shroff

Former Member
0 Kudos

Hi Detelin,

Including check the reference values by SAP, I suggest you generate Early Watch Alert report on SOLMAN for the CRM system. It will be good start to create a road map and identify bottlenecks on the system.

Best regards,

Orkun Gedik

Detelin_Nedev
Explorer
0 Kudos

Hi Orkun,

Thank you very much for your sugesstions!

Actually, the EWA generation is in plase in our SOL system since some years.

However, we do not find them very useful, because they are generaated at the early morning at 04:07 CET and it is not a very representative extract from the DB buffer cache.

The main load in our CRM system is during the day.

We are trying to change the time when this an extract is generated.

On the other side this is not a suggestion of a solution rather than it is a proposal what to check.

I dont  escape from the task to analyse the possibly "expensive" SQL but I am trying to find a hint, i.e. real analysis of the system, something like (the hint ... could be useful, a index would be useful, a join with leading ... table is desirfed, etc.).

Best regrads,

Detelin

Detelin_Nedev
Explorer
0 Kudos

Dear Bhavik,

Yes, our target is less than 1000 ms, but it is not our case at the moment.

I know the recommendations from SAP are for Log.Reads/User Calls even to be less that 20 in OLAP systems, but I would like to check if there is something specific for the CRM systems.

This is the reason I am trying to find an information about the CRM specific.

In any case your recommendations are very useful and I will take them into account.

Thank you very much,

Detelin