I need to get resource utilization data for azure sql hyperscaled database over email monthly. Can anyone help on that?

Kumar Maity, Wrishav 1 Reputation point
2020-11-22T09:10:02.45+00:00

I need to get resource utilization data for azure SQL hyperscale database over email monthly. Can anyone help on that?

Azure Monitor
Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
2,785 questions
Azure SQL Database
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Anurag Sharma 17,566 Reputation points
    2020-11-23T07:03:57.753+00:00

    Hi @Kumar Maity, Wrishav , welcome to Microsoft Q&A forum.

    This can be achieved in 2 steps process:

    1. Schedule a SQL query or stored procedure to get the resource utilization data. We can do this using an azure function where monthly schedule can be defined. There are other ways to use logic apps or webjobs.
    2. Once this function is created, SendGrid can be used to send the result of the query through the email. Azure function integration with SendGrid is available. Please refer to below links for more details on the same. We can also use any SMTP server to send mail. https://learn.microsoft.com/en-us/azure/azure-functions/functions-bindings-sendgrid?tabs=csharp
      https://learn.microsoft.com/en-in/azure/sendgrid-dotnet-how-to-send-email
      https://dibranmulder.github.io/2019/08/23/Sending-e-mails-with-SendGrid-and-Azure-Functions/

    Please let us know if this helps or else we can discuss further on the same.


    If answer helps, please 'Accept Answer' as this could help other community members having similar query.