Bad Response time after applying Support packs

[Former Member]

Hi gurus,

We are facing some issues after applying SP in our ECC5.0 server.

Details :

SAP R/3 : ECC5.0

Data base : Oracle 10g

I have applied SP upto SAPKB64024, SAPKA64021.

After applyin the above SP my Development server response time was too bad.

many of my users complained even while executing standard Tcodes , its taking more time to execute.

After Applying SP's:

I have run SGEN.

I have checke all missing indexes.

All buffer values are fine.

Please let me know any other activities has to perform for improving my server performance.

Thanks

VJ

[Former Member]

Are you analyse the St03n ? What do you see in St04? Are you change anything also ?

P.S.

SP upto SAPKB64024, SAPKA64021.

up to from release ? Are you update the kernel ?

Regards.

[Former Member]

Hi,

I have analysed st03 and the response time increase after applying sp on average from 700ms to 1500ms

I have checked st02 and there are less swaps and hit ration is also more than 98%.

Rgds

vJ

[Former Member]

I do not say about st02 check in st04.

The source release version are ?

I have analysed st03 and the response time increase after applying sp on average from 700ms to 1500ms

Can you check on what area this +800ms are on DB time or CPU time or any other time? Post both here from st03n

where 700 ms and now where 1500 --> for example transaction profile

Regards.

[Former Member]

Hi,

Response time for dialog

Month Dialog Av.resp. Avg CPU Avg wait Avg load Av.DB rq Avg DB Av. phys Avg Kbyte

steps time(ms) time(ms) time(ms) time(ms) time(ms) requests DB calls requested

10 / 2009 342,910 412 63 1 16 186 253.0 72.8 174.0

11 / 2009 318,536 460 68 1 19 183 325.3 71.8 179.4

12 / 2009 247,244 495 71 1 18 163 205.5 63.3 239.1

01 / 2010 230,706 494 70 3 25 228 210.2 74.1 216.7

02 / 2010 272,396 543 62 1 21 207 156.9 46.8 227.6

03 / 2010 343,355 1,147 132 23 118 382 232.7 76.5 240.2

04 / 2010 284,425 1,141 175 59 59 410 286.9 89.3 246.6

Total response time

Month Dialog Av.resp. Avg CPU Avg wait Avg load Av.DB rq Avg DB Av. phys Avg Kbyte

steps time(ms) time(ms) time(ms) time(ms) time(ms) requests DB calls requested

10 / 2009 703,775 494 86 5 16 251 303.2 163.7 622.1

11 / 2009 668,770 520 90 5 17 245 337.3 168.5 322.1

12 / 2009 601,609 510 81 3 16 239 288.2 141.9 363.2

01 / 2010 576,873 522 83 5 20 266 288.3 150.7 399.3

02 / 2010 593,422 552 81 3 18 268 265.0 167.6 354.6

03 / 2010 737,764 2,732 347 67 317 925 1,187.8 351.0 694.6

04 / 2010 561,292 3,013 443 139 113 943 1,754.7 435.6 437.7

From the above data we can see from 03/2010 the response time increase a lot.

Even i ahve upgraded my kernal too.

Rgds

vj

[Former Member]

Very ureadable , can you post in readable format ?

P.S. you have very big Dispatcher wait time ..... you have General Performance problem, try to open OSS to SAP if you can't

find solution for your problem, becouse all information you provide here are very low and need to do analysed twice as long and better.

Regards.