SwMonitor.db maintenance:
- Stop TotalView service
- Open CMD line to C:\Program Files (x86)\PathSolutions\TotalView\Data directory
- Run: sqlite3 -init ..\NightlyCleanupDB.sql SwMonitor.db
This process should complete relatively quickly (within 10 minutes).
This will show the summary of what work was done. Might be good to get a screenshot of this and any errors that occurred.
Note: It will show two errors. These are normal:
Error: near line 694: unrecognized token: "{"
Error: near line 697: unrecognized token: "{"
This is because TotalView will pre-process this file and only add the vacuum on Sunday.
Note: On older versions of TotalView, the script name may be “NightlyCleanup.sql” instead of “NightlyCleanupDB.sql”.
Netflow.db maintenance:
- Stop TotalView service
- Open CMD line to C:\Program Files (x86)\PathSolutions\TotalView\Data directory
- Run: sqlite3 -init ..\NightlyCleanupNetFlowDB.sql NetFlow.db
- This process should complete relatively quickly (within 10 minutes).
This will show the summary of what work was done. Might be good to get a screenshot of this and any errors that occurred.
Note: It will show two errors. These are normal:
Error: near line 694: unrecognized token: "{"
Error: near line 697: unrecognized token: "{"
This is because TotalView will pre-process this file and only add the vacuum on Sunday.
Note: On older versions of TotalView, the script name may be “NightlyCleanupNetFlow.sql” instead of “NightlyCleanupNetFlowDB.sql”.
To shrink the size of the Database:
Running a manual Vacuum on the database:
If you want to run a vacuum manually to shrink a file, here’s the process:
- Stop TotalView service
- Open CMD line to C:\Program Files (x86)\PathSolutions\TotalView\Data directory
- Run: sqlite3 SwMonitor.db
- At the sqlite> prompt: vacuum;
This might take more than 30 minutes depending on the size of the database and how much data needs to be shrunk, and the IOPS limitation of the disk.