Can you help monitor our SQL Databases? We are on it! We have a list of pre-configured alerts we can deploy immediately. Additionally, Tridius is a Microsoft Gold Partner specializing in servicing the Azure space configuration, security, and monitoring.
First let’s ensure we understand what your databases need alerted on. Generally, items like CPU and Memory can impact performance, but do you have any logs you need to alert on as well? If you are not sure, that’s okay, we are here to help you!
Below are great resources from Microsoft regarding their journey for adopting Azure Monitor as well as a GitHub toolkit to get you started with configuring your alerts:
As you can see there are various alerts that could be configured quickly utilizing Log Analytics and Kusto Query Language (KQL). Specifically, there is a configuration outlining the KQL required to alert on various potential SQL Database issues. Now we have a starter pack for you to begin your Azure Monitoring!
Next, we need to decide where to send these alerts. We don’t want to miss these important alert notifications. We recommend enabling the responsible team for the resource to monitor their implementation(s). Alerts should be actionable when we configure them. If we just need to be aware, we could use Workbooks, Insights, or Dashboards. It is a clever idea to create alerts that correspond with your reporting needs as well.
We can certainly move forward with implementing this and expanding on an as-needed basis. Interestingly, these resources are geared toward using Azure Monitor with Log Analytics / KQL. Here at Tridius, we don’t like surprises when it comes to cost and I’m sure you wouldn’t either.
Unfortunately, KQL is two times more expensive than metric alerting. Additionally, KQL doesn’t utilize real-time metrics, so there may be a need to create additional monitoring to get a holistic view of your environment. Now we have a new challenge on our hands, cost reduction!
How do we ensure we are only enabling what we need? Don’t worry, Tridius is here to help you every step of the way! We have many ways to assist with your monitoring needs. From setting up custom monitoring, to fully managing your Azure environment.
Let Tridius inspire your team to innovate and provide solutions that will improve your business! Learn more about how we can transform your business and make the best of your Microsoft Azure journey.
Tridius Technologies (a Terralogic Company) is an IT consulting firm that blends strategic planning with technology innovation, in areas like Cloud Infrastructure, Application Development,
Managed Services and Dynamics 365. Our mission is to inspire, innovate and improve.
Azure Monitor Alert