Azure SQL DB Monitoring

Hi, 

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:

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?

Thank you

Parents
  • I am starting down this voyage right now. I was able to get my APIs setup so Solarwinds reaching a little bit into Azure but have yet to figure out how to monitor the SQL databases.  If I get it figured out I will post here or maybe someone else will have it figured out.

  • One of the thing that I'm not sure is where I should assign the template. We have multiple SQL instances in multiple different resource groups (RGs) for different dept/groups. For granularity, I think I'll at least assign the template to one node that represent one RGs, or perhaps setup one node for each SQL server of the instances. But I'm not sure if this is the best approach.

    As for the monitoring for the SQL database itself, I think I agree with Seashore, that is to do a T-SQL query against the SQL instance. 

Reply
  • One of the thing that I'm not sure is where I should assign the template. We have multiple SQL instances in multiple different resource groups (RGs) for different dept/groups. For granularity, I think I'll at least assign the template to one node that represent one RGs, or perhaps setup one node for each SQL server of the instances. But I'm not sure if this is the best approach.

    As for the monitoring for the SQL database itself, I think I agree with Seashore, that is to do a T-SQL query against the SQL instance. 

Children
No Data