cancel
Showing results for 
Search instead for 
Did you mean: 

Performance Issue

Former Member
0 Kudos

Dear All,

We have the SAP 4.7 EE PRD server on MS SQL Server 2000 on win2003 with SP1 with 4 GB of RAM.

Virtual Memory 12 GB

We have recently increased the dialogue work process form 10 to 18 as the DIA response was very slow. We have increase the Spool/BG/UPD/UPD2 tentatively. On the whole we currently have 32 work process.

We have increased the follwing parameters after increasing the Dialogue work process

em/initial_size_MB current value 2229 increased it to 50% = 3343

abap/buffersize current value 275000, Increased it to 50%

zcsa/presentation_buffer_area 4400000 Bytes Increased it to 50%

The following are the memory parameter values:-

Roll, extended and heap memory EXTM

ztta/roll_area 2000000 Byte Roll area per workprocess (total)

ztta/roll_first 1 Byte First amount of roll area used in a dialog WP

ztta/short_area 3200000 Byte Short area per workprocess

rdisp/ROLL_SHM 32768 8 kB Part of roll file in shared memory

rdisp/PG_SHM 16384 8 kB Part of paging file in shared memory

rdisp/PG_LOCAL 150 8 kB Paging buffer per workprocess

em/initial_size_MB 3343 MB Initial size of extended memory

em/blocksize_KB 1024 kB Size of one extended memory block

em/address_space_MB 512 MB Address space reserved for ext. mem. (NT only)

ztta/roll_extension 2000000000 Byte Max. extended mem. per session (external mode)

abap/heap_area_dia 2000000000 Byte Max. heap memory for dialog workprocesses

abap/heap_area_nondia 2000000000 Byte Max. heap memory for non-dialog workprocesses

abap/heap_area_total 2000000000 Byte Max. usable heap memory

abap/heaplimit 40000000 Byte Workprocess restart limit of heap memory

abap/use_paging 0 Paging for flat tables used (1) or not (0)

Issues:-

We see that the work process status are in "Stopped" status frequently.

The System Performance is very Low

The Disk Utilization is very high (100%)

Please advice in increasing the above parameter values.

Best regards.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

The System Performance is very Low

The Disk Utilization is very high (100%)

Please advice in increasing the above parameter values.

In my opinion you are attacking the error from the wrong perspective, If you see 100% disk utilization very often even if you put 50 Dialog, 20 Background ,etc the problem will still be there.

Remember that SAP runs using a RDBMS and that is the heart of the system, even if you have 200Gb of RAM for 10 users but the disks or the DB tunning are not up to the task then the problem won´t be fixed adding more RAM, it will be fixed in the DB or Disk I/O size.

First try to look at the Disk I/O and use ST03N to see where is the problem DB, Workprocess, etc if you are not sure about what to look for, then talk to your DB admin and look for missing index, HW problems, missing statistics, etc. Basically look the reason why disk utilization is taking 100% so often.

Could you give us Hit ratio from ST02? or look for hit rations lower than 98%? Could you tell what is the hit ratio for DB?

I assume your server is on 32Bits, how many users enter the system concurrently?

Take a look at this notes : 521750 948066

Edited by: AC on Dec 15, 2008 7:33 PM

Edited by: AC on Dec 15, 2008 9:07 PM

Former Member
0 Kudos

Dear AC,

The production server is on win 2003 SP1 with 32 Bit. The Hit Ration in ST02 is above 98%. There is no DB person available here.

We see in ST03N that DB Response time and DB utilization is very High. The DB is on MS SQL 2000. We have performed DB Check in DB13. We see the following error message in DB13

DBCC CHECKDB (PRD) finished at Dec 13 2008 2:43PM

Job 'SAP CCMS Check Database PRD [20081213170346]' : Step 1, 'Step1' : Began Executing 2008-12-13 20:00:00

DBCC CHECKDB (PRD) started at Dec 13 2008 8:00PM with Logfile: C:\Program Files\Microsoft SQL Server\MSSQL\CCMS_CHECK_DB_HIST_2008.txt [SQLSTATE 01000]

-


Microsoft SQL Server 2000 - 8.00.2040 (Intel X86)

May 13 2005 18:33:17

Copyright (c) 1988-2003 Microsoft Corporation

Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

Msg 8928, Sev 16: Object ID 668906546, index ID 0: Page (4:1536478) could not be processed. See other errors for details. [SQLSTATE 42000]

Msg 8939, Sev 16: Table error: Object ID 668906546, index ID 0, page (4:1536478). Test (IS_ON (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057 and -1. [SQLSTATE 42000]

Msg 8928, Sev 16: Object ID 764906888, index ID 0: Page (1:1626010) could not be processed. See other errors for details. [SQLSTATE 42000]

Msg 8939, Sev 16: Table error: Object ID 764906888, index ID 0, page (1:1626010). Test (IS_ON (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057 and -1. [SQLSTATE 42000]

Msg 8990, Sev 16: CHECKDB found 0 allocation errors and 2 consistency errors in table 'prd.TBTCO' (object ID 668906546). [SQLSTATE 01000]

Msg 8990, Sev 16: CHECKDB found 0 allocation errors and 2 consistency errors in table 'prd.TBTCP' (object ID 764906888). [SQLSTATE 01000]

Msg 8989, Sev 16: CHECKDB found 0 allocation errors and 4 consistency errors in database 'PRD'. [SQLSTATE 01000]

Msg 8958, Sev 16: repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (PRD ). [SQLSTATE 01000]

-


DBCC CHECKDB (PRD) finished at Dec 13 2008 9:44PM

Kindly advice us as what steps need to be perfomed for DB tuning and performance increase.

Regards

former_member204746
Active Contributor
0 Kudos

check SAP note 88416. you can enable ZAMM by setting PHYS_MEMSIZE and delete other memory-realted parameters.

also, have you enabled /3GB and /PAE in boot.ini ?