Memory Tuning

[Former Member]

Hi,

Our systems are on Windows Server 2008 and have MSSQL Server 2008 R2. But ST02, I found a lots of buffers are red. So want to tune SAP memory.

I have gone through the SAPNOTE 88416(Zero Administration) and checked that.

So, when a fresh system is installed on windows server, does it follows the zero administration parameters by default or we need to change to zero administration parameter?

Any help on this.

Regards,

Sk Nurujjaman

[Isaias_SAP]

Hello,

I'm not sure whether ZAMM (Zero Administration Memory Management) will be used by default at a fresh installation.

In either case, ZAMM will basically define default values for each memory area. That's it.

It will not remove the need to tune some memory parameters based on your own system needs / behavior.

About the ST02 buffers in red, how is the hit ratio?

As far as I know, if the hit ration is high (say, 90% - 95% or more), you would not need to worry about red buffers.

However, if the hit ratio is low, you should consider increasing the size of the related buffer.

Regards,

Isaías