Microsoft SQL Server Telegraf Plugin logo

Microsoft SQL Server Monitoring Template

Telegraf Plugins used:

Included Resources:

  • 1 Telegraf Configuration: 'mssql-config'
  • 1 Dashboards: 'MSSQL'
  • 1 Label: 'mssql'
  • 1 Bucket: 'mssql'
  • 1 Variable: 'mssqlType'

Quick Install

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

https://raw.githubusercontent.com/influxdata/community-templates/master/mssql/mssql.yml

Microsoft SQL Server is a popular Relational Database (RDBS) that is used for storing and retrieving data as requested by mission-critical applications. Because it is such an important component of your application, having full insight into how your database is used can help you set up a baseline when analyzing performance. Poor-performing databases could cause serious customer experience issues that will lead to customer dissatisfaction and ultimately to customer abandonment.

When troubleshooting performance issues, baselines help to distinguish between abnormal and routine patterns of behaviors, link cause and effect, and even help make predictions to anticipate potential problems.

Why Microsoft SQL Server monitoring

Microsoft SQL Server is used to store and query data, and it comes with a set of optimization configurations to enhance performance. Users can configure resource use, cache queries, store tables in memory rather than on disk, and control the distribution of CPU, memory, and storage by configuring resource pools. Proactive monitoring of how effective these configurations are in your instance will help you establish its health.

Microsoft SQL Server Monitoring Dashboard

How to use the Microsoft SQL Server Monitoring Template

Once your InfluxDB credentials have been properly configured in the CLI, you can install the Microsoft 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 metrics input. Note that you might need to customize the input configuration to better serve your needs if you are running an Azure managed instance. All of this will depend on how your organization is currently running.

To find out more information about environmental variables within the Telegraf configuration, consult the following link.

Key Microsoft SQL Server monitoring metrics to collect

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

  • Uptime
  • Current Queries
  • Active Threads
  • Connections
  • Locks
  • Traffic
  • CPU Usage/Idle

Related Resources

Microsoft SQL Server Telegraf Plugin

Using the Microsoft SQL Server Telegraf plugin to monitor the state of your instance

InfluxDB Cloud on Azure

Get the full Azure experience by collecting your Microsoft SQL Server in an InfluxDB Cloud instance on MS Azure.

Integrated with Azure services and products

InfluxDB integrates with multiple Azure services to streamline accumulation, analysis and actions resulting from time series data.

Scroll to Top