Microsoft-Azure-SQL

Microsoft Azure SQL Server Monitoring Template

Template built by

Included Resources:

  • 1 Telegraf Configuration: azure-sql-config
  • 1 Dashboards: Azure SQL DB
  • 1 Label: mssql
  • 1 Bucket: AzureSQLDB
  • 1 Variable: SQL_Instance

Quick Install

If you have your InfluxDB credentials configured in the CLI, you can install this template with:

https://github.com/influxdata/community-templates/blob/master/azure_sql_db/azure_sql_db.yml

Azure SQL Server Monitoring Dashboard

Microsoft SQL Server is a relational database management system (RDBS) that is used for the primary purpose of storing and retrieving data as requested by other software applications. The Microsoft Azure SQL Database is a managed version of this database provided as a part of Microsoft Azure. As a managed database, all scalability, backup and high availability are provided as a service to customers.

Why monitor Microsoft Azure SQL Server

If the whole point of a managed database is to avoid the hassle of managing scalability, backup and high availability, you may wonder why you would need to monitor your managed database. There are performance issues within the database itself that could lead to performance issues of your applications. These issues are things like latency spikes, slow running queries, errors and more. Minimizing these issues helps to ensure the availability and performance of the applications that connect to your databases.

How to use Azure SQL Server Monitoring Template

Once your InfluxDB credentials have been properly configured in the CLI, you can install the Azure SQL Server Monitoring Template using the Quick Install command. Once installed, the data for the dashboard will be populated by the included Telegraf configuration, which includes the relevant MS SQL Server Telegraf Input. Note that you might need to customize the input configuration to better serve your needs, including by specifying a new input value.

Key Azure SQL Server monitoring metrics to monitor

Some of the most important Azure SQL Server monitoring metrics that you should proactively monitor include:

  • SQL Server Activity
  • Database Activity
  • Waiting Tasks
  • Memory Manage
  • Data File Size
  • Log File Size
  • Wait Types
  • Buffer Cache
  • User Connection
  • Target server Memory
  • User Memory
  • Read/Write Latency
  • Read/Write Bytes

Related Resources

Azure Storage Queue Telegraf Plugin

The Microsoft Azure Storage Queue Telegraf Plugin collects the sizes of the Microsoft Azure Storage Queues.

Windows Performance Counters Telegraf Input Plugin

The Windows Performance Counter Telegraf Input Plugin reads Performance Counters on Windows operating systems.

Event Hub Consumer Telegraf Plugin

The Azure Event Hub Consumer Telegraf Plugin allows you to collect and store all your event data, from streaming data pipelines and IoT devices, to build scalable applications.

Scroll to Top