When MSSQL 2005 is installed on your VPS, the default maximum value is set to an unlimited value. This default value allows MSSQL 2005 to utilize all available memory on the server. Therefore, a server that is running only MSSQL 2005 runs at peak performance by utilizing all available memory. However, if your VPS will run additional applications such as IIS or a mail server, the maximum memory setting should be changed. The instructions belong explain how to set a mimumum and a maximum memory value for MSSQL 2005
Configuring Memory:
1. Select properties from the menu
2. Select memory from the options on the left-hand side.
3. Enter the values for minimum and maximum server memory in MB.
4. Click OK to confirm changes.