I'm currently setting up Azure SQL DB monitor, and I'm looking for any input of best practices here.
I believe there are two ways to monitor the DB metrics:
- SAM powershell based monitor: https://documentation.solarwinds.com/en/success_center/sam/content/sam-api-poller-microsoft-azure-sql-database.htm
- SAM API poller: documentation.solarwinds.com/.../sam-api-poller-microsoft-azure-sql-database.htm
I'm looking at the example in Orion Demo: https://oriondemo.solarwinds.com/Orion/NetPerfMon/NodeDetails.aspx?NetObject=N:141, and it's using the API poller. I don't really the way it looks, especially when you have multiple instances then it can easily get too cluttered.
Appreciate if anyone can share their approach on Azure SQL DB monitoring using SAM, like probably what monitor are you using (API poller vs SAM PS monitor), and how it looks?