Monitoring multiple MSSQL server databases

Please find below information and help with how I can create a dashboard that meets client’s requirement:

  • What Grafana version and what operating system are you using?
    Grafana version: 11.3.0
    OS: CentOS

  • What are you trying to achieve?
    A consolidated dashboard showing the below values for various MSSQL databases that our client uses:

Database Growth Tracking
Live/Active Sessions
Long-running Queries Detection
DPA for In-depth Analysis

Client is not interested in checking the details of each of the databases separately.
The dashboard should look similar to the consolidated dashboard available for windows servers:
windows_exporter for Prometheus Dashboard EN v20231002-SeiyaGame | Grafana Labs

  • How are you trying to achieve it?
    We tried customizing few of the already available database related dashboards.
    Microsoft SQL Server | Grafana Labs

  • What happened?
    We are not able to achieve single consolidated dashboard.