1. SAP is saying your I/O is dodgy. So first look in RZ20 - Monitor templates - database.... and under there is the disk performance for both DB and logs... These should be 5ms or less... 20MS and you need to shoot your SAN boys.
2. There are a lot of areas that can be improved and there is an awful lot to look at. First you need to understand if you have a general performance problem. Go to RZ20- monitoring templates - dialog overview and find the standard dialog response times. Select all servers via left check box and then click the button that looks like 2 pieces of joined jigsaw... page down an you will see some 5 minute and hourly figures. If these values are all the same/or close it means your system is running stably at the same speed. If this value is higher than about 10-12 ms it can be improved with tuning and then we run through what can be done.
One final comment.... 4GB or RAM and loads of WP's... makes me wonder about version of SAP & Windows (SE,EE?)... just how many CPU's are servicing these poor 4GB servers and what is your page-in rate (for that matter your page out rate as ther is a bug in this area). There is a million things and having worked for SAP I would like to point out you are likely being serviced by someone with 0-2 years experience who runs some scripts.
I am guessing but gut feel says you have disk and CPU and RAM issues and it is likely your customer is not going to be keen on forking out to fix them so all we can do in this case is assess reduction and spread of workload.
---------------Original Message---------------
From: sambzz
Sent: Wednesday, September 29, 2010 1:55 AM
Subject: SAP performance issue
> Hi Experts,
>
> We are having 5 Dialog servers and central instance with logon load configuration
> (2 logon groups configured).
>
> Sap users around 250 to 300 (from different networks) SAP will be slow when users doing billing or reports like that.
>
> Billing will be of top priority and very important. But, SAP will be slow while billing period.
>
> * SAP users will be accessing same T-codes (SAP tables to read and write)
> Vf01, Vl01n, vl02n, miro, vf02 (all billing related T-codes and reports)
>
> * SAP users will be complaining that their response times is very very HIGH.
>
> * More sequential reads happening (work process status). Is it related to DB access time?
>
> • Will archiving improve the DB response time?
>
> Configuration
>
> Sap version 4.7 Enterprise, MSSQL 2000 with DBsize 320GB
>
>
> Central Instance : 8 GB RAM 14 (6 DIA, 2 UPD, ***1*ENQ** , 2BGD, 2SPO, 1 UP2)
>
> Application/Dialog server:
> App server 1 : 4GB RAM total 27 WP (15 DIA, 4 UPD,3 BGD, 3 SPO, 2 UP2)
> App server 2 : 4GB RAM total 28 WP (16 DIA, 4 UPD,3 BGD, 3 SPO, 2 UP2)
> App server 3 : 8GB RAM (Paging memory has been reduced ) total 28 WP (14 DIA, 5 UPD,3 BGD, 3 SPO, 3 UP2)
> App server 4: 4GB RAM total 27 WP (15 DIA, 4 UPD,3 BGD, 3 SPO, 2 UP2)
> App server 5: 4GB RAM total 27 WP (15 DIA, 4 UPD,3 BGD, 3 SPO, 2 UP2)
> Request you to suggest necessary action on to increase performance.
>
> Please give your valuable inputs on this observation.
> Thanking you all.
| __.____._ Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| | Related Content White Papers
In the Spotlight  _.____.__ |
Mark as helpful
