Run the Health Check Tool and select Generate Usage Statistics. Check Database runs a high-level check of the database without inspecting tables.
Multiple file groups are not supported in CSM. If you database uses multiple file groups or transaction logs, this check will fail.
To run a health check on the database:
- Select the Generate Usage Statistics check box when you Run the Health Check Tool.
The Check Database report opens.
- Verify the database name to ensure that the correct database is being checked.
- Check that ServerCollation and DatabaseCollation match. They should be case insensitive as indicated by CI in the collation name, for example SQL_Latin1_General_CP1_CI_AS.
- Check that RecoveryModel is FULL.
- Check that ServerMaxMemory is 1GB less than the total available system memory.
- If you are using a dedicated server for CSM then OptimizeAdHoc should be set to true.
- Check that Version contains one of the supported SQL versions and has x64 in it.
- Check that the Database Files section has two entries.
- The is_percent_growth column should be false.
- In general, and for small databases, we recommend that growth not be more than 10% of the Size column. For example, if the Size is 1000 MB, the growth should ideally not be more than 100 Mb. For production databases, the minimum recommended value for the Growth column is 50 MB.