Are seeing slow performance or frequent timeouts (e.g. errors like “execution canceled”) when using FastMaint with an external SQL Server database? Here are a few causes we have seen at customer locations.
1. Open the database in SQL Server Management Studio. Check that the database recovery mode is Simple (the default SQL Server setting). Other modes can generate ever growing log files that finally fill up all the disk space on the server unless someone truncates the logs regularly.
2. If you originally created the database on SQL Express edition turn off AutoClose. Databases created on SQL Server Express are set to AutoClose ON by default.
3. Make sure that FastMaint is using a SQL Server user account that has DDL administration as well as read+write access to the FastMaint database. Set the default schema for this user account to “dbo” (database owner). Otherwise you may get errors and reports of missing tables or objects in FastMaint. In SQL Server Management Studio you should see all tables in the FastMaint database have the prefix “dbo.” e.g. “dbo.sm_task”, “dbo.sm_vendor”, etc.
4. Check the memory utilization and CPU usage on the database server. Ideally memory usage should be 60% or less and CPU usage should average less than 10% (with occasional spikes). Make sure you do not have other open applications running on the server. For example having a running instance of Google Chrome left open on the server is know to cause large memory and CPU usage.