month-end closing performance issue

[Former Member]

Dear Experts,

     We have met the serious performance issue during month-end closing. It takes more than 48 hours to run CON2 and 30 hour to run CO88. However, there is no any performance issue at the daily system operation. Our basis engineer collects the system information as below:

     SAP component version: EHP4 FOR SAP ERP 6.0 / NW7.01

      Operation system: AIX

      Database: DB6

      DB version: 09.01.0009

     We have only one server for our production system. This server plays both roles as database server and application server.

     During month-end closing, the status of system as following:

     CPU     User%     Kern%     Wait%     Idle%

     ALL        9.7          0.7          10.9         78.6

     Network     KBPS     I-Pack     O-Pack     KB-In     KB-Out

     Total          1379.7     1954.1     1723.8     690.3     689.3

     Disk          Busy%     KBPS     TPS     KB-Read     KB-Write

     Total          100%       16.5K     1015.0     16.5K        12.0

     FileSystem     KBPS     TPS     KB-Read     KB-Write

     Total               16.5K     1.1K     16.5K          12.0

     SAP Memory     Curr.Use %     CurUse[KB]     MaxUse[KB]     In Mem[KB]

     Roll area          10.02               26,261               29,720               131,072

     Page area          1.75               28,028           1,599,992            1,120,000

     Extended mem   0.72          1,921,024           8,384,512         268,435,456

     Heap mem                                      0                       0             2,779,384

     Our basis engineer also collect top 5 tables as following. The total size of database is 686,260,352.

     Table name          Size

     COSS         123,019,562

     COEP           59,508,832

     RESB             6,593,504

     MSEG            4,800,640

     AFRU             3,621,568

     Can anybody tell me what we can do to improve our month-end closing performance? No matter which kind of solutions. Thanks in advance.

[Sriram2009]

Hi Felix

1,

    During month-end closing, the status of system as following:
     CPU     User%     Kern%     Wait%     Idle%
     ALL        9.7          0.7          10.9         78.6

     Network     KBPS     I-Pack     O-Pack     KB-In     KB-Out
     Total          1379.7     1954.1     1723.8     690.3     689.3

     Disk          Busy%     KBPS     TPS     KB-Read     KB-Write
     Total          100%       16.5K     1015.0     16.5K        12.0

     FileSystem     KBPS     TPS     KB-Read     KB-Write
     Total               16.5K     1.1K     16.5K          12.0

     SAP Memory     Curr.Use %     CurUse[KB]     MaxUse[KB]     In Mem[KB]
     Roll area          10.02               26,261               29,720               131,072
     Page area          1.75               28,028           1,599,992            1,120,000
     Extended mem   0.72          1,921,024           8,384,512         268,435,456
     Heap mem                                      0                       0             2,779,384

As per the data disk usage 100 %, because of this CPU & Memory usage very less during the month end. You have to check the SAN storage connectivity, You have to contact SAN admin team, or Raise the support ticket to SAP they may guide you in the right way.

You can also check the OS & SAP log any error about the SAN disk using the transaction ST06/ST06N & SM21

Check the Memory parameters based on AIX system. refer the SAP Note 1972803 - SAP on AIX: Recommendations

2. During the month end are you getting any dumps in transaction code con2 & co88? If it is yes, Pls share the full dump?  Have you size the SAP system based on your number of users?

3. In production system you can enable the trace on con2 & co88 using the transaction code ST12  check over the performance during off peak & Month end times with help of ABAPer you can check the over all the transaction performance.

Regards

SS

[Former Member]

Dear Sriram,

Sorry to reply you so late.

1. As our Basis engineer said, the memory parameters has set based on SAP recommendation. For the SAN storage connectivity, we are still waiting our subcontract service provider's examination.

2. I have checked the background job of transaction code CON2 and CO88, and there is no any dumps founded.

3. I can't find transaction code ST12 in system. Is it possible that our system version do not support this t-code?

Our Basis engineer think this performance issue may be caused by database version is too low. I am not familiar with database, do you think database version is the main reason of this performance issue?

Thanks for your suggestion.

Best regards,

Felix Mao

[Former Member]

Hi Felix,

Apart from what sriram mentioned you can try below things.

1. Index rebuild for the tables mentioned by you and for this you may need to run ST05 sql trace.

2. Run ST12 analysis ( it should be in your system as it EHP4 FOR SAP ERP 6.0 / NW7.01)

3. Run CBO stats for the table with sampling 1%

4. Are there any other jobs which are impacting the CON2 and CO88 --> you may need to check with your functional guys for same.

Also for the SAN & Disk usages --> do verify is there any replications schedule during that window which may cause a high disk utilizations. you may consider it suspending it for month end closing window or allow minimum bandwidth for it.

Regards,

Ram

[Sriram2009]

Hi Felix

Transaction code ST12 is very much avaible in SAP ERP system. When you are executing the transaction ST12, Are you getting any warning or error message?

Regards

SS