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

Question

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

Answer 1

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.