Databases in Azure – Auditing

Auditing
Azure SQL Database Auditing tracks database events and writes them to an audit log in your Azure Storage account. Auditing can help you maintain regulatory compliance, understand database activity, and gain insight into discrepancies and anomalies that could indicate business concerns or suspected security violations.

SQL Database Auditing allows you to:
Retain an audit trail of selected events
Report on database activity
Analyze reports

Threat Detection
Threat Detection detects anomalous database activities indicating potential security threats to the database.
You can use auditing to explore the suspicious events and determine if they result from an attempt to access, breach or exploit data in the database.

Alert Rules
You can receive an alert based on monitoring metrics or events. When the value of an alert rule crosses an assigned threshold, the alert rule becomes active and can send a notification. For an alert rule on events, a rule can send a notification on every event, or, only when a certain number of events happen.

SQL Database alert values and thresholds

Dynamic Management Views
Microsoft Azure SQL Database enables a subset of dynamic management views to diagnose performance problems.

Use dynamic management views to detect a few common query performance problems:
Monitor query performance
Monitor connections
Monitor query plans

Leave a Reply