The Microsoft Toolkit for SQL Data Warehouse offers a set of views and procedures that help you optimize your Azure Synapse Analytics SQL Pool (formerly SQL Data Warehouse).
The toolkit installs the following items:
- Microsoft schema: The microsoft schema contains all of the toolkit objects.
- Procedures: The toolkit includes procedures for identifying and generating statistics.
- Views: The toolkit includes views for monitoring indexes, statistics, and many other features.