Alibaba Cloud Managed Service for Prometheus allows you to install and configure SQL Server exporters. Managed Service for Prometheus also provides out-of-the-box dashboards that you can use to monitor SQL Server instances. This topic describes how to install and configure a SQL Server exporter in Managed Service for Prometheus.
Prerequisites
A Prometheus instance for Container Service is created. For more information, see Create a Prometheus instance to monitor an ACK cluster.
Background information
Managed Service for Prometheus allows you to monitor self-managed SQL Server instances deployed in Container Service for Kubernetes (ACK) clusters, ACK Serverless clusters, or registered Kubernetes clusters.
Entry points
Entry point 1
- Log on to the ARMS console.
- In the left-side navigation pane, choose .
Click the name of the Prometheus instance instance that you want to manage to go to the Integration Center page.
Entry point 2: Access Center
Log on to the Application Real-Time Monitoring Service (ARMS) console.
In the left-side navigation pane, click Access Center. In the Application Components section, find SQLServer and click Install or Add. In the panel that appears, install and configure a SQL Server exporter as prompted.
Install and configure a SQL Server exporter
This section describes how to enable the SQL Server component in the integration center of the Prometheus instance.
Install or add the SQL Server component.
If this is the first time that you install the SQL Server component, perform the following operation.
In the Not Installed section of the Integration Center page, find SQLServer and click Install.
If you have installed the SQL Server component, you must add the component again.
In the Installed section of the Integration Center page, find SQLServer and click Add.
On the Settings tab in the STEP2 section, configure the parameters and click OK. The following table describes the parameters.
Parameter
Description
Exporter Name
The unique name of the SQL Server exporter. The name must meet the following requirements:
It can contain only lowercase letters, digits, and hyphens (-), and cannot start or end with a hyphen (-).
It must be unique.
NoteIf you do not specify this parameter, the system uses the default name, which consists of the exporter type and a numeric suffix.
sqlserver address
The endpoint of the SQL Server instance.
sqlserver port
Valid values: 1 to 65535.
sqlserver username
The username of the SQL Server instance.
sqlserver password
The password of the SQL Server instance.
Metrics scrape interval (seconds)
The interval at which monitoring data is collected. Unit: seconds. Default value: 30.
NoteYou can view the monitoring metrics on the Metrics tab in the STEP2 section.
View the status of the SQL Server exporter
The installed components are displayed in the Installed section of the Integration Center page. Click the component. In the panel that appears, you can view information such as targets, metrics, dashboard, alerts, service discovery configurations, and exporters. For more information, see Integration center.
Targets
On this tab, you can view the list of targets discovered by the default jobs.
Metrics
On this tab, you can view metric data and discard metrics. For more information, see Configure metrics.
Dashboards
On this tab, you can click the thumbnail of a dashboard to go to the Grafana console and view the details of the dashboard.
Alerts
On this tab, you can view the alerts of the SQL Server instance. You can also create alert rules based on your business requirements. For more information, see Create an alert rule for a Prometheus instance.
Service Discovery Configurations
On this tab, you can manage the default basic monitoring jobs. For example, you can modify the interval at which metrics are captured or disable collection jobs. For more information, see Manage service discoveries.
Exporter
On this tab, you can view the SQL Server exporters and the version of each exporter.