The most common cause of lowered performance in Sage CRM is an over worked server. There are a few ways to quickly address this problem.
1. The first possible solution is as simple as adjusting your business practices. Running large reports or importing large amounts of data can put a major strain on your server. These tasks will quickly eat up all of your servers RAM and CPUs and cause your users to notice significantly lowered performance. A simple fix for this problem is to have your imports and larger reports run during non-peak work hours. This will allow your server’s resources to focus on work related tasks during the peak hours and to focus on imports and reporting during the hours user are not accessing the system as frequently.
2. Another non-technical solution is to adjust the Sage CRM logging levels. In the Sage CRM administration section under system > logging, there are a few options at the top of the screen you can easily adjust to increase performance. For the best performance set the logging levels to the following:
- System Logging Level = 0-Off
- SQL Logging Level = Off
- Query Duration Logging threshold = 0
- .Net Logging = 0-Off
After you adjust the settings you will notice an increase in performance due to Sage CRM no longer logging all of your activity in the log files.
3. There are also a few technical solutions to increase your Sage CRM performance. The first is to shrink your SQL log file. You can do this by logging into your SQL Server Management Studios and running a shrink log file query. The queries are slightly different based on the version of SQL server you have. I have included the example for SQL Server 2008. It is recommended to have a SQL expert backup your database before running the queries.
SQL 2008 Shrink Log File:
ALTER DATABASE SET RECOVERY SIMPLE WITH NO_WAIT
DBCC SHRINKFILE(, 1)
ALTER DATABASE SET RECOVERY FULL WITH NO_WAIT
Once the query is complete, right click on your database name in SQL Server Management Studios and click on properties. Go to the file > option on the left and look at the Initial size of the log file, it should be at 1.
4. A second technical solution involves upgrading the server that Sage CRM or SQL Server resides on. If you find that the Sage CRM or SQL server is constantly running at full capacity, it may be time to upgrade the hardware. A good way to check how hard your server is working is to log into your server, either Sage CRM or SQL, right click on the task bar at the bottom and click on ‘Start Task Manager’. Once it’s open, click on the performance tab. You can quickly see how much of the CPU and memory is being used by the indicators on the left side. If they are both constantly near the top, it’s time to upgrade. While upgrading the CPU can be costly, it’s relatively inexpensive to add more or even double the current RAM on the server.
5. An alternate and very useful solution that we recommend is our own CRM Tune-up Wizard. This performs the shrink log file and sets the Sage CRM settings for you automatically. The SQL Tuning Tool also performs some field and view modifications to greatly increase performance as well as rebuild all the old indexes in your CRM database.
This tool is very handy for performing a lot of technical tasks to increase performance by simply clicking a button in the Sage CRM administration area.
After completing all or some of the tasks, you should notice a much faster system for you and your team as they navigate through Sage CRM. For more information on the CRM Tune-up Wizard and other Sage CRM add-ons, visit www.technotropic.com.