Azure Sql

15 probes

Compliance

Probe	Description
azure_sql.compliance.sensitivity_labels	Extract sensitivity classifications from sys.sensitivity_classifications

Cost

Probe	Description
azure_sql.cost.db_size	Database and per-table storage sizes from sys.dm_db_partition_stats

Governance

Probe	Description
azure_sql.governance.permissions	Extract database-level permissions from sys.database_permissions + principals
azure_sql.governance.roles	Extract database role memberships from sys.database_role_members

Metadata

Probe	Description
azure_sql.metadata.columns	Extract column definitions from INFORMATION_SCHEMA.COLUMNS
azure_sql.metadata.constraints	Extract PK, FK, unique constraints from sys.key_constraints + sys.foreign_keys
azure_sql.metadata.procedures	Extract stored procedure and function source from sys.sql_modules
azure_sql.metadata.tables	List tables with row count and size from sys.tables + sys.partitions
azure_sql.metadata.views	Extract view definitions from sys.views + sys.sql_modules

Operations

Probe	Description
azure_sql.operations.query_stats	Top queries by CPU/reads/writes from sys.dm_exec_query_stats

Profiling

Probe	Description
azure_sql.profiling.column_stats	Column statistics: rows, rows sampled, modification counter, last updated

Quality

Probe	Description
azure_sql.quality.freshness	Table freshness from sys.dm_db_index_usage_stats (last read/write times)
azure_sql.quality.null_ratio	Column-level null count estimate from sys.dm_db_stats_histogram
azure_sql.quality.row_counts	Row counts and reserved space from sys.dm_db_partition_stats

Schema_History

Probe	Description
azure_sql.schema_history.ddl_changes	Object creation and modification dates from sys.objects