We are using SoanrQube 6.7 version along with Microsoft SQL Server 2014
We are trying to optimize the database as currently database size is around 20 GB and transaction log size is > 1TB, we are not experts in Database administration and need inputs here.
Documentation says database will be cleaned upon settings mentioned in the Database Cleaner, will this also reduce the database size ? Is there any other thing we can do to optimize database?
Also we tried to delete few old projects we were not using but even after that and restarting SonarQube database size was same, please let us know how to reduce database size after deleting projects itself instead of snapshots. Since project itself is deleted we cannot perform analysis as mentioned for database cleaner.
Is there anyway to reduce database size after deleting old projects.
Please suggest us best way to use MSSQL databse with SoanrQube.
Second thing is Transaction log size currently it is > 1TB , currently our recovery model is set to Full can changing it to Simple will address this issue ? Any issues if set it to Simple from SoanrQube perspective.