ST02 SWAPS are more

[Former Member]

Hi,

Iam new to db tuning . My system shows more SWAPS when i go to ST02 .

System slow down performanance.SWAPs are showing more.

Any idea how to resolve this.

Thanks

Lisa

[Sanjay12]

Ya, they all are right..

But practically , i have seen that when no. of swap increses the performance of system goes down and simultenously it gives the dump error..

So pl. check the tablespace if it is more then 90% pl. maintan the tablespace.

Also pl. check since how many day you have not taken a shutdown of the system..

if possible take the shutdown or restart the instances

i hope this will help you.

if useful pl award the points..

thanks

[Former Member]

well one need to know more details, about which buffer shows swaps, how many swaps did you see, which sap abap version we are talking about.

You can not prevent all swapping in SAP caches, the important number is not the number of swaps but the cache quality.

On 32 Bit operating systems you have take care about the address space of the workprocesses. Increasing caches will decrease the directly allocatable amount of memory in abap programs.

regards

Peter

[Former Member]

Hi,

you can use this document in the following link to tune ur system..

<b>http://www.microsoft-sap.com/doc/SAPHardeningandPatchManagementGuideforWindowsServer.doc</b>

regards

jag

[Former Member]

Hi,

Since more data had been fed into the server, it needs more space to hold in buffer while retrieving the data. Since buffer is shot in space, swap memory will be used. It is not enough to increase the buffer ...go for data archiving type of methedology...

kindly let me know in case of issues.

regards

jag

[Former Member]

Hi Lisa

if u find that no report is consuming more buffers and regularly u are getting more swaps , then it is the memory bottleneck , the best u can do is , increase the RAM capacity of your server

regards

Ravi Kumar Bejugam

[Former Member]

Hello,

Kumar is absolutely right....if it is continuous bottleneck then increase the size of the RAM....also it depend on the veriosn of the O.S. in windows - 32 bit or 64-bit..

so please check that also ...how much memory will be supported by ur server....

thanks

[Former Member]

Hi Lisa,

Lars is very correct.There may be some reasons as

told by Lars.In order to solve this problem u can follow

these steps.

1)Send a session data to SAP by executing tr code "SDCCN"

or "SDCC".On the basis of this session data SAP will

send u a Analyzed Early watch report.

In which u can check whether some programs are

being swapped frequently.

Another reaSON may be low buffer space.

For this u can increase the size of buffer.

You can check programs responce time by urself by using

Tr code ST03.

Hope this will help you.

Regards

Aditya Kumar

[lbreddemann]

Hi Lisa,

ST02 is not about DB tuning, it's about WAS tuning.

The Buffers you see in this transaction are SAP Buffers. If they do swap a lot it might have different reasons:

1. Too few mem at all

2. some ABAP using to much memory

3. unappropriate setup of the table buffering...

Usually this should be analyzed so that the CAUSE for the memory bottleneck is identified and solved based on that.

Anyhow, this is something for the WAS experts as the DB has not much to do with it.

KR Lars