RAM utilization 95% for a while..system slow down..

[Former Member]

Hi gurus

we are using win2003 ECC 6.0 SQL database.

having RAM 12GB. some times servers RAM utilization will be near to 95%. in TA st06 there is only lessthan 200 kb

of physical memory free.

and CPU idle is ok 70 to 95%.

but my dialog responce times are as follows:

*02.07.2009 15:20:13 TO 02.07.2009 *

*Task type name steps Avg resp time Avg Proc time cpu time db time *

DIALOG 1,118 2,605.30 1,750.80 112.8 335.8 0 43.1

Time 15:00 to 15:10

DIALOG 835.8 460.5

Time 15:10 to 15:20

DIALOG 3,270 1,439.50 953.4 100.1 171.7 0 22.1

Time 3:20 to 3:30

DIALOG 251 1,738.10 1,154.20 86.3 182.6 0 15.3

Time 15:30 -15:40

DIALOG 294 1,660.20 1,238.20 117.6 166.9 0 19.6

Time 15:40 to 15:50

DIALOG 191 6,611.80 4,229.30 179.7 981.2 0 144.3

Time 15:50- 16:00

DIALOG 378 1,862.70 1,274.80 89.7 231.4 0 27.2

Time 16:00 to 16:10

DIALOG 511 1,985.40 1,387.10 115.7 177.5 0 17.4

Time 16:10 to 16:20

DIALOG 652 233.6 156.5 60.2 32 0 1.7

Time 16:20 to 16:30

DIALOG 179 395.8 156.9 67.7 54 0 10.5

Above i observed that avg processing is tooo high as compared to avg responce time.

during that above time period i observed that the RAM utilization is more...how can i know which process causing thiese much RAM utilization....if i go to windows taksmanager there is highest mem utililzation with disp+work round 200-300MB.

please let me know where i have to concentrate to overcome this issue which happens alternatively 2 or 3 days a while.

Thank in advance.

Regards

Balaji

[Former Member]

finally we came to know that.. This was due to back up is happening(copying) to the disk and when this(disk backup) data is moving to Tape. the system is slow.....

[Former Member]

Above i observed that avg processing is tooo high as compared to avg responce time.

Check expensive SQL Statement via ST03, you can carry out performance trace by ST05, update statistics, check for missing indexes if any.

[Former Member]

You can find out the tcodes which are consuming higer memory through the ST03 under Memory Use Statistics here you need to choose task type dialog, based on the info you need to use tocde STAD and input the Tcodes which had highest consuming memory you have got from ST03 and exectue it. The output gives you the user and work process and memory consumed etc which will help you to drill down to issue further.

While using STAD read interval should be taken care for 24 hrs you need to keyin like ths TIME 00:00:01 LENGTH 23:59:59

To seek the info on Rules for Memory Management under Windows and otther issue like Reduczing the Size of the Windows File Cache, Determining the Number of Work Processes and Overview of Parameters for Windows from the link:

http://help.sap.com/saphelp_erp2004/helpdata/en/02/962783538111d1891b0000e8322f96/frameset.htm

Thank you,

Shyam