Communifire uses SQL Server database from Microsoft. We recommend using SQL Server 2012 Standard or above. Here are the salient points regarding managing your Communifire database:
Never truncate your log files. Make sure you follow the point above so that your log files do not grow in size.
Make sure the server on which you have SQL Server installed has at least 32 GB RAM. Do not install Elasticsearch or any other memory-intensive software on the database server.
is requesting access to a wiki that you have locked: http://my.axerosolutions.com/spaces/5/communifire-documentation/wiki/view/31043/sql-best-practices