Monitor applications with azdata and Grafana Dashboard
Important
The Microsoft SQL Server 2019 Big Data Clusters add-on will be retired. Support for SQL Server 2019 Big Data Clusters will end on February 28, 2025. All existing users of SQL Server 2019 with Software Assurance will be fully supported on the platform and the software will continue to be maintained through SQL Server cumulative updates until that time. For more information, see the announcement blog post and Big data options on the Microsoft SQL Server platform.
Grafana is one of the best cloud-native virtualization tools, which can be used to provide various monitoring metrics of your application running in Kubernetes.
This article describes how to monitor an application inside a SQL Server Big Data Cluster.
Important
The Internet Explorer browser and older Microsoft Edge browsers are not compatible with Grafana. In Grafana, you will see a black page with errors when using an unsupported browser. Consider the Chromium-based Microsoft Edge, or review the supported browsers for Grafana.
Prerequisites
Capabilities
In SQL Server 2019 you can create, delete, describe, initialize, list run and update your application. The following table describes the application deployment commands that you can use with azdata.
| Command | Description |
|---|---|
azdata bdc endpoint list |
Lists the endpoints for the Big Data Cluster. |
You can use the following example to list the endpoint of Grafana dashboard:
azdata bdc endpoint list --endpoint-name metricsui
The output will give you the endpoint, which you can use your cluster username and password to log in.
When you open the dashboard, go to the Host Apps Metrics, where you'll get more insights about your application and keep in track.
To get more insight about a single pod of the application ( in some cases you have multiple copies of your application), please go to the Host Pods Metrics and choose the pod respect, you'll get a view of metrics as follows:
Next steps
You can check out additional samples at App Deploy Samples.
For more information about SQL Server Big Data Clusters, see Introducing SQL Server 2019 Big Data Clusters.