-
Notifications
You must be signed in to change notification settings - Fork 106
Closed
Description
An issue is happening when importing data related to missing indexes to table tbl_MissingIndexes. Values from column many columns, like improvement_measure, are being imported as NULL. Probably this is related to number decimal format.
Confirmed the columns have the data in the output file generated by Log Scout
We also found an issue on tbl_dm_db_stats_properties. Some columns, like the rows, are defined as INT in the rowsetimportengine and data from large tables are being imported as NULL
<Rowset name="tbl_dm_db_stats_properties" enabled="true" identifier="-- sys.dm_db_stats_properties --" type="RowsetImportEngine.TextRowset">
<Column name="input_file_name" type="RowsetImportEngine.VarCharColumn" length="512" valuetoken="INPUTFILENAME" />
<Column name="rownum" type="RowsetImportEngine.BigIntColumn" length="24" valuetoken="ROWNUMBER" />
<Column name="database_id" type="RowsetImportEngine.IntColumn" />
<Column name="database_name" type="RowsetImportEngine.NVarCharColumn" />
<Column name="schema_name" type="RowsetImportEngine.NVarCharColumn" />
<Column name="object_name" type="RowsetImportEngine.NVarCharColumn" />
<Column name="object_id" type="RowsetImportEngine.IntColumn" />
<Column name="stats_id" type="RowsetImportEngine.IntColumn" />
<Column name="statistics_name" type="RowsetImportEngine.NVarCharColumn" />
<Column name="last_updated" type="RowsetImportEngine.DateTimeColumn" />
<Column name="rows" type="RowsetImportEngine.IntColumn" />
<Column name="rows_sampled" type="RowsetImportEngine.IntColumn" />
<Column name="steps" type="RowsetImportEngine.IntColumn" />
<Column name="unfiltered_rows" type="RowsetImportEngine.IntColumn" />
<Column name="modification_counter" type="RowsetImportEngine.IntColumn" />
<Column name="persisted_sample_percent" type="RowsetImportEngine.FloatColumn" />
</Rowset>
Reactions are currently unavailable


