To properly maintain the Tealeaf databases, control their size, and improve performance, use the Simple Recovery Model for SQL Server and compressing the log files.
If you are experiencing database size and performance issues, review the following steps to set the Recovery model to the Simple setting:
- For each installed Tealeaf database:
- In SQL Server Management Studio, right-click each database and select Properties.
- In the dialog, select the Options page. Review the setting in the Recovery Model drop-down. To reduce the size of the database, set this setting to
Simple. Click OK at the bottom of the dialog. - Repeat the above steps for the other databases.
- Stop the Data Collector and Data Service through the Windows™ Services Control Panel.
- In SQL Server Management Studio, for each database:
- Right-click the database name. Select Tasks > Shrink > Files.
- In the dialog, select File Type > Log and click OK.
- Repeat the above steps for the other databases.
- After the above is complete for each database, restart the Tealeaf services.
These steps should reduce the size of your databases and reduce the disk I/O by lowering the amount of logging that is being done.