microsoft / adu Goto Github PK
View Code? Open in Web Editor NEWAppliance Diagnostic Utility (ADU) for Analytics Platform System (APS)
License: MIT License
Appliance Diagnostic Utility (ADU) for Analytics Platform System (APS)
License: MIT License
It should list out replicated vs distributed size better.
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
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.
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.
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.
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 would be helpful when there are multiple appliances.
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.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.