Where Azure SQL monitoring data goes: Storage vs Log Analytics vs Event Hubs vs database watcher store

This sheet compares Azure Storage account, Log Analytics workspace, Event Hubs, Azure Data Explorer / Fabric RTA.

CriterionAzure Storage accountLog Analytics workspaceEvent HubsAzure Data Explorer / Fabric RTA
Best forLong-term archivalQuerying and alerting via Azure MonitorStreaming to a SIEM or real-time pipelineDatabase watcher central data store

The verdict, the full comparison, 4 rules and 2 traps are part of DP-300 access. Unlock DP-300.