Reducing SQL memory

[Former Member]

Forum,

What impact will reducing the memory SQL uses have on SAP B1?

Whilst I appreciate this isn't something that's advised be altered and ideally the more memory the better but I have an instance where there is a 3rd part application and the SQL server is having issues with the about of memory being used thus slowing everything down.

Regards,

[Former Member]

you can tune the memory parameter according to your situation, Monitor "Page life expectancy" from DB performance history and make sure this doesn't go down very low. Microsoft recommends below 300 is a problem but its prefer to have this number very high always.

Thanks

Mushtaq

[Former Member]

Hi ,

Can you check the logs , if not see the size of table spaces if they have less memory, add to increase one more talbespace.