SAP CRM General Administration + Performance Tuning - BASIS Consultants

[Former Member]

Below are few of my learnings

1. Operating System

2. Database

3. Application

4. Middleware

5. SAP BASIS Daily monitoring and checks

6. Oracle Advanced level Compression

Operating system referred to below is of HP UX and Database is Oracle.

OS level Parameters

HP-UX 11.31 Itanium and PA-RISC (HP-UX 11iv3)

1. Ensure you follow the OSS note.

SAP on HP-UX: OS Kernel Parameter Recommendations (SAP Note 172747)

2. Size the SGA based on the capacity (CPU and RAM) on Database servers

Oracle 11g - 1431798 - Oracle 11.2.0: Database Parameter Settings

Database SGA

SGA Max size                         

Shared pool size                 

DB Cache size                      

Log buffer                             

Db writer processes              

Redo log size                        

3. Application level parameters :

Schedule a SAP Technical Performance Optimization Service on solution manager and based on the report change the below parameters.

ICM Parameters

icm/traffic_control                                                             

icm/max_sockets                                                              

icm/max_conn                                                   

icm/server_port_1                                             

icm/server_port_2                                             

icm/HTTP/server_cache_0/max_entries      

icm/HTTP/server_cache_0/memory_size_MB           

icm/HTTP/server_cache_0/size_MB                             

icm/min_threads                                               

icm/host_name_full                                          

icm/server_port_0                                           

icm/keep_alive_timeout                                  

mpi/total_size_MB                                       

Buffers

rsdb/ntab/entrycount

rsdb/ntab/ftabsize

rsdb/ntab/sntabsize

ztta/parameter_area

ztta/roll_area

rdisp/ROLL_SHM

rdisp/ROLL_MAXFS

rdisp/PG_MAXFS

abap/heap_area_dia

abap/heap_area_nondia

abap/heap_area_total

ztta/roll_extension

rdisp/wp_ca_blk_no

rdisp/appc_ca_blk_no

abap/buffersize

rsdb/cua/buffersize

rsdb/ntab/irbdsize

rsdb/obj/buffersize

rsdb/obj/mutex_n

rsdb/obj/large_object_size

rsdb/obj/max_objects

rtbb/max_tables

rtbb/buffer_length

sap/bufdir_entries

zcsa/db_max_buftab

zcsa/presentation_buffer_area

zcsa/table_buffer_area

rsdb/esm/large_object_size

rsdb/esm/max_objects

rsdb/esm/buffersize_kb

rsdb/otr/mutex_n

rsdb/otr/max_objects

rsdb/otr/buffersize_kb

abap/heaplimit

em/blocksize_KB

ict/exclude_compression                                *.zip,*.rar,*.arj,*.z,*.gz,*.tar,*.lzh,*.cab,*.hqx,*.ace,*.jar,*.ear,*.war,*.gzip,*.uue

Daily Monitoring

Daily Checks

Database overview                                             DB02/DBACOCKPIT

Table space maintenance                                 DBACOCKPIT/BRTOOLS

Correcting ST22 dumps & SM21 errors          ST22/SM21

File system monitoring                                       DBACOCKPIT/OS level

Jobs Monitoring                                                   SM37

Creating missing indexes                                  DBACOCKPIT

Work Load Analysis                                            ST03

Database Alerts Check                                      ST04

Check TemSe Status                                          SP12

Check Spool Output Requests for Errors        SP01

Backup Log Overview                                        DB12

Database Locks Check                                      DB01

Backup Calendar                                                                DB13

SMLG                                                                     SMLG

Transport Management System                       STMS

ICM Status                                                            SMICM

Overview of Send Orders                                  SOST

Work Process Status                                           SM50

Running Jobs Status across all systems        SM66

SAP Server / Work Process Status                   SM51

Check Lock Entries                                             SM12

Update Requests List                                         SM13

Dump Analysis                                                    ST22

Operating System and FS Check                     ST06

System Log Analysis                                          SM21

Buffer Analysis and Status                                ST02

CRM Checks

CRM Middleware Monitoring Cockpit              SMWP

Analyze Object and Sub Object logs               SLG1

qRFC Outbound Queue Monitor                       SMQ1 or SMWP or  RZ20

QOUT Scheduler                                                                 SMQS

qRFC Inbound Queue monitor                         SMQ2

QIN Scheduler Status                                         SMQR or SMWP or RZ20

