SwMonitor.db maintenance:

  1. Stop TotalView service
  2. Open CMD line to C:\Program Files (x86)\PathSolutions\TotalView\Data directory
  3. 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:

  1. Stop TotalView service
  2. Open CMD line to C:\Program Files (x86)\PathSolutions\TotalView\Data directory
  3. Run: sqlite3 -init ..\NightlyCleanupNetFlowDB.sql NetFlow.db
  4. 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:

  1. Stop TotalView service
  2. Open CMD line to C:\Program Files (x86)\PathSolutions\TotalView\Data directory
  3. Run: sqlite3 SwMonitor.db
  4. 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.