em/initial_size_MB / Physical RAM

[Former Member]

Hello,

I have a client who is experiencing some performance issues so I'm just reviewing the memory parameters/allocations.

Environment is Windows/SQL.

The box has 8GB of physical memory with 24GB of virtual memory.

em/initial_size_MB is set to 10GB.

I have in the back of my mind that em/initial_size_MB should not be greater than the amount of physical memory.  Is that correct? And if it's set to a higher value, what issues could it cause?

Many thanks.

[Former Member]

Hi,

These are all extremely helpful replies, thank you.

I can pad this out now with a little bit more information.  PHYS_MEMSIZE is set, I was searching RZ11 for PHYS* - this doesn't work.  Putting in the PHYS_MEMSIZE does!

This is set to 10GB.  I don't see how as this is automatically set from the amount of RAM in the box right? And that is 8GB!

Also, ST04 shows 3GB is fixed.  So only 5GB left to play with.  But PHYS_MEMSIZE and em/initial_size_MB is set to 10GB.

All a bit messy really.