I am unable to view the storage_percent metrics for Azure SQL Database alerts, which was previously accessible.

Question

unable to view the storage_percent metrics for Azure SQL Database alerts, which was previously accessible. Also looking for clarification on the differences between log search alerts and metric alerts, along with recommendations for creating alerts on SQL databases.

Answer 1

To resolve the visibility issue of storage_percent metrics, navigate to the Metrics section within your Azure SQL Database resource. Look for the 'Data Space Used' metric to monitor storage usage. To create a new alert rule, specify a threshold value for this metric and select or create an action group with an email address to receive notifications. For understanding the differences and deciding between log search and metric alerts, consider that log search alerts are based on the results of a query run on your log data, suitable for complex conditions, whereas metric alerts are triggered by specific metric thresholds being crossed, ideal for straightforward performance monitoring.