microsoft / adu Goto Github PK

When running a Wellness Check, the "Number_PDs_in_VD" option does not appear to try the workaround regarding a reporting bug in storage spaces and therefore it does report a failure.

When running just the Storage_Health_Check option, it tries the workaround and does not report a failure.

Default timeout is making it not collect for some databases. add -queryTimeout 0 to all invoke-sqlcmds

It should list out replicated vs distributed size better.

Wellness checks collects all the storage info before asking fo rthe domian admin password for running PAV. If PAV was selected, it should be moved to the front and executed first so the engineer doesn't have to wait.

The output of the Table Skew report is not working. I ran the report for a number of individual databases and the results were appended to the same TableSkewReport file.

The actual data for each database is truncated, with most of my databases only showing the skew percent and no row counts or space info. This report is unusable as is.

There are important files that Microsoft projects should all have that are not present in this repository. A pull request has been opened to add the missing file(s). When the pr is merged this issue will be closed automatically.

Microsoft teams can learn more about this effort and share feedback within the open source guidance available internally.

Merge this pull request

For $totalRows variable when it comes to distributed tables. Right now it is just grabbing the total rows from one distribution. CG P1 has the correct version.

it would be helpful when there are multiple appliances.

The log files are not written to disk... Output path supplied in the PS window does not exist on disk (I tested this with a number of databases.

In addition, printed output is suspect. For some of my databases the Allocated Space is 10x larger than the size in DB settings...

Some examples:

Gathering Settings data for DB: XXX
Total Distributed Size: 600 GB's
Total Replicated Size: 100 GB's
Total Log Size: 60 GB's
AutoGrow Setting: On
Original Create Database Command:
Create Database XXX with (Replicated_size=100, Distributed_Size=600, Log_Size=60, AutoGrow=On);

Gathering Usage data for DB: XXX
Allocated Space (Reserved): 6042.36 GB
Data space (Used): 2397.89 GB
Allocated Unused Space(Unused data space): 3644.47 GB

Gathering Settings data for DB: YYY
Total Distributed Size: 600 GB's
Total Replicated Size: 100 GB's
Total Log Size: 60 GB's
AutoGrow Setting: On
Original Create Database Command:
Create Database YYY with (Replicated_size=100, Distributed_Size=600, Log_Size=60, AutoGrow=On);

Gathering Usage data for DB: YYY
Allocated Space (Reserved): 6042.14 GB
Data space (Used): 3017.25 GB
Allocated Unused Space(Unused data space): 3024.89 GB