Dev Server Slow

[Former Member]

Hi All,

Im working on ECC 6.0.

OS is windows 2003 server and database is Ms SQL 2005. RAM is 4 GB.

Had set pagefile four times RAM and its static.

My DEV server at times becomes very very slow so i chk

- CPU usages in task manager thts also hardly 5-10%

- there is no locked process also.

- when I chk in ST02 all the hit ratio is above 99%.

- there is hardly 15-20 users logged in

Can any one plz tell me wht else could be looked into to make server work at good speed.

Many thanks

Mani

[Former Member]

Thanks Alot for all the co-operation

[Former Member]

Memory is a bottle neck in your system. Just check the memory utilization in task manager. If it is considerably above your physical memory, then obiviously you see a performance problem.

If Java stack is not used, stop it and disable it's startup in the instance profile. look at the total number of CPUs and allocated number of work processes and try to optimize.

[Former Member]

Hi Manoj,

Total memory consumed by process in task manager is abt 5 GB.

Do you think this will create problem, cause I think here comes the role of page file which is enough

c: 2048 - 3072

e: 5120 - 5120

f: 5120 - 5120

Wht you suggest on this ??

Regards

Mani

[Former Member]

Problem solved !

I made page file default on C: and it seems to be working fine nw.

Thanks All.

Regards

Mani

[Former Member]

Hi Mani,

If the database is on the same system the a large portion of the memory should be dedicated toward the data cache. The remaining amount should be assigned to the SAP application server (ABAP/JAVA). A good note to start with is 88416 which details the buffer parameters on the SAP side.

How large is the data cache on your system?

Hope that helps.

J. Haynes

Denver, CO

[Former Member]

Hi Joe,

I checked DB13 -> performance overview

Data Cache (MB) = 667.2 hitratio = 99.027%

Proc Cache (MB) = 718.7 hitratio = 96.936%

One more thing, can we chk data cache with Tcode LV10 ??

Regards

Mani

[Former Member]

Hi Mani,

Check with ST03N , try to analyze what are the response times for BTC, Dialog and waht are the programs.

Check ST02 and see any red in buffer sizes? try to increase abap/buffersize as well.

Regards,

Hari.

PS: points are welcome

[Former Member]

Hi Hari,

I have already increased the buffer size.

Current abap/buffersize is 400,000 KB

CUA is 20,000 KB

PHY_MEMSIZE is 1536

And yes there are buffer overflow in ST02 but hit ratio is 99%.

so i think we can accept buffer overflow if the hit ratio is above 99%.

Plz correct me if Im wrong ???

Regards

Mani

[Former Member]

Hi Mani,

Check what is the maximum used abap/buffersize , then increase it if it's crossing the limit 400MB. If you are having hit ratio as 99%, still you can increase the buffer sizes to avoid any swaps. Check ST03N and find out what are the response times?

Regards,

Hari.

[Former Member]

Hi Mani,

You abap buffer seems very small to me.

With a 64 bit server, we put à least 1 GB for the abap buffer.

With a 32 bit app server, we put 800 MB for the abap buffer.

A lot of abap buffer swap kills the performance, especially on a dev system...

Regards,

Olivier

[Former Member]

Hi Oliver,

DEV server is 64 bits but considering 4 GM RAM and page file is four times of RAM (static), shall I increase abap buffer size to 600 MB. Plz suggest !

According to you wht wud be the MAX abap buffer for 4 GM RAM ?

And making page file static & 4 times of RAM is advisible or nt ?

Regards

Mani

[Former Member]

Hi Hari,

Current swap is 338,535 for abap buffer and 25,089 for CUA buffer.

And in ST03N I dnt find any problem or can you plz suggest me exactly wht data I need to look into, or any link from where I can get help to read and analyse entire ST03N statistics.

Regards

Mani

[Former Member]

Hi Hari,

One thing I have noticed in ST03N, is high average DB wait time and high wait time for update process.

what should I do to decrease average DB wait time and update time apart from rebuild and reorganise ?

Regards

Mani

[Former Member]

Hi Mani,

You may think of increasing WP's of update but on devlopment server i don't think not many updates happens. Try to chek any BTC running with out any use. Any how try to increase the abap/bufferesize first then you check any improvement is there are not.

Regards,

Hari.

PS: Points are welcome.

[Former Member]

Hi Hari,

There is no BTC running.

Have increased abap buffer size from 400,000 to 600,000 now my SWAP has decreased drastically but hit ratio of PXA and CUA buffer is also decreased from 99% to 96 % .

What you suggest abt this ?

regards

Mani

[Former Member]

Hi Mani,

Hit ratio will be increased to 99 again once your users start working. I hope your roblem should be solve now.

Regards,

Hari.

PS: Points are welcome.

[Former Member]

Hi Hari,

so far ony CUA buffer hitratio is gone to 98% and PXA hit ratio is on 96%.

Have changed page file setting of C: drive

from 4096(static) to 2048 - 3072 (dynamic).

Lets see wht result it brings.

Regards

Mani

Message was edited by:

mani sahay

Message was edited by:

mani sahay