Microsoft SQL Server advanced settings

You can use the following advanced settings to fine tune sources.

Parameter Default value Description
Limit to supported EPS true When you use automatic tuning, the maximum tuning levels does not exceed the maximum supported EPS.
SQL
  • Filename pattern
* A mask/filter to categorize files into this file class. You can select * (many chars) ? (one char), # (a number), or a regex.
  • SQL_fldList
Date,Time,Source,Message:Last=TakeRest The CSV fields to include in the payload. Use #FIELDS to grab first line in the file that starts with #Fields. Use #HDL_LINES to grab list of fields from file header.
  • SQL_fldListSep
  The field list separator handles \t, XML, KEYED (CSV), or NCSA.