Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The SQL Log and SQL Errors views both contain commands that enable you to save, restore, or otherwise move log entries into files outside of SQL Query TunerDB Optimizer. Additionally, both views also contain commands that enable the clearing of the view.

...

  • Right-click in the SQL Log view and select Clear Log Viewer to remove all messages.
  • In the shortcut menu, select Delete Log to delete the .log file. If entries are created after the Delete Log command is issued, SQL Query Tuner DB Optimizer will automatically generate a new .log file in the .metadata subfolder.

    Info

    Old Error Log entries cannot be recovered once the .log file is deleted. To prevent data loss, archive the .log file via the Export command prior to deletion. 

  • To clear the Error Log view without deleting the .log file, select Clear Log Viewer from the shortcut menu. The View will be cleared of entries, but these entries will still be contained in the .log file.
  • To restore the Error Log view based on the entries contained in the .log file, select Restore Log from the shortcut menu. The View is restored based on the entries in the .log file. 


Scroll pdf ignore
Automate SQL tuning and profiling with DB Optimizer. Learn more > >