Posts
Sort by recent activity
Monitoring Hyperscale secondary replicas
We currently have an Azure SQL Hyperscale database with a single HA replica which we use for read-only query workloads.We have experimented with monitoring a named replica, which works well. But is...
Schedule monitoring of Azure SQL DB serverless databases
We have a few serverless Azure SQL databases that automatically pause after 1 hour of inactivity. However SQL monitor seems to keep them awake. Is there anyway that we could automatically schedule ...
Long-running query alerts being regularly sent, but can't find queries
At the same time every 3 hours (e.g. 0203, 0503, 0803) on one of our Azure Hyperscale SQL databases there are approx 1000 long-running query alerts generated for a simple insert query that runs man...
Can't see database backup / verify in top 10 queries on Server Host Metrics page
Yesterday I ran a (native) database backup followed by an immediate backup verify. It ran for about 4 hours in total and the verify caused the CPU to max out to 100%. It was clear what the cause of...