Given the number and size of log and trace files that will be generated during a typical day in a data warehouse, it is essential to have scripts that can search these files for any errors or other important events. These scripts should be run regularly, ideally several times a day, and the process should be automated via the schedule manager. As with the application, the database will require menu-driven scripts that allow it to be shut down and started up. The database should never be forced down unless it is absolutely necessary, because this will cause it to perform recovery operations on startup, to clean up any jobs that were running when the database was shut down. This could take a long time if some large long-running jobs were aborted in the process.
Searching Trace Files efficiently
August 26th, 2008 7:10 pm
