Activity overview
Latest activity by Severn
Thanks Ben. As mentioned named replicas work well at least. / comments
Thanks Ben. As mentioned named replicas work well at least.
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...
Thanks Robyn, I wasn't aware I could do that and, what's more, that there were examples in the configuration menu! Have found an example that does just what I want and will give it a go. / comments
Thanks Robyn, I wasn't aware I could do that and, what's more, that there were examples in the configuration menu! Have found an example that does just what I want and will give it a go.
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 ...
Hi @Alex B - thanks so much for your reply. I am on 12.1.2.23581 so will update and see if it fixes the issue. / comments
Hi @Alex B - thanks so much for your reply. I am on 12.1.2.23581 so will update and see if it fixes the issue.
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...
Cheers Alex - didn't realise a query plan was a pre-requisite to appear in the list. Thanks for your response. / comments
Cheers Alex - didn't realise a query plan was a pre-requisite to appear in the list. Thanks for your response.
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...