ST04 Memory Setting

[Former Member]

Hi Experts,

We have install SAP on Win 2003 Enterprise Server and SQL Server 2000. In ST04 Transaction Code i am able to see Memory setting is AUTO. This is a central System and such kind of setup the memory setting should be FIXED so that SAP and SQL will not fight for memory and this is also recommended by SAP also. Could you please tell me how to change from AUTO to FIXED.

Thanks & Regards,

Krushna Biswal

[clas_hortien]

Hello,

you can switch to "fixed" if you set the values for

max server memory

min server memory

to the same value. You can do this by either running a script like this

exec sp_configure 'max server memory',<Target Size in MB>

exec sp_configure 'min server memory',<The same value>

or by using the enterprise manager. Right click onto the server and choose

properties. On the memory tab use the option 'Use a fixed memory size (MB)'

and use the slider to define the value.

You do not have to restart the SQL Server for this. He will adjust the values on the fly.

Expect a delay for the refresh in ST04.

Regards

Clas