Supporting system views in a Synapse SQL pool

System views are built-in views in SQL that are used to monitor the health of a SQL pool and diagnose problems associated with the performance of a SQL pool.

Synapse SQL supports various system views, and we will be covering a few of these in this section, as follows:

• sys.pdw_column_distribution_properties: Holds distribution information for columns.
• sys.pdw_distributions: Holds information about the distributions on the appliance. It lists one row per appliance distribution.
• sys.pdw_index_mappings: Maps the logical indexes to the physical name used on compute nodes, as reflected by a unique combination of the object_id of the table holding the index and the index_id of a particular index within that table.
• sys.pdw_loader_backup_run_details: Contains information about ongoing and completed backup and restore operations in Azure Synapse Analytics (SQL Data Warehouse).
• sys.pdw_loader_backup_runs: This is similar...