on 12-15-2008 10:13 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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 ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.