How to Shrink Database Files

PA Storage Monitor can use MS SQL Server or an embedded SQLite database to store it's data. This can be changed in Database Settings. You can control how much data is kept by adjusting the Database Cleanup Settings in the Database Settings dialog.

If you find the embedded SQLite database is using too much space (the files are stored in C:\Program Files\PA Storage Monitor\Databases ) you can do the following to shrink the database files:

1. Change the Database Cleanup Settings so that data is kept for a shorter amount of time.
2. Because the databases get cleaned up about once per day, wait a day for the databases to get cleaned up.
3. If you can't wait, for most databases you can go to the Reports part of the product and right-click on the monitor-type that collects the data and choose Start Database Cleanup. This cleanup happens in the background and unfortunately does not show progress anywhere. Most cleanup operations complete in a few minutes.
4. After the database files have been cleaned up, they will not be smaller, but there will be empty space in the database files. To reclaim the empty space, stop the PA Storage Monitor service and run:
   
   "C:\Program Files\PA Storage Monitor\StorageMonSvc.exe" /COMPRESS_DATABASES
   
   Extra disk space is needed for this operation as a copy of each database is made during the cleanup step. You will see the following dialog:
   
   

When the compressing step is finished, you should start the PA Storage Monitor service.