Not too long ago Microsoft introduced Azure Monitor SQL Insights for Azure SQL in public preview. With preview, prospects will profit from a versatile canvas for telemetry assortment, evaluation, and wealthy customized visualization.
SQL Insights is an agent-based distant monitoring resolution that Microsoft’s Azure SQL and Azure Monitor groups have developed collaboratively. The agent makes use of an open supply agent known as Telegraf and helps SQL Server operating in a digital machine (VM), Azure SQL Database, and Azure SQL Managed Cases. The agent runs on devoted monitoring digital machines to remotely acquire knowledge for SQL PaaS and SQL IaaS deployments. Moreover, SQL Insights shops its knowledge in Azure Monitor Logs (Workspace), which permits customers to carry out knowledge aggregation, filtering, and evaluation.
Earlier than customers can activate SQL Insights, they need to create a workspace or choose an current one. Subsequent, they should create a monitoring consumer on the SQL deployment they need to monitor, create a digital machine that will probably be used to gather knowledge to watch SQL, configure community settings, and create a monitoring profile by deciding on SQL (preview) in Insights part of the Azure Monitor menu within the Azure portal.
“Monitoring is finished from an Azure VM that connects to your SQL deployments and makes use of dynamic administration views (DMVs) to gather monitoring knowledge.”
Further VM wanted 🙁
Be aware that Microsoft isn’t the one cloud supplier to have a database observability service on its cloud platform. Beforehand Google launched Cloud SQL Insights, a easy and open device that helps builders perceive and rapidly resolve database efficiency points on Cloud SQL. And AWS has Efficiency overview, a database efficiency monitoring and optimization characteristic that permits builders to rapidly assess their database load and decide when and the place to behave.
With SQL Insights, Azure prospects will profit from options akin to:
- Choices for selecting which knowledge to gather
- Management the info retention coverage
- Visualize the info utilizing Azure Monitor Workbooks
- Create separate Information assortment guidelines for every atmosphere
- Integration with open-source monitoring options (Telegraf)
- Uncover over 2 hundred new metrics
Lastly, Azure prospects is not going to incur fees for direct use of SQL Insights. They are going to get accused for its exercise within the Log Analytics workspace (knowledge ingested by brokers and saved within the workspace) and the alerts and notifications configured on the log knowledge. The service is at the moment in preview for SQL databases from model 2012 and later, SQL Managed Occasion, and SQL Server on Azure VMs.