Cloud SQL is a fully managed database service that makes it easy to set up, maintain, manage, and administer relational PostgreSQL, MySQL, and SQL Server databases in the cloud.ass security.
Setup
To set up the Google integration and discover the Google service,
go to Google Integration Discovery Profile and select Cloud SQL.
Supported metrics
GCP SQL Instance
| New OpsRamp Metric | Google Metric | Metric Display Name | Unit | Description |
|---|---|---|---|---|
| google_cloudsql_database_auto_failover_request_count | cloudsql.googleapis.com/database/auto_failover_request_count | Auto-failover Requests | count | Delta of number of instance auto-failover requests. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_available_for_failover | cloudsql.googleapis.com/database/available_for_failover | Available for failover | count | This is > 0 if the failover operation is available on the instance. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_cpu_reserved_cores | cloudsql.googleapis.com/database/cpu/reserved_cores | CPU reserved cores | count | Number of cores reserved for the database. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_cpu_usage_time | cloudsql.googleapis.com/database/cpu/usage_time | CPU usage | CPU seconds | Cumulative CPU usage time in seconds. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_cpu_utilization | cloudsql.googleapis.com/database/cpu/utilization | CPU utilization | % | Current CPU utilization represented as a percentage of the reserved CPU that is currently in use. Values are typically numbers between 0.0 and 1.0 (but might exceed 1.0). Charts display the values as a percentage between 0% and 100% (or more). Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_data_cache_bytes_used | cloudsql.googleapis.com/database/data_cache/bytes_used | Data cache used | bytes | Data cache usage in bytes. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_data_cache_quota | cloudsql.googleapis.com/database/data_cache/quota | Data cache quota | bytes | Maximum data cache size in bytes. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_disk_bytes_used | cloudsql.googleapis.com/database/disk/bytes_used | Bytes used | bytes | Data utilization in bytes. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_disk_provisioning_iops | cloudsql.googleapis.com/database/disk/provisioning/iops | Provisioned IOPS | count | Provisioned IOPS for the data disk. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_disk_provisioning_throughput | cloudsql.googleapis.com/database/disk/provisioning/throughput | Provisioned throughput | count | Provisioned throughput for the data disk. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_disk_quota | cloudsql.googleapis.com/database/disk/quota | Disk quota | bytes | Maximum data disk size in bytes. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_disk_read_bytes_count | cloudsql.googleapis.com/database/disk/read_bytes_count | Disk read bytes | count | Delta count of data disk read IO bytes. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_disk_read_ops_count | cloudsql.googleapis.com/database/disk/read_ops_count | Disk read IO | count | Delta count of data disk read IO operations. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_disk_utilization | cloudsql.googleapis.com/database/disk/utilization | Disk utilization | count | The fraction of the disk quota that is currently in use. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_disk_write_bytes_count | cloudsql.googleapis.com/database/disk/write_bytes_count | Disk write bytes | count | Delta count of data disk write IO bytes. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_disk_write_ops_count | cloudsql.googleapis.com/database/disk/write_ops_count | Disk write IO | count | Delta count of data disk write IO operations. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_instance_state | cloudsql.googleapis.com/database/instance_state | Instance state | count | The current serving state of the Cloud SQL instance. Because there are seven possible states, seven data points are returned. Each of them has a different field value representing each state. Only the one that matches the current state of the instance is TRUE. All the others are FALSE. The state can be one of the It is not currently running, but it's ready to be restarted. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_memory_quota | cloudsql.googleapis.com/database/memory/quota | Memory quota | bytes | Maximum RAM size in bytes. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_memory_total_usage | cloudsql.googleapis.com/database/memory/total_usage | Total memory usage | bytes | Total RAM usage in bytes. This metric reports the RAM usage of the database process, including the buffer/cache. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_memory_usage | cloudsql.googleapis.com/database/memory/usage | Memory usage | bytes | RAM usage in bytes. This metric reports the RAM usage of the server, excluding the buffer/cache. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_memory_utilization | cloudsql.googleapis.com/database/memory/utilization | Memory utilization | count | The fraction of the memory quota that is currently in use. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_swap_bytes_used | cloudsql.googleapis.com/database/swap/bytes_used | Swap space usage | bytes | Swap space used by the database container. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_swap_pages_swapped_in_count | cloudsql.googleapis.com/database/swap/pages_swapped_in_count | Pages Swapped In Count | bytes | Total count of pages swapped in of disk since the system was booted. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_swap_pages_swapped_out_count | cloudsql.googleapis.com/database/swap/pages_swapped_out_count | Pages Swapped Out Count | bytes | Total count of pages swapped out of disk since the system was booted. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_up | cloudsql.googleapis.com/database/up | Server up | count | Indicates if the server is up or not. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_uptime | cloudsql.googleapis.com/database/uptime | Uptime | seconds | Delta count of the time in seconds the instance has been running. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_replication_log_archive_failure_count | cloudsql.googleapis.com/database/replication/log_archive_failure_count | Number of log archival failures. | count | Number of failed attempts for archiving replication log files. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_replication_log_archive_success_count | cloudsql.googleapis.com/database/replication/log_archive_success_count | Number of log archival successes. | count | Number of successful attempts for archiving replication log files. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_replication_network_lag | cloudsql.googleapis.com/database/replication/network_lag | Network lag | seconds | Indicates time taken from primary binary log to IO thread on replica. Only applicable to replicas. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_replication_replica_lag | cloudsql.googleapis.com/database/replication/replica_lag | Replication lag | seconds | Number of seconds the read replica is behind its primary (approximation). A negative value indicates that replication is inactive. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_network_connections | cloudsql.googleapis.com/database/network/connections | Cloud SQL Connections | count | Number of connections to databases on the Cloud SQL instance. Only applicable to MySQL and SQL Server. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_network_received_bytes_count | cloudsql.googleapis.com/database/network/received_bytes_count | Received bytes | bytes | Delta count of bytes received through the network. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_network_sent_bytes_count | cloudsql.googleapis.com/database/network/sent_bytes_count | Sent bytes | bytes | Delta count of bytes sent through the network. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
GCP MySQL Instance
| New OpsRamp Metric | Google Metric | Metric Display Name | Unit | Description |
|---|---|---|---|---|
| google_cloudsql_database_mysql_aborted_clients_count | cloudsql.googleapis.com/database/mysql/aborted_clients_count | MySQL Aborted Clients Count | count | Connections that were aborted because the client died without closing the connection properly, since the last sample. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_aborted_connects_count | cloudsql.googleapis.com/database/mysql/aborted_connects_count | MySQL Aborted Connects Count | count | Failed attempts to connect to the MySQL server, since the last sample. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_connections_count | cloudsql.googleapis.com/database/mysql/connections_count | MySQL Connections Count | count | Connection attempts (successful or not) to the MySQL server, since the last sample. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_ddl_operations_count | cloudsql.googleapis.com/database/mysql/ddl_operations_count | MySQL DDL Operations Count | count | MySQL DDL operations, since the last sample. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_dml_operations_count | cloudsql.googleapis.com/database/mysql/dml_operations_count | MySQL DML Operations Count | count | MySQL DML operations, since the last sample. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_handler_operations_count | cloudsql.googleapis.com/database/mysql/handler_operations_count | MySQL Handler Operations Count | count | MySQL handler operations, since the last sample. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_innodb_active_transactions | cloudsql.googleapis.com/database/mysql/innodb/active_transactions | InnoDB Active Transactions | count | Number of active Transaction details(trx which are in progress), Values in bracket are meant for innodb_transaction_state (Total/running/lock_wait/rolling_back/committing). Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_innodb_active_trx_longest_time | cloudsql.googleapis.com/database/mysql/innodb/active_trx_longest_time | InnoDB Active TRX Longest Time | count | Largest transaction time from currently active innodb transactions. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_innodb_active_trx_rows_locked | cloudsql.googleapis.com/database/mysql/innodb/active_trx_rows_locked | InnoDB Active TRX Rows Locked | count | Number of rows locked by currently active innodb transactions. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_innodb_active_trx_rows_modified | cloudsql.googleapis.com/database/mysql/innodb/active_trx_rows_modified | InnoDB Active TRX Rows Modified | count | Number of rows modified by currently active innodb transactions. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_innodb_active_trx_total_time | cloudsql.googleapis.com/database/mysql/innodb/active_trx_total_time | InnoDB Active TRX Total Time | seconds | Duration of currently active innodb transactions. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_innodb_adaptive_hash_operation_count | cloudsql.googleapis.com/database/mysql/innodb/adaptive_hash_operation_count | Innodb AHI operations | count | Total internal row operations (rows added, updated, removed) performed to maintain the AHI since last sample. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_innodb_ahi_search_count | cloudsql.googleapis.com/database/mysql/innodb/ahi_search_count | AHI or Btree searches | count | Total search operations on the InnoDB AHI and its efficiency since the last sample. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_innodb_buffer_flush_sync_waits_count | cloudsql.googleapis.com/database/mysql/innodb/buffer_flush_sync_waits_count | Innodb sync flushing waits | count | Number of times InnoDB has performed synchronous buffer flush operations and blocking the user transactions since last sample. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_innodb_buffer_pool_pages | cloudsql.googleapis.com/database/mysql/innodb/buffer_pool_pages | InnoDB Buffer Pool Pages | count | Number of InnoDB buffer pool pages, innodb_page_type field stores count of InnoDB pages in each state. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_innodb_buffer_pool_read_requests_count | cloudsql.googleapis.com/database/mysql/innodb/buffer_pool_read_requests_count | Innodb Buffer Pool Read Requests Count | count | Logical read requests from InnoDB buffer pool, since the last sample. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_innodb_buffer_pool_reads_count | cloudsql.googleapis.com/database/mysql/innodb/buffer_pool_reads_count | Innodb Buffer Pool Reads Count | count | Logical reads that InnoDB could not satisfy from the buffer pool, and had to read directly from disk, since the last sample. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_innodb_buffer_pool_write_requests_count | cloudsql.googleapis.com/database/mysql/innodb/buffer_pool_write_requests_count | InnoDB Buffer Pool Write Requests Count | count | Writes done to the InnoDB buffer pool, since the last sample. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_innodb_data_cache_cache_hit_count | cloudsql.googleapis.com/database/mysql/innodb/data_cache/cache_hit_count | MySQL data cache hit count | count | Total number of data cache hit read operations for this instance. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_innodb_data_cache_cache_miss_count | cloudsql.googleapis.com/database/mysql/innodb/data_cache/cache_miss_count | MySQL data cache miss count | count | Total number of data cache miss read operations for this instance. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_innodb_data_cache_pages | cloudsql.googleapis.com/database/mysql/innodb/data_cache/pages | Innodb Pages in Data Cache | count | The number of Innodb pages in Mysqls E+ Data cache feature. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_innodb_data_fsyncs_count | cloudsql.googleapis.com/database/mysql/innodb/data_fsyncs_count | Innodb Data Fsyncs Count | count | InnoDB fsync() calls, since the last sample. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_innodb_data_pending_fsyncs | cloudsql.googleapis.com/database/mysql/innodb/data_pending_fsyncs | InnoDB Data Pending Fsyncs | count | Number of pending fsync() operations in the MySQL server. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_innodb_data_pending_reads | cloudsql.googleapis.com/database/mysql/innodb/data_pending_reads | InnoDB Data Pending Reads | count | Number of pending reads in the MySQL Server. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_innodb_data_pending_writes | cloudsql.googleapis.com/database/mysql/innodb/data_pending_writes | InnoDB Data Pending Writes | count | Number of pending writes in the MySQL Server. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_innodb_deadlocks_count | cloudsql.googleapis.com/database/mysql/innodb/deadlocks_count | InnoDB Deadlocks Count | count | Deadlocks, since the last sample. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_innodb_dictionary_memory | cloudsql.googleapis.com/database/mysql/innodb/dictionary_memory | MySQL InnoDB dictionary cache | bytes | Memory allocated for InnoDB dictionary cache. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_innodb_history_list_length | cloudsql.googleapis.com/database/mysql/innodb/history_list_length | InnoDB History List Length | count | Indicates the size of undo logs which are used to store modifications made to older versions of rows. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_innodb_ibuf_merge_operation_count | cloudsql.googleapis.com/database/mysql/innodb/ibuf_merge_operation_count | InnoDB merged records operation wise | count | Total number of records type merged by the change buffering operation since the last sample. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_innodb_ibuf_merges_count | cloudsql.googleapis.com/database/mysql/innodb/ibuf_merges_count | InnoDB change buffer merges. | count | Total number of change buffer merges since the last sample. This shows the efficiency of all change buffer operations. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_innodb_innodb_log_waits_count | cloudsql.googleapis.com/database/mysql/innodb/innodb_log_waits_count | Transaction waits for Innodb logbuffer flush | count | Total number of transactions wait for space to become available in the InnoDB log buffer, to help tune innodb_log_buffer_size configuration. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_innodb_lock_timeout_count | cloudsql.googleapis.com/database/mysql/innodb/lock_timeout_count | Innodb Row Lock Wait Timeout Count | count | Row lock wait timeouts, since the last sample. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_innodb_lsn | cloudsql.googleapis.com/database/mysql/innodb/lsn | InnoDB LSN | bytes | Value of Innodb current/flushed/last_checkpoint log sequence number. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_innodb_operation_disk_io_count | cloudsql.googleapis.com/database/mysql/innodb/operation_disk_io_count | Disk IO performed by InnoDB. | count | Disk IO operations performed by InnoDB since the last sample. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_innodb_os_log_fsyncs_count | cloudsql.googleapis.com/database/mysql/innodb/os_log_fsyncs_count | Innodb OS Log Fsyncs Count | count | InnoDB fsync() calls to the log file, since the last sample. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_innodb_os_log_pending_fsyncs | cloudsql.googleapis.com/database/mysql/innodb/os_log_pending_fsyncs | InnoDB OS Log Pending Fsyncs | count | Number of pending fsync() operations for the InnoDB redo log files in the MySQL server. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_innodb_os_log_pending_writes | cloudsql.googleapis.com/database/mysql/innodb/os_log_pending_writes | InnoDB OS Log Pending Writes | count | Number of pending writes to the InnoDB redo log files in the MySQL server. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_innodb_pages_read_count | cloudsql.googleapis.com/database/mysql/innodb/pages_read_count | Innodb Pages Read Count | count | InnoDB pages read, since the last sample. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_innodb_pages_written_count | cloudsql.googleapis.com/database/mysql/innodb/pages_written_count | Innodb Pages Written Count | count | DInnoDB pages written, since the last sample. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_innodb_row_lock_time | cloudsql.googleapis.com/database/mysql/innodb/row_lock_time | InnoDB Row Lock Time | ms | The total time spent in acquiring row locks for InnoDB tables. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_innodb_row_lock_waits_count | cloudsql.googleapis.com/database/mysql/innodb/row_lock_waits_count | InnoDB Row Lock Waits Count | count | Times operations on InnoDB tables had to wait for a row lock, since the last sample. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_innodb_row_operations_count | cloudsql.googleapis.com/database/mysql/innodb/row_operations_count | InnoDB Row Operations Count | count | InnoDB row operations, operation_type field stores the count of InnoDB row operations, since the last sample. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_innodb_buffer_pool_pages_dirty | cloudsql.googleapis.com/database/mysql/innodb_buffer_pool_pages_dirty | InnoDB dirty pages | count | Number of unflushed pages in the InnoDB buffer pool. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_innodb_buffer_pool_pages_free | cloudsql.googleapis.com/database/mysql/innodb_buffer_pool_pages_free | InnoDB free pages | count | Number of unused pages in the InnoDB buffer pool. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_innodb_buffer_pool_pages_total | cloudsql.googleapis.com/database/mysql/innodb_buffer_pool_pages_total | InnoDB total pages | count | Total number of pages in the InnoDB buffer pool. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_innodb_data_fsyncs | cloudsql.googleapis.com/database/mysql/innodb_data_fsyncs | InnoDB fsync calls | count | Delta count of InnoDB fsync() calls. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_innodb_os_log_fsyncs | cloudsql.googleapis.com/database/mysql/innodb_os_log_fsyncs | InnoDB log fsync calls | count | Delta count of InnoDB fsync() calls to the log file. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_innodb_pages_read | cloudsql.googleapis.com/database/mysql/innodb_pages_read | InnoDB pages read | count | Delta count of InnoDB pages read. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_innodb_pages_written | cloudsql.googleapis.com/database/mysql/innodb_pages_written | InnoDB pages written | count | Delta count of InnoDB pages written. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_max_connections | cloudsql.googleapis.com/database/mysql/max_connections | MySQL Max Connections | count | Value of the MySQL max_connections configuration. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_memory_by_code_area | cloudsql.googleapis.com/database/mysql/memory/by_code_area | Memory allocated by code area | bytes | Memory allocated to each code area, reported by mysql performance_schema. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_memory_by_event | cloudsql.googleapis.com/database/mysql/memory/by_event | Memory allocated by events | bytes | Memory allocated by each event, reported by performance_schema. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_memory_global | cloudsql.googleapis.com/database/mysql/memory/global | Global memory allocated | bytes | The total allocated memory, reported by performance_schema. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_open_table_definitions | cloudsql.googleapis.com/database/mysql/open_table_definitions | MySQL open table definitions | count | The number of table definitions that are currently cached. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_open_tables | cloudsql.googleapis.com/database/mysql/open_tables | MySQL open tables | count | The number of tables that are currently open. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_opened_table_count | cloudsql.googleapis.com/database/mysql/opened_table_count | MySQL opened table count | count | The number of tables that have been opened since the last sample. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_opened_table_definitions_count | cloudsql.googleapis.com/database/mysql/opened_table_definitions_count | MySQL opened table definitions count | count | The number of table definitions that have been cached since the last sample. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_queries | cloudsql.googleapis.com/database/mysql/queries | Queries | count | Delta count of statements executed by the server. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_questions | cloudsql.googleapis.com/database/mysql/questions | Questions | count | Delta count of statements executed by the server sent by the client. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_received_bytes_count | cloudsql.googleapis.com/database/mysql/received_bytes_count | Network bytes received by MySQL | bytes | Delta count of bytes received by MySQL process. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_replication_last_io_errno | cloudsql.googleapis.com/database/mysql/replication/last_io_errno | Database Mysql Replication Last Io Errno | count | The error number of the most recent error that caused the I/O thread to stop. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_replication_last_sql_errno | cloudsql.googleapis.com/database/mysql/replication/last_sql_errno | Last SQL thread error number. | count | The error number of the most recent error that caused the SQL thread to stop. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_replication_seconds_behind_master | cloudsql.googleapis.com/database/mysql/replication/seconds_behind_master | Replication lag | seconds | Number of seconds the read replica is behind its primary (approximation). A negative value indicates that replication is inactive. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_replication_slave_io_running_state | cloudsql.googleapis.com/database/mysql/replication/slave_io_running_state | Database Mysql Replication Slave Io Running State | count | Indicates whether the I/O thread for reading the primary's binary log is running. Possible values are Yes, No and Connecting, and the values are exposed through the 'state' field. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_replication_slave_sql_running_state | cloudsql.googleapis.com/database/mysql/replication/slave_sql_running_state | Slave SQL thread running state | count | Indicates whether the SQL thread for executing events in the relay log is running. Possible values are Yes / No, and the values are exposed through the 'state' field. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_sent_bytes_count | cloudsql.googleapis.com/database/mysql/sent_bytes_count | Network bytes sent by MySQL | bytes | Delta count of bytes sent by MySQL process. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_slow_queries_count | cloudsql.googleapis.com/database/mysql/slow_queries_count | MySQL slow queries count. | count | The total number of queries that took longer than long_query_time seconds. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_thread_cache_size | cloudsql.googleapis.com/database/mysql/thread_cache_size | MySQL Thread Cache Size | count | Value of the MySQL thread_cache_size configuration. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_thread_state | cloudsql.googleapis.com/database/mysql/thread_state | MySQL threads state | count | The state of running threads by querying information_schema.processlist table, this information helps to understand the locking or contention issues. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_threads | cloudsql.googleapis.com/database/mysql/threads | MySQL Thread | count | Number of Threads. threads_cached indicates threads in the thread cache, threads_connected indicates currently open connections, threads_running indicates threads that are not sleeping. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_threads_created_count | cloudsql.googleapis.com/database/mysql/threads_created_count | MySQL Threads Created Count | count | Threads created to handle connections, since the last sample. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_tmp_disk_tables_created_count | cloudsql.googleapis.com/database/mysql/tmp_disk_tables_created_count | MySQL Temporary Disk Tables Created Count | count | Internal on-disk temporary tables created by the MySQL server while executing statements, since the last sample. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_tmp_files_created_count | cloudsql.googleapis.com/database/mysql/tmp_files_created_count | MySQL Temporary Files Created Count | count | Temporary files created by the MySQL server, since the last sample. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_mysql_tmp_tables_created_count | cloudsql.googleapis.com/database/mysql/tmp_tables_created_count | MySQL Temporary Tables Created Count | count | MySQL temporary tables created, since the last sample. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
GCP PostgreSQL Instance
| New OpsRamp Metric | Google Metric | Metric Display Name | Unit | Description |
|---|---|---|---|---|
| google_cloudsql_database_postgresql_backends_in_wait | cloudsql.googleapis.com/database/postgresql/backends_in_wait | PostgreSQL backends in wait | count | Number of backends in wait in postgres instance. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_postgresql_blocks_read_count | cloudsql.googleapis.com/database/postgresql/blocks_read_count | Number of disk blocks read. | count | Number of disk blocks read by this database. The source field distingushes actual reads from disk versus reads from buffer cache. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_postgresql_checkpoint_count | cloudsql.googleapis.com/database/postgresql/checkpoint_count | Checkpoint count | count | Total checkpoints occurred. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_postgresql_data_cache_hit_count | cloudsql.googleapis.com/database/postgresql/data_cache/hit_count | PostgreSQL data cache hit count | count | Total number of data cache hit read operations for this instance. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_postgresql_data_cache_hit_ratio | cloudsql.googleapis.com/database/postgresql/data_cache/hit_ratio | PostgreSQL data cache hit ratio | count | Ratio of data cache hit read operations for this instance. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_postgresql_data_cache_miss_count | cloudsql.googleapis.com/database/postgresql/data_cache/miss_count | PostgreSQL data cache miss count | count | Total number of data cache miss read operations for this instance. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_postgresql_deadlock_count | cloudsql.googleapis.com/database/postgresql/deadlock_count | Deadlocks count | count | Number of deadlocks detected for this database. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_postgresql_new_connection_count | cloudsql.googleapis.com/database/postgresql/new_connection_count | PostgreSQL new connections count | count | Count of new connections added to the postgres instance. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_postgresql_num_backends | cloudsql.googleapis.com/database/postgresql/num_backends | PostgreSQL Connections | count | Number of connections to the Cloud SQL PostgreSQL instance. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_postgresql_num_backends_by_application | cloudsql.googleapis.com/database/postgresql/num_backends_by_application | PostgreSQL connections by application | count | Number of connections to the Cloud SQL PostgreSQL instance, grouped by applications. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_postgresql_num_backends_by_state | cloudsql.googleapis.com/database/postgresql/num_backends_by_state | PostgreSQL Connections by State | count | Number of connections to the Cloud SQL PostgreSQL instance, grouped by its state. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_postgresql_replication_replica_byte_lag | cloudsql.googleapis.com/database/postgresql/replication/replica_byte_lag | Lag bytes | bytes | Replication lag in bytes. Reported from the master per replica. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_postgresql_statements_executed_count | cloudsql.googleapis.com/database/postgresql/statements_executed_count | Statements executed count | count | Total count of statements executed in postgresql instance. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_postgresql_temp_bytes_written_count | cloudsql.googleapis.com/database/postgresql/temp_bytes_written_count | Data (in bytes) written to temporary | count | Total amount of data (in bytes) written to temporary files by the queries per database. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_postgresql_temp_files_written_count | cloudsql.googleapis.com/database/postgresql/temp_files_written_count | Temporary files used for writing data | count | Total number of temporary files used for writing data while performing algorithms such as join and sort. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_postgresql_transaction_count | cloudsql.googleapis.com/database/postgresql/transaction_count | Number of transactions | count | Delta count of number of transactions. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_postgresql_transaction_id_count | cloudsql.googleapis.com/database/postgresql/transaction_id_count | Transaction ID count | count | Delta count of transaction ID. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_postgresql_transaction_id_utilization | cloudsql.googleapis.com/database/postgresql/transaction_id_utilization | Transaction ID utilization | % | Current utilization represented as a percentage of transaction IDs consumed by the Cloud SQL PostgreSQL instance. Values are typically numbers between 0.0 and 1.0. Charts display the values as a percentage between 0% and 100%. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_postgresql_tuple_size | cloudsql.googleapis.com/database/postgresql/tuple_size | Number of tuples (rows) in the database. | count | Number of tuples (rows) in the database. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_postgresql_tuples_fetched_count | cloudsql.googleapis.com/database/postgresql/tuples_fetched_count | Number of tuples fetched | count | Total number of rows fetched as a result of queries per database in the PostgreSQL instance. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_postgresql_tuples_processed_count | cloudsql.googleapis.com/database/postgresql/tuples_processed_count | Number of rows processed | count | Number of tuples(rows) processed for a given database for operations like insert, update or delete. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_postgresql_tuples_returned_count | cloudsql.googleapis.com/database/postgresql/tuples_returned_count | Number of tuples returned | count | Total number of rows scanned while processing the queries per database in the PostgreSQL instance. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_postgresql_vacuum_oldest_transaction_age | cloudsql.googleapis.com/database/postgresql/vacuum/oldest_transaction_age | Oldest transaction age | count | Age of the oldest transaction yet to be vacuumed in the Cloud SQL PostgreSQL instance, measured in number of transactions that have happened since the oldest transaction. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_postgresql_write_ahead_log_flushed_bytes_count | cloudsql.googleapis.com/database/postgresql/write_ahead_log/flushed_bytes_count | PostgreSQL WAL flushed bytes count | count | Total size (bytes) of WAL flushed for this instance. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_postgresql_write_ahead_log_inserted_bytes_count | cloudsql.googleapis.com/database/postgresql/write_ahead_log/inserted_bytes_count | PostgreSQL WAL inserted bytes count | count | Total size (bytes) of WAL inserted for this instance. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_postgresql_write_ahead_log_redo_size | cloudsql.googleapis.com/database/postgresql/write_ahead_log/redo_size | PostgreSQL redo size metric | count | The size (bytes) of WAL to redo in case of recovery. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_postgresql_write_ahead_log_written_bytes_count | cloudsql.googleapis.com/database/postgresql/write_ahead_log/written_bytes_count | PostgreSQL WAL written bytes count | count | Total size (bytes) of WAL written for this instance. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
GCP SQL Server Instance
| New OpsRamp Metric | Google Metric | Metric Display Name | Unit | Description |
|---|---|---|---|---|
| google_cloudsql_database_sqlserver_audits_size | cloudsql.googleapis.com/database/sqlserver/audits_size | Size of stored audit files. | bytes | Tracks the size in bytes of stored SQLServer audit files on an instance. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_sqlserver_audits_upload_count | cloudsql.googleapis.com/database/sqlserver/audits_upload_count | Total number of successfully uploaded audits. | count | Counts total number of SQLServer audit file uploads to a GCS bucket and whether or not an upload was successful. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_sqlserver_connections_connection_reset_count | cloudsql.googleapis.com/database/sqlserver/connections/connection_reset_count | Connection resets | count | Total number of logins started from the connection pool since the last restart of SQL Server service. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_sqlserver_connections_login_attempt_count | cloudsql.googleapis.com/database/sqlserver/connections/login_attempt_count | Login attempts | count | Total number of login attempts since the last restart of SQL Server service. This does not include pooled connections. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_sqlserver_connections_logout_count | cloudsql.googleapis.com/database/sqlserver/connections/logout_count | Logouts | count | Total number of logout operations since the last restart of SQL Server service. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_sqlserver_connections_processes_blocked | cloudsql.googleapis.com/database/sqlserver/connections/processes_blocked | Processes blocked | count | Current number of blocked processes. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_sqlserver_data_cache_hit_count | cloudsql.googleapis.com/database/sqlserver/data_cache/hit_count | SQL Server data cache hit count | count | Total number of data cache hit read operations for this instance. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_sqlserver_data_cache_hit_ratio | cloudsql.googleapis.com/database/sqlserver/data_cache/hit_ratio | SQL Server data cache hit ratio | count | Ratio of successful data cache hit read operations for this instance. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_sqlserver_data_cache_miss_count | cloudsql.googleapis.com/database/sqlserver/data_cache/miss_count | SQL Server data cache miss count | count | Total number of data cache miss read operations for this instance. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_sqlserver_databases | cloudsql.googleapis.com/database/sqlserver/databases | SQL Server Databases | count | Current number of databases on the instance excluding system databases. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_sqlserver_memory_buffer_cache_hit_ratio | cloudsql.googleapis.com/database/sqlserver/memory/buffer_cache_hit_ratio | Buffer cache hit ratio | % | Current percentage of pages found in the buffer cache without having to read from disk. The ratio is the total number of cache hits divided by the total number of cache lookups. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_sqlserver_memory_checkpoint_page_count | cloudsql.googleapis.com/database/sqlserver/memory/checkpoint_page_count | Checkpoint pages | count | Total number of pages flushed to disk by a checkpoint or other operation that requires all dirty pages to be flushed. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_sqlserver_memory_free_list_stall_count | cloudsql.googleapis.com/database/sqlserver/memory/free_list_stall_count | Free list stalls | count | Total number of requests that had to wait for a free page. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_sqlserver_memory_lazy_write_count | cloudsql.googleapis.com/database/sqlserver/memory/lazy_write_count | Lazy writes | count | Total number of buffers written by the buffer manager's lazy writer. The lazy writer is a system process that flushes out batches of dirty, aged buffers (buffers that contain changes that must be written back to disk before the buffer can be reused for a different page) and makes them available to user processes. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_sqlserver_memory_memory_grants_pending | cloudsql.googleapis.com/database/sqlserver/memory/memory_grants_pending | Memory grants pending | count | Current number of processes waiting for a workspace memory grant. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_sqlserver_memory_page_life_expectancy | cloudsql.googleapis.com/database/sqlserver/memory/page_life_expectancy | Page life expectancy | seconds | Current number of seconds a page will stay in the buffer pool without references. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_sqlserver_memory_page_operation_count | cloudsql.googleapis.com/database/sqlserver/memory/page_operation_count | Page operations | count | Total number of physical database page reads or writes. This statistic counts physical page reads or writes across all databases. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_sqlserver_replication_bytes_sent_to_replica_count | cloudsql.googleapis.com/database/sqlserver/replication/bytes_sent_to_replica_count | Bytes sent to replica | bytes | Total number of bytes sent to the remote availability replica. Before compression for async replica. Actual number of bytes for sync replica which has no compression. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_sqlserver_replication_log_apply_pending_queue | cloudsql.googleapis.com/database/sqlserver/replication/log_apply_pending_queue | Log apply pending queue | count | Current number of log blocks that are waiting to be applied to all database replicas. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_sqlserver_replication_log_bytes_received_count | cloudsql.googleapis.com/database/sqlserver/replication/log_bytes_received_count | Log bytes received | bytes | Total amount of log records received by the secondary replica for all databases. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_sqlserver_replication_recovery_queue | cloudsql.googleapis.com/database/sqlserver/replication/recovery_queue | Recovery queue | KB | Current amount of log records in kilobytes in the log files of the secondary replica that have not been redone. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_sqlserver_replication_redone_bytes_count | cloudsql.googleapis.com/database/sqlserver/replication/redone_bytes_count | Redone bytes | bytes | Total amount of log records redone on all secondary databases. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_sqlserver_replication_resent_message_count | cloudsql.googleapis.com/database/sqlserver/replication/resent_message_count | Resent messages | count | Total number of Always On messages resent. A resent message is a message that was attempted to be sent but was unable to complete and must be attempted to be sent again. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_sqlserver_schedulers_active_workers | cloudsql.googleapis.com/database/sqlserver/schedulers/active_workers | Number of active workers per scheduler | count | Current number of workers that are active. An active worker is never preemptive, must have an associated task, and is either running, runnable, or suspended. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_sqlserver_schedulers_by_status | cloudsql.googleapis.com/database/sqlserver/schedulers/by_status | Number of schedulers | count | Current number of schedulers reporting a particular status. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_sqlserver_schedulers_current_tasks | cloudsql.googleapis.com/database/sqlserver/schedulers/current_tasks | Number of current tasks per scheduler | count | Current number of current tasks that are associated with a scheduler. This count includes tasks that are waiting for a worker to execute them and tasks that are currently waiting or running (in SUSPENDED or RUNNABLE state). Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_sqlserver_schedulers_current_workers | cloudsql.googleapis.com/database/sqlserver/schedulers/current_workers | Number of workers per scheduler | count | Current number of workers that are associated with a scheduler. It includes workers that are not assigned any task. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_sqlserver_schedulers_pending_disk_io | cloudsql.googleapis.com/database/sqlserver/schedulers/pending_disk_io | Database Sqlserver Schedulers Pending Disk Io | count | Current number of pending I/Os that are waiting to be completed. Each scheduler has a list of pending I/Os that are checked to determine whether they have been completed every time there is a context switch. The count is incremented when the request is inserted. This count is decremented when the request is completed. This number does not indicate the state of the I/Os. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_sqlserver_schedulers_runnable_tasks | cloudsql.googleapis.com/database/sqlserver/schedulers/runnable_tasks | Number of workers with assigned tasks per scheduler | count | Current number of workers, with tasks assigned to them, that are waiting to be scheduled on the runnable queue. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_sqlserver_schedulers_work_queue | cloudsql.googleapis.com/database/sqlserver/schedulers/work_queue | Number of pending tasks per scheduler | count | Current number of tasks in the pending queue. These tasks are waiting for a worker to pick them up. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_sqlserver_server_principals | cloudsql.googleapis.com/database/sqlserver/server_principals | Server principals | count | Current number of server principals on the instance. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_sqlserver_sql_agent_jobs | cloudsql.googleapis.com/database/sqlserver/sql_agent/jobs | SQL Server agent jobs | count | Current number of SQL Server agent jobs on the instance. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_sqlserver_transactions_batch_request_count | cloudsql.googleapis.com/database/sqlserver/transactions/batch_request_count | Batch requests | count | Total number of Transact-SQL command batches received. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_sqlserver_transactions_deadlock_count | cloudsql.googleapis.com/database/sqlserver/transactions/deadlock_count | Deadlocks | count | Total number of lock requests that resulted in a deadlock. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_sqlserver_transactions_forwarded_record_count | cloudsql.googleapis.com/database/sqlserver/transactions/forwarded_record_count | Forwarded records | count | Total number of records fetched through forwarded record pointers. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_sqlserver_transactions_full_scan_count | cloudsql.googleapis.com/database/sqlserver/transactions/full_scan_count | Full scans | count | Total number of unrestricted full scans. These can be either base-table or full-index scans. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_sqlserver_transactions_lock_wait_count | cloudsql.googleapis.com/database/sqlserver/transactions/lock_wait_count | Lock waits | count | Total number of lock requests that required the caller to wait. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_sqlserver_transactions_lock_wait_time | cloudsql.googleapis.com/database/sqlserver/transactions/lock_wait_time | Lock wait time | ms | Total time lock requests were waiting for locks. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_sqlserver_transactions_log_bytes_flushed_count | cloudsql.googleapis.com/database/sqlserver/transactions/log_bytes_flushed_count | Log bytes flushed | bytes | Total number of log bytes flushed. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_sqlserver_transactions_page_split_count | cloudsql.googleapis.com/database/sqlserver/transactions/page_split_count | Page splits | count | Total number of page splits that occur as the result of overflowing index pages. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_sqlserver_transactions_probe_scan_count | cloudsql.googleapis.com/database/sqlserver/transactions/probe_scan_count | Probe scans | count | Total number of probe scans that are used to find at most one single qualified row in an index or base table directly. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_sqlserver_transactions_sql_compilation_count | cloudsql.googleapis.com/database/sqlserver/transactions/sql_compilation_count | SQL compilations | count | Total number of SQL compilations. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_sqlserver_transactions_sql_recompilation_count | cloudsql.googleapis.com/database/sqlserver/transactions/sql_recompilation_count | SQL recompilations | count | Total number of SQL recompilations. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_sqlserver_transactions_transaction_count | cloudsql.googleapis.com/database/sqlserver/transactions/transaction_count | Transactions started | count | Total number of transactions started. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_sqlserver_xevents_size | cloudsql.googleapis.com/database/sqlserver/xevents_size | Size of stored XEvents files. | bytes | Tracks the size in bytes of stored SQLServer XEvents files on an instance. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
| google_cloudsql_database_sqlserver_xevents_upload_count | cloudsql.googleapis.com/database/sqlserver/xevents_upload_count | Total number of successfully uploaded XEvents. | count | Counts total number of SQLServer XEvents file uploads to a GCS bucket and whether or not an upload was successful. Sampled every 60 seconds. After sampling, data is not visible for up to 165 seconds. |
Event support
- Supported
- Configurable in OpsRamp Google Integration Discovery Profile.
External reference
MSSQL Advance Monitoring - Google Cloud
OpsRamp now supports the MSSQL Advance database monitoring for Google using the Gateway Collector.
Whitelisting Gateway IP in Google Cloud
In order to perform advance monitoring for Google cloud resources, we need to whitelist the IP of the host of the Gateway machine.
To whitelist the IP:
- Log in to the Google Cloud.
- In the Google Cloud console, go to the Cloud SQL page.
- To open the Overview page of an instance, click the instance name.
- Select Connections from the SQL navigation menu.
- Select the Public IP checkbox.
- Click Add network.
- In the Network field, enter the IP address or address range you want to allow connections from.
- Click Done.
- Click Save to update the instance.
Advance Monitoring configuration
Once you whitelist the gateway in Google Cloud, you can now configure for advance monitoring in OpsRamp portal.
- Log in to the OpsRamp portal.
- Go to Infrastructure > Resources > Google Cloud.
- Select Cloud SQL Database.
- From the Cloud SQL database details page, select a resource.
- In the resource details page, click settings.
- From the settings drop-down, click Assign Gateway Profile.
- Select a management profile from the drop-down menu.
- Click Assign.
- Select Credentials from the left hand navigation pane and click Add.
- Enter the below mentioned credential information:
| Field | Description |
|---|---|
| Name | Name for new credential. |
| Description | Add a description of the credential. |
| Type | Select as Database. |
| Username | Enter the username of the resource created in Google Cloud. |
| Password | Enter the password of the resource created in Google Cloud. |
| Confirm Password | Enter the password again. |
| Port | Port should be 1433. |
| Connection Time out (ms) | Specify the timeout duration. |
- Click Save.
- Select Monitors from the left hand navigation pane and click Assign Templates.
- In the Apply Templates page, select Collector Type as Gateway.
- Under Assign Templates, search for MSSQL templates and assign required templates.
- Select Metrics from the left hand navigation pane and you can see the monitoring data.