Message Flow Statistics                                     SMWMFLOW

BDoc Messages/Summary                                               SMW01/ SMW02/ SMW02A/ SMW03

Check Flow Definitions                                      SMO8FD

Monitor Load Status                                            R3AM1 or SMWP

Monitor Request                                                  R3AR3 or SMWP

Replication objects                                              SMOEAC

Check Object Types from Admin Console     SMOECK

Status of generation processes                        GENSTATUS

Trace Status                                                         SMWTAD

Housekeeping

General Housekeeping

SAP_REORG_JOBS

SAP_REORG_SPOOL

SAP_REORG_BATCHINPUT

SAP_REORG_ABAPDUMPS

SAP_REORG_JOBSTATISTIC

SAP_REORG_UPDATERECORDS

SAP_COLLECTOR_FOR_JOBSTATISTIC

SAP_COLLECTOR_FOR_PERFMONITOR

SAP_COLLECTOR_FOR_NONE_R3_STAT

SAP_REORG_PRIPARAMS

SAP_REORG_XMILOG

SAP_CCMS_MONI_BATCH_STARTUP_DP

SAP_SPOOL_CONSISTENCY_CHECK

SAP_REORG_ORPHANED_JOBLOGS

SAP_CHECK_ACTIVE_JOBS

SAP_DELETE_ORPHANED_IVARIS

SAP_REORG_ORPHANED_TEMSE_FILES

DBA:CLEANUPLOGS

DBA:UPDATESTATS

DBA:CHECKDB

CRM Specific

SAP_REORG_CRM_PRODUCTS_INACTIV

SAP_SOA_ARCHIVE_PLAN

SAP_SOA_DELETE_HISTORY

SAP_SOA_DELETE_MESSAGES

SAP_SOA_TABLE_SWITCH

SAP_SOAP_RUNTIME_MANAGEMENT

ZCRM_ICI_TRACE_DELETE

ZRESTART_INBOUND

SMWP_BATCH/MW_S_COCKPIT_COLLECTOR_DWY

GN_GENERATE_CHECK/MW_S_CHECK_P_DWY

GN_WORKLIST_GENERATE/MW_S_GENERATE_P_DWY

SMO6_REORG2/MW_S_SMO6_REORG2_DWY

RSRLDREL

RSRLDREL - Object Links

BSP_CLEAN_UP_SERVER_COOKIES

HRBCI_ATTRIBUTES_BUFFER_UPDATE

Application Log Size (BALHDR)

System-wide performance can be impacted due to the large size of the application log tables, BALHDR etc. Reduce the number of entries in table BALHDR on a regular basis. Use transaction SLG2 to delete entries out of table BALHDR as described in SAP Note 195157.

Middleware tables SMW*_BDOC* can grow very large

Depending on the load of your trace or middleware log, tables can grow larger than 100 MB. Consequently, it can often be observed that expensive insert and read operations take place on the SMW3_BDOC* tables. Take administrative actions to reduce the size of the tables according to SAP Note 206439. Only increase the trace level if necessary.

Furthermore SAP Note 835761 has to be implemented to remove the BDocs in status I04.

Schedule report SMO6_REORG2 on a daily basis.

If the table SRRELROLES contains many entries with the OBJTYPE TRANSID consider the SAP Note 1385766 to reduce them. If the table SRRELROLES contains too many entries with the OBJTYPE BUS* you have remove them by archiving the corresponding objects using the transaction SARA.

MIME Repository consistency check:

After each SP import, execute the report RSIR_MIME_EXPIRY_CLEANUP on node /SAP in order to avoid repetitive download of static mime objects from the server that otherwise may be stored in the browser’s cache. Make sure Z-style sheets have at least 1 week caching time defined in the P-System.

CRM Middleware (CRM MW) Alert Monitor

Based on the SAP CCMS alert monitoring infrastructure Use transaction RZ20. This is available under the monitor collection “SAP CRM Monitor Templates” with the name CRM Middleware.

The CRM MW Alert Monitor monitors the following:

CRM MW-specific qRFC queues in SAP CRM system

CRM MW-specific qRFC queues in SAP ERP back-end system

The qRFC QIN scheduler of the SAP CRM system

The qRFC QOUT scheduler of the SAP CRM system

The processing status of messages in the BDoc message

The replication and realignment queues and the R&R queue demon

Status of the Communication Station

Enqueue Server shows slow performance –

We can go ahead and set the profile parameters .

