To properly maintain the Discover databases,
control their size, and improve performance, Discover recommends using the Simple Recovery
Model for SQL Server and compressing the log files.
About this task
If you are experiencing database size and performance
issues, review the following steps to set the Recovery model to the Simple
setting:
Procedure
- For each installed Discover database:
- In SQL Server Management Studio, right-click each Discover 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 Discover databases.
- Then, stop the Discover Data
Collector and Discover Data
Service through the Windows™ Services
Control Panel.
- In SQL Server Management Studio, for each database:
- Right-click the database name. Select .
- In the dialog, select
Log
from the File
Type drop-down. Click OK.
- Repeat the above steps for the other Discover databases.
- After the above was completed for each database, restart
the Discover services.
Results
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.