on 07-18-2012 6:56 AM
Hi Gurus,
i am facing performence problem with my SAP system. even no users are login to system also facing same problem.
when i observerd ST06 there physical memory comsumed total.
apart from that am not able to see any problem in system.
SAP: ecc 6.0 DB: SQL server 2005 OS: windows 2003 x64
please suggest me
Thanks,
Venkat
did you increase the swap size of the windows.??
what is the value of swap size?
Right click on my computer-> properties->advanced->performance options:
here change the paging size.
Also if possible increase the RAM.
then you need to restart the whole server. come server shut down and restart.
regards,
Meenakshi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Venkat,
What is the total RAM size?
How did you distibuted it between CI and DB ? Generally it is 70 :30 or 60:40 between CI and DB.
Regards,
Vishal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Thanks for your response.
Vishal: RAM is 15gb
How did you distibuted it between CI and DB ?-----> How can i check it?
Problem is My solmon and QA installed on same server with VM ware option. so is this the problem?
even OS level also am not able to connect Solmon through mstsc. I hope i have explained my problem
Thanks,
Venkat
Hi Venkat,
This looks to me servers are not provided with the dedicated memory, itstead they are using shared ones.
Login to SSMS Right Click First node --> properties --> memory --> here you can specify the minimum and maximum server memory for SQL.You can adjust the DB memory over here.
I would have shut down atleast one system, reconfugure the memory stuff.
Thanks,
Vishal
Hi Vishal,
Thanks for quick response.
when i go check for QA as you mentioned below valus are there.
Minimum server memory(mb): 6138
Maximum server memory(mb):6138
index creation memory:0
Minimum memory per query:1024 kb
For Solmon am not able to connect os level right now but at SAP level i checked PM=6gb free pm=97mb
please suggest me how can i tune?
Thanks,
Venkat
Hi Vishal,
I have changed SQL server memory. but problem is before starting SAP the virtual memory utilization very low and after starting SAP it is consuming around 40gb page file(even though we have physical memory 6gb free)
could you help me to solve this memory utilization problem?
Thanks,
Venkat
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.