on 01-27-2012 1:35 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
Hello Ganesh,
Please go through the note 88416 and tune memory parameters accordingly.
Thanks,
Siva Kumar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.