Resize SQL Server virtual memory usage

At installation, the "max server memory" for the HPOM SQL Server instance (the HP Operations Manager database) is set to 50% of physical memory. This configuration is made to limit the amount of virtual memory that is consumed by SQL Server. See the related URL:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_sa_40vt.asp

If more physical memory is installed, then the maximum memory size configured for the \OVOPS instance may be increased accordingly. Use the command-line script provided in the <Support> directory for this purpose.

To change the "max server memory" setting

1. The setmaxmem.bat file will run the OSQL script set_max_memory.sql. If you have changed the username:password from <sa>, then edit the setmaxmem.bat file with the correct system administrator's username and password.
2. Edit the set_max_memory.sql file with the desired <max server memory> size.
3. Run the setmaxmem.bat file.

You do not need to reboot or restart SQL Server for these changes to take effect. However, if a smaller amount of virtual memory is specified than is already used, the new maximum value will not take effect until the system is reset.