- Administrator RDP login details to the Virtual Private Server (VPS)
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.
, then click on
Type in "
" and click OK.
This will open the Act! Diagnostics tools.
Click on the
menu and select
- This will open up a warning message, informing you that you are making technical procedures. Click Yes to proceed.
tab, you should see a
slider. Adjust the
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.