cancel
Showing results for 
Search instead for 
Did you mean: 

Memory parameter

ganesh_borase2
Participant
0 Kudos

Hello everybody,

we have migrate sap ecc 5.0 with windows 2003 64-bit + SQL 2005 environment in Hyper-v

please suggest me which memory parameter need to configure for improve performance.

we configure 8 GB RAM and 4 processor.

Thanks

Ganesh

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Ganesh,

For good system performance you need to tune not only SAP memory parameters but also database parameters (transactions are processed in DB).

879941 Configuration Parameters for SQL Server 2005

88416 Zero administration memory management for the ABAP server

also check SAPPFPAR after implementing the parameters from the note for SWAP requirements.

http://help.sap.com/saphelp_40b/helpdata/fr/02/9625e3538111d1891b0000e8322f96/content.htm

Thanks,

Arjun

ganesh_borase2
Participant
0 Kudos

Thanks for reply.

when I check the SAP NOTE 879941 it recommends one third of RAM assign to SQL Server

we have Database and central instance on one server. currently SQL server memory min and max is 1831 MB


exec sp_configure 'min server memory (MB)', 1500
exec sp_configure 'max server memory (MB)', 1500 

if we have 8 GB RAM, can I set the memory upto 2730 MB.

Please suggest.

Thanks

Ganesh

Former Member
0 Kudos

Hi Ganesh,

Yes, you can set 2730 or 3000 for SQL .

Thanks,

Arjun

ganesh_borase2
Participant
0 Kudos

Thanks for suggestion.

Please suggest, can it does any -ve impact on performance?

How it will improve the performance?

I have to increase in PRODUCTION server that's why i am asking,,,,

Thanks

Former Member
0 Kudos

Yes, it has impact on performance but for good performance. Your Database should have enough memory to process the requests, when multiple WP sends a requests to database, the database should have enough memory to process the requests and keep in buffer for next requests.

Refer to below link

http://dbmoore.blogspot.com/2010/05/why-is-in-memory-database-important-to.html

Thanks,

Arjun

ganesh_borase2
Participant
0 Kudos

Thanks !

I have a query, server has 8 GB RAM

scenarios:

1. we have not maintain the parameter PHYS_MEMSIZE, so it consume near about all available RAM and on same server SQL has memory near about 1800 MB.

2. if we maintain the PHYS_MEMSIZE parameter and set its value to 4523 and SQL server min and max memory set to 3000.

which will applied for best performance, please suggest what value should maintain for both....

we have SAP on windows 2003 64-bit and SQL server 2005

Thanks

Ganesh

Former Member
0 Kudos

you can apply 4gb for phys_memsize and 3gb for DB. you might need min 1gb for os resources.

Former Member
0 Kudos

Hello Ganesh,

Please go through the note 88416 and tune memory parameters accordingly.

Thanks,

Siva Kumar