Global Overview

An overall view of your SQL Server estate

The Global Overview dashboard is your entry point to the SQL Server infrastructure: it provides an at-a-glance view of all the instances, along with useful performance metrics.

At the top left of the dashboard, you have KPIs for the total number of monitored instances, divided between on-premises and Azure instances. At the top right you have the same KPI for the total number of monitored databases, again divided between on-premises and Azure.

The middle of the dashboard contains the Instances Overview table, with the following information:

  • SQL Instance: The name of the instance. For on-premises SQL Servers, this corresponds to the name returned by @@SERVERNAME, except that the backslash is replaced by a colon in named instances (you have SERVER:INSTANCE instead of SERVER\INSTANCE).
    For Azure SQL Managed Instances and Azure SQL Databases, the name is the network name of the logical instance.
  • Database: for Azure SQL Databases, the name of the database
  • Elastic Pool: for Azure SQL Databases, the name of the elastic pool if in use, <No Pool> otherwise.
  • Database Count: the number of databases in the instance
  • Edition: the edition of SQL Server (Enterprise, Standard, Developer, Express). For Azure SQL Databases it is “Azure SQL Database”. For Azure SQL Managed Instances, it can be GeneralPurpose or BusinessCritical.
  • Version: The version of SQL Server. For Azure SQL Database it contains the service tier (Basic, Standard, Premium…)
  • Last CPU: the last value captured for CPU usage in the selected time interval
  • Average CPU: the average CPU usage in the time interval
  • Lowest disk space %: the percent of free space left in the disk that has the least space available. For Azure SQL Databases and Azure SQL Managed Instances the percentage is calculated on the maximum space available for the current tier.

At the bottom of the dashboard, you have the detail of the disk space available on all instances. The table contains the following information:

  • SQL Instance: the name of the instance, Azure SQL Database or Azure SQL Managed Instance.
  • Database: for Azure SQL Databases, the name of the database
  • Elastic Pool: for Azure SQL Databases, the name of the elastic pool if in use, <No Pool> otherwise.
  • Volume: drive letter or mount point of the volume
  • Free %: Percentage of free space in the volume
  • Available Space: Available space in the volume. The unit measure is included in the value.
  • Used Space: Used space in the volume
  • Total Space: Size of the Volume (Used space + Available space)