Performance Issue for BI system

[Former Member]

Hello,

We are facing performance issues for BI System. Its a preproductive system and its performance is degrading badly everyday. I was checking system came to know program buffer hit ratio is increaasing everyday due to high Swaps. So asked to change the parameter abap/buffersize which was 300Mb to 500Mb. But still no major improvement is found in the system.

There is 16GB Ram available and Server is HP-UX and with Netweaver2004s with Oracle 10.2.0.4.0 installed in it.

The Main problem is while running a report or creating a query is taking way too long time.

Kindly help me.

[sivakumar_kilari3 · Accepted solution]

Hello,
> 
> We are facing performance issues for BI System. Its a preproductive system and its performance is degrading badly everyday. I was checking system came to know program buffer hit ratio is increaasing everyday due to high Swaps. So asked to change the parameter abap/buffersize which was 300Mb to 500Mb. But still no major improvement is found in the system.
> There is 16GB Ram available and Server is HP-UX and with Netweaver2004s with Oracle 10.2.0.4.0 installed in it.
> 
> 
> The Main problem is while running a report or creating a query is taking way too long time.
> 
> Kindly help me.

We cannot say performance problem in one solution. you have to take lot off parameters to find out solution.

1. ST03 ..........Workload monitor ...........( transaction average response time)

2. SM50 -

---

Work process ( check each work process CPU time consuming and work process availability )

3. ST02----

---

Buffers ( hit ratio, swaps for all buffers not only program buffer)

Check your SWAP space at OS level.

Thanks

siva

[Former Member · Accepted solution]

Hello SIva,

Thanks for your reply but i have checked ST02 and ST03 and also SM50 and its normal

we are having 9 dialog processes, 3 Background , 2 Update and 1 spool.

No one is using the system currently but in ST02 i can see the swaps are in red.

Buffer HitRatio % Alloc. KB Freesp. KB % Free Sp. Dir. Size FreeDirEnt % Free Dir Swaps DB Accs

Nametab (NTAB) 0

Table definition 99,60 6.798 20.000 29.532 153.221

Field definition 99,82 31.562 784 2,61 20.000 6.222 31,11 17.246 41.248

Short NTAB 99,94 3.625 2.446 81,53 5.000 2.801 56,02 0 2.254

Initial records 73,95 6.625 998 16,63 5.000 690 13,80 40.069 49.528

0

boldprogram 97,66 300.000 1.074 0,38 75.000 67.177 89,57 219.665 725.703bold

CUA 99,75 3.000 875 36,29 1.500 1.401 93,40 55.277 2.497

Screen 99,80 4.297 1.365 33,35 2.000 1.811 90,55 119 3.214

Calendar 100,00 488 361 75,52 200 42 21,00 0 158

OTR 100,00 4.096 3.313 100,00 2.000 2.000 100,00 0

0

Tables 0

Generic Key 99,17 29.297 1.450 5,23 5.000 350 7,00 2.219 3.085.633

Single record 99,43 10.000 1.907 19,41 500 344 68,80 39 467.978

0

Export/import 82,75 4.096 43 1,30 2.000 662 33,10 137.208

Exp./ Imp. SHM 89,83 4.096 438 13,22 2.000 1.482 74,10 0

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

Roll area 2,22 5.832 22.856 131.072 131.072 IDs 96,61

Page area 1,08 2.832 24.144 65.536 196.608 Statement 79,00

Extended memory 22,90 958.464 1.929.216 4.186.112 0 0,00

Heap memory 0 0 1.473.767 0 0,00

Call Stati HitRatio % ABAP/4 Req ABAP Fails DBTotCalls AvTime[ms] DBRowsAff.

Select single 88,59 63.073.369 5.817.659 4.322.263 0 57.255.710

Select 72,68 284.080.387 0 13.718.442 0 32.199.124

Insert 0,00 151.955 5.458 166.159 0 323.725

Update 0,00 378.161 97.884 395.814 0 486.880

Delete 0,00 389.398 332.619 415.562 0 244.495

Edited by: Srikanth Sunkara on May 12, 2011 11:50 AM

[Former Member · Accepted solution]

Hi Srikanth,

As i understand from your query is when you schedule BI reports (extraction) we have performance problem you face.

Pl compare the process chain with that period which went fine like data volume, etc.

Also change SMQS setting in source system

Thanks

Deepak

[Former Member · Accepted solution]

Hello Srikanth,

Do you see all the background and updates being used and some jobs being in released status with delays?

How is your SM13 update counts during the time when these jobs are running?

Regards

Vivek