1.       Note : 1353668 - Locks are retained due to network instabilities

2.       Set the instance profile parameter in the ABAP application server:

3.       enque/sync_dequeall = 1.

4.       Also set the following parameter in the standalone enqueue server:

5.       enque/encni/set_so_keepalive = TRUE

Follow the recommendations in SAP Note 1791958 to reduce the lock time on table VARINUM and avoid scheduling several background jobs simultaneously for the same program. Correction is not delivered in a Support Package. If required, you can implement the attached correction in the note.

Application log is too large

Should delete the obsolete entries. Need business decision to delete these entries (specially on the time – from which date can we go ahead and delete the entries).

Rebuilding the indexes – Run report RSORATD and check for the index storage quality and based on the requirement we can rebuild the indexes.

Please note that this report is very time and cpu consuming. So need to discuss on when we can run this report.

No reorg job scheduled to reduce size of tables SRRELROLES

706478 - Preventing Basis tables from increasing considerably

Growth of CRM_ICI_TRACES can slow IC

1712755 - Large ICI trace log affect the performance of IC function

It is recommended to keep the ICI trace log in a small size.

Delete the ICI trace on a regular basis.

To do this, you need to run program CRM_ICI_TRACE_DELETE to delete the old ICI trace log regularly.

By default, the program is pre-set to delete the ICI trace record log older than 14 days. You may set up your own delete trace age option according to the speed of the log growing in your system.

CRM WebClient performance related settings

Clear the inconsistent MIME objects. Refer to SAP Note 1277476 to clear out the inconsistent Mime objects and make the caching sufficient.

Adjust ICI trace parameter settings and remove out-of-date traces. Follow SAP Note 1712755 to adjust ICI trace settings and remove redundant ICI traces to improve the CTI integration performance.

To prevent a deadlock for IDoc update in parallel, you must configure at least number of dialog work processes >= n + rdisp/rfc_min_wait_dia_wp +1. Refer to SAP Note 565527 -Deadlock when using local update (IDocs). To avoid system hanging due to tRFC cascade, set rdisp/rfc_min_wait_dia_wp parameter >= 66% *(total number of DIA processes) per instance, refer to SAP Note 726148 -SAPLARFC occupies all work processes, RFC cascade.

Fragmented indexes

Based on the results of the Oracle Automatic Segment Advisor

(SQL: "Space_SegmentFragmentation_SegmentAdvisor"),the following indexes have allocated more than 100 MB of unused space and their storage quality is <= 50 %.

Rebuild the mentioned indexes as suggested by Oracle database in order to reduce fragmentation, and also regularly check for fragmented indexes. See SAP Note 771929 for more information regarding index fragmentation.

Database statistics for RFC-related tables

The statistics for RFC related Tables (ARFC*, TRFC*, etc.) are still generated through the standard BRCONNECT functionality. When the load is heavy and the RFC tables are inserted and deleted, the Cost Based Optimizer of Oracle may use the wrong access path. The transaction then takes a long time to execute.

Impact:

The Cost based Optimizer of Oracle may choose a sub optimal access path, resulting in expensive database access.

Recommended Task:

Follow the instructions of SAP Note 1020260 to generate the appropriate statistics.

ICM cache Configuration

Description:

The time recorded in Http Watch trace is longer than the time recorded in ST12 trace, which indicates that there is a lot of time spent on ICM.

The ICM cache was with default setting and was not tuned.Impact on Business:It will negatively affect the performance for HTTP request from BSP page to CRM backend.

Recommended Task:

Tune the following parameters as recommended.

Set icm/HTTP/server_cache_0/size_MB to 0 to disable the disk-level cache

Set icm/HTTP/server_cache_0/memory_size_MB to 1792

Set icm/HTTP/server_cache_0/max_entries to 25000

Refer the following documentation for more details: http://help.sap.com/saphelp_nw70ehp1/helpdata/en/48/405cbfca2331c3e10000000a42189d/frameset.htm

Please follow the sections from the SAP CRM Consultants Cook book.

http://scn.sap.com/docs/DOC-36041

Oracle Advanced level Compression

Compression for OLTP and OLAP.

Please refer to the below notes.

SAP note 740897 (Info about the Oracle license scope), Advanced Compression is an option contained in the Oracle database license offered by SAP

1289494 - FAQ Oracle compression

1436352 - Oracle Database 11g Advanced compression for SAP Systems.

Thanks for reading...

Ravi