Hi Brian and Steve,

Thanks for your valuable and precious advice.

Will set the max memory to 28GB and see how it goes.

Thanks

Hi,

Mr Brian n frederico,

I'm not using VMware. It is a physical server with 32GB ram.

I have snapshot the setting for the sql server.

Please help to have a lookup.

Anyway to prevent...