Posts
Sort by recent activity
Azure failover database showing exactly same data as primary
This is weird.I have added a new Azure SQL database that has a replication partner. (not built by me)Users connect to the failover group nameMonitor shows the same activity on the DR database as th...
How does one monitor an Azure SQL read only replica ?
When we connect using SSMS etc. we would add this parameter to the conenction stringApplicationIntent=ReadOnly
Query Store and Monitor not aligned
Overnight Azure database hit 90%+ cpu regularly for several hours. Monitor reports and alerts on the excessive cpuBut I can't find a query that would be culpritLooked in Query Store and there are t...
Azure Disk space report
How do I create a report that shows % free space over time for my Azure SQL databases so I can see when they are expected to run out of space
Azure Database with managed identity error
If I add a new Azure SQL database with system managed identity using the website on the Monitor server then it works fine.If I try and add it from the browser on my desktop then it fails. It's almo...