By default, Microsoft SQL Server will use all of the available system memory (RAM) to cache lookups and for temporary indexing. While this is a great option on a dedicated SQL server, it will cause issues when it's installed alongside other software such as IIS or Act!. This article will show you how to login to the server and limit the memory.
Despite reducing the memory, in most instances this has a postitive effect on performance and certainly on stability. Conetix highly recommends that this procedure is run on all Act! based VPS's.
- As the Administrator, login to your VPS.
- Click on Start, then click on Run:
- Type in "actdiag" and click OK.
This will open the Act! Diagnostics tools.
- Click on the Server menu and select Server Settings:
- This will open up a warning message, informing you that you are making technical procedures. Click Yes to proceed.
- In the Server Memory tab, you should see a Minimum and Maximum slider. Adjust the Maximum slider to lower the available memory down from the full server amount:
- Click on Apply and close Act! Diagnostics. This reduced memory setting will become effective immediately.
If you have any difficulties setting the memory as per the procedures able, please feel free to call or email the Conetix support team for assistance.