cancel
Showing results for 
Search instead for 
Did you mean: 

SQLSERVR.EXE eating up huge memory

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

former_member188883
Active Contributor
0 Kudos

Hi,

Please check Memory allocated to each of the instance on the server. Try reducing it and check the results.

Regards,

Deepak Kori

Answers (4)

Answers (4)

Former Member
0 Kudos

Thanks guys for all your replies and suggestions.

michael_ruth3
Contributor
0 Kudos

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,

Former Member
0 Kudos

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

Former Member
0 Kudos

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