RAM utilization becoming 100% after restarting it is ok

[Former Member]

Hi

Gurus i am using ECC6.0 Sql server on windows , our system RAM utilization for every 2 or 3 days becoming 100%, and then all repsonce times are becoming high...When i restart the system then system will be ok.

any i suggestions where do i start the investigation...

Thanks in advance

Balaji

[Former Member]

not answered

[Former Member]

Hi,

>not answered

And you keep a memory problem from may to november ?

[alen_mikulic]

Hi,

Can you check in windows task manager about which process is taking most of your RAM and when you start up can you monitor the sap process with its process id and check in SAP what background job / dialog activity it relates to. In this way you can narrow down to the key problem and then tune the job/ patch/ send more logs to this forum to investigate further.

Cheers Sam

[former_member906139]

Hi,

In Windows system its easy to manage memory parameters, You just need to set parameter PHYS_MEMSIZE = <Physical Memory>.

For more information please follow SAP Note : 88416

Regards,

Abhay

[Former Member]

Hi

Did any memory related parameters got changed recently? What version of SQL server is being used? check for the corresponding Configuration Parameters for the same?

Ravi

[Former Member]

Hi

Nothing has been changed except some of FI related changes......

my db version is MS SQL Server 2005 - 9.00.2050.00 (Intel IA-64) SP1 Enterprise Edition

RAM:12GB

Swap: for all at TA: ST06 max:77GB min: 33GB.

earlier it was working fine..all of sudden it started recently utilizing RAM 100% and CPU also 100% ....but the wonder thing if i restart the server it works fine for more 2 or 3 days....

Thanks in advance

BALAJI

[Former Member]

Hi Balaji

Please check configuraton parameter with help of SAP Note 879941 - Configuration Parameters for SQL Server 2005.

Ravi

[Former Member]

Hi,

Check if you have SAP processes running in private mode (allocating Heap memory).

Regards,

Olivier

[Former Member]

Hi,

Looks like the Memory requirement in your system is higher the resources you have in the system.

The reason why you are getitng the slow respsone is that when all the phisical memory is utilised, paging used to start which cause the system slow and when you restart the system, all the memory utilization refreshed and all the pages got free again.

Please check the memory consusmpltion in your system using the Tcode ST06 and if swapping is high most of the time, You can take a call for increase RAM of your system.

Please also make sure that you have set the SAP recommanded parameters for paging related in your system.

With Regards,

Saurabh

[Former Member]

How much Ram does your server have? How much Swap is available?

Did you check the Defaulttraces for possible errors?