Log File Recommendations

[TheSQLGuru]

Description of the feature, modification, idea or suggestion

A) Please add in a set of standard log file management options, such as:

1. Max file size
2. Rollover based on file size and age (number of hours, days, weeks, months)
3. Log file archival/pruning (low priority)
4. NAMING SCHEME - to include a variety of identification components (AD info, machine name, datetime (with a choice of standard date/time formatting options, possibly with their ISO names, {perhaps to include millisecond accuracy?}), etc.
5. More??

B) Log File Data Element Control:

1. Header for column names
2. Data element ordering
3. Data element separator
4. Line ending choice
5. Formatting of appropriate column(s) [datetime is the biggie here)
6. Provide more choices of data elements to include in a log row
7. Provide option to start each line with a line number, with the objective being to ensure correct event ordering as best as possible without reducing app resource usage (too much).

Proposed implementation details (optional)

Descriptive text above has some suggestions. Most details are left to the UX designer.