on 11-16-2011 9:33 AM
We have 2 abap instances running on Windows 2008 Server with SQL server 2008 database and 48 GB RAM. But SQL server is eating up huge memory and facing performance issues in SAP.
Please suggest how memory consumption can be reduced.
Hi,
Please check Memory allocated to each of the instance on the server. Try reducing it and check the results.
Regards,
Deepak Kori
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks guys for all your replies and suggestions.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
From a client connection issue this command:
sp_configure 'max server memory', <mb setting>
reconfigure
You should see a rapid decline in the amount of memory used by the sql server process.
Good Day,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Ravi
How do you know that SQLServer eating your memory ?
There are two ABAP and 1 DI are running on your system! did you manage the SAP and ABAP Memory?
Also, refer to below Note for Memory Tunning!
Note 88416 - Zero administration memory management for the ABAP server
Regards
Anwer Waseem
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
From SQL point of view, please check which SQL statements are consuming more memory. It could cause by SAP programs that execute expensive SQL statements. Please trace out those programs causing performace issues and ask ABAP teams to tune up properly. You can work with Basis and ABAP to get this problem resolved.
You also need to check if any DB utilities causing this memory consumption other than expensive SQL statements.
Good Luck
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 |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
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.