Grafana Cloud Enterprise Open source

Microsoft SQL Server (MSSQL) data source

Grafana ships with built-in support for Microsoft SQL Server (MSSQL). You can query and visualize data from any Microsoft SQL Server 2005 or newer, including Microsoft Azure SQL Database.

Use this data source to create dashboards, explore SQL data, and monitor MSSQL-based workloads in real time.

The following documentation helps you get started working with the Microsoft SQL Server (MSSQL) data source:

Supported versions

This data source supports the following Microsoft SQL Server versions:

  • Microsoft SQL Server 2005 and newer
  • Microsoft Azure SQL Database
  • Azure SQL Managed Instance

Grafana recommends using the latest available service pack for your SQL Server version for optimal compatibility.

Key capabilities

The Microsoft SQL Server data source supports:

  • Time series queries: Visualize metrics over time using the built-in time grouping macros.
  • Table queries: Display query results in table format for any valid SQL query.
  • Template variables: Create dynamic dashboards with variable-driven queries.
  • Annotations: Overlay events from SQL Server on your dashboard graphs.
  • Alerting: Create alerts based on SQL Server query results.
  • Stored procedures: Execute stored procedures and visualize results.
  • Macros: Simplify queries with built-in macros for time filtering and grouping.

Additional resources

After configuring the Microsoft SQL Server data source, you can:

  • PostgreSQL - For PostgreSQL databases.
  • MySQL - For MySQL and MariaDB databases.