Database Monitoring for SQL Server on Google Cloud SQL

USE [master];
CREATE LOGIN atatus WITH PASSWORD = '<YourSecurePassword>';
GO

GRANT VIEW SERVER STATE TO atatus AS CustomerDbRootRole;
GRANT VIEW ANY DEFINITION TO atatus AS CustomerDbRootRole;
ALTER SERVER ROLE CustomerDbRootRole DROP MEMBER atatus;
GO

USE [<your_database_name>];
CREATE USER atatus FOR LOGIN atatus;
GO

USE [msdb];
CREATE USER atatus FOR LOGIN atatus;

GRANT SELECT ON dbo.log_shipping_monitor_primary TO atatus;
GRANT SELECT ON dbo.log_shipping_monitor_secondary TO atatus;

GRANT SELECT ON dbo.sysjobs TO atatus;
GRANT SELECT ON dbo.sysjobhistory TO atatus;
GRANT SELECT ON dbo.sysjobactivity TO atatus;
GO

metrics:
  - hosts:
      - "<CLOUD_SQL_INSTANCE_IP>"
    port: 1433
    username: atatus
    password: <YourSecurePassword>
    dbm: true

sudo service atatus-infra-agent restart

metrics:
  - hosts:
      - "<CLOUD_SQL_INSTANCE_IP>"
    port: 1433
    username: <DB_USERNAME>
    password: <DB_PASSWORD>
    dbm: true
    dbm_mssqlserver_options:
      collect_settings:
        enabled: true
      collect_database_info:
        enabled: true
        auto_discovery: true
        # include:
        #   - db_name1
        #   - db_name2
        # exclude:
        #   - db_name1
        #   - db_name2

metrics:
  - hosts:
      - "<CLOUD_SQL_INSTANCE_IP>"
    port: 1433
    username: <DB_USERNAME>
    password: <DB_PASSWORD>
    dbm: true
    dbm_mssqlserver_options:
      additional_metrics_options:
        custom_queries:
          - query: SELECT age, salary, hours_worked, name FROM hr.employees;
            columns:
              - name: custom.employee_age
                type: gauge
              - name: custom.employee_salary
                type: gauge
              - name: custom.employee_hours
                type: count
              - name: name
                type: tag
            tags:
              - 'table:employees'
        max_custom_queries: 20