Activity overview
Latest activity by postledm
It's an Azure SQL database in WE with a read only replica in NE. Part of a Azure SQL failover group / comments
It's an Azure SQL database in WE with a read only replica in NE. Part of a Azure SQL failover group
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
system MI / comments
system MI
If this by design then you should update your documentation and probably put a help message on the screen in monitor. I have also seen that MI only works on the Monitor server if I use the localhost web address. If I use the FQDN alias for our Monitor that adda BD using MI fails / comments
If this by design then you should update your documentation and probably put a help message on the screen in monitor.I have also seen that MI only works on the Monitor server if I use the localhost...
you can find the log files from when I was setting up Monitor on ticket 317960 / comments
you can find the log files from when I was setting up Monitor on ticket 317960
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...