Azure Sql
=========

**15 probes**


Compliance
----------

.. list-table::
   :header-rows: 1
   :widths: 40 60

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

Cost
----

.. list-table::
   :header-rows: 1
   :widths: 40 60

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

Governance
----------

.. list-table::
   :header-rows: 1
   :widths: 40 60

   * - 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
--------

.. list-table::
   :header-rows: 1
   :widths: 40 60

   * - 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
----------

.. list-table::
   :header-rows: 1
   :widths: 40 60

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

Profiling
---------

.. list-table::
   :header-rows: 1
   :widths: 40 60

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

Quality
-------

.. list-table::
   :header-rows: 1
   :widths: 40 60

   * - 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
--------------

.. list-table::
   :header-rows: 1
   :widths: 40 60

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