Create, Clean-up/deduplicate AG-related XML rowsets in the RowsetImportEngine\TextRowset.xml #157
Description
These rowsets are not really defined with columns. But also for tbl_availability_groups there is already a rowset defined
- There is one defined for this, so delete this:
<Rowset name="tbl_availability_groups" enabled="true" identifier="--sys.availability_groups--" type="RowsetImportEngine.TextRowset">
</Rowset>
- Define this one if needed and make sure there is data collected for it in PSSDIAG/SQL LogScout
<Rowset name="tbl_dm_hadr_availability_replica_states" enabled="true" identifier="--sys.dm_hadr_availability_replica_states--" type="RowsetImportEngine.TextRowset">
</Rowset>
- There is another one defined for it, so delete this:
<Rowset name="tbl_availability_replicas" enabled="true" identifier="--sys.availability_replicas--" type="RowsetImportEngine.TextRowset">
</Rowset>
See related on the data collection side: microsoft/DiagManager#162