GCP Cloud SQL

Google Cloud Platform (GCP) Cloud SQL is a fully managed relational database service for MySQL, PostgreSQL, and SQL Server.

You must configure cloud connections to monitor this entity. See Configure Google Cloud Platform Connection.

Cisco Cloud Observability displays GCP entities on the Observe page. Metrics are displayed for specific entity instances in the list and detail views.

This document contains references to third-party documentation. Splunk AppDynamics does not own any rights and assumes no responsibility for the accuracy or completeness of such third-party documentation.

Detail View

To display the detail view of a Cloud SQL entity:

Navigate to the Observe page.
Under Database & Storage, click SQL Database Instances.
The list view now displays.
Click the GCP button to display only GCP database entities.
From the list, click a database Name to display the detail view.
The detail view displays metrics, key performance indicators, and properties (attributes) related to the database you selected.

Metrics and Key Performance Indicators

Cisco Cloud Observability displays the following metrics and key performance indicators (KPIs) for Cloud SQL entities.

Some GCP metrics have been modified in Cisco Cloud Observability. Metric display names and descriptions may differ from the source metric.

Display Name	Source Metric	Description
CPU Limit	`database/cpu/reserved_cores`	Number of cores reserved for the database.
CPU Utilization (%)	`database/cpu/utilization`	Current CPU utilization represented as a percentage of the reserved CPU that is currently in use.
Storage Used (By)	`database/disk/bytes_used`	Data utilization in bytes.
Data Storage Space Allocated (By)	`database/disk/quota`	Maximum data disk size in bytes.
Storage Utilization (%)	`database/disk/utilization`	The fraction of the disk quota that is currently in use.
Memory Usage (%)	`database/memory/utilization`	The fraction of the memory quota that is currently in use.
Database Connections	`database/network/connections`	Number of connections to databases on the Cloud SQL instance.
Network In (By)	`database/network/received_bytes_count`	Delta count of bytes received by MySQL process.
Network Out (By)	`database/network/sent_bytes_count`	Delta count of bytes sent by MySQL process.
CPU Usage (By)	`database/cpu/usage_time`	Cumulative CPU usage time in seconds.
Disk IO Operations	`database/disk/read_ops_count` `database/disk/write_ops_count`	Delta count of data disk read/write IO operations.
Memory Quota (By)	`database/memory/quota`	Maximum RAM size in bytes.
Total Memory Usage (By)	`database/memory/total_usage`	Total RAM usage in bytes. This metric reports the RAM usage of the database process, including the buffer/cache.
Memory Usage (By)	`database/memory/usage`	RAM usage in bytes. This metric reports the RAM usage of the server, excluding the buffer/cache.
Server Up	`database/up`	Indicates if the server is up or not.
Uptime (s)	`database/uptime`	Delta count of the time in seconds the instance has been running.
MySQL InnoDB Dictionary Cache (By)	`database/mysql/innodb/dictionary_memory`	Memory allocated for InnoDB dictionary cache.
InnoDB Free Pages	`database/mysql/innodb_buffer_pool_pages_free`	Number of unused pages in the InnoDB buffer pool.
InnoDB Total Pages	`database/mysql/innodb_buffer_pool_pages_total`	Total number of pages in the InnoDB buffer pool.
InnoDB Pages	`database/mysql/innodb_pages_read` `database/mysql/innodb_pages_written`	Delta count of InnoDB pages read/written.
MySQL Open Table/Table Definitions	`database/mysql/open_table_definitions` `database/mysql/open_tables`	The number of tables/tables definitions that are currently open/cached.
MySQL Opened Table/Table Definitions Count	`database/mysql/opened_table_count` `database/mysql/opened_table_definitions_count`	The number of tables/tables definitions that have been opened/cached since the last sample.
Queries	`database/mysql/queries`	Delta count of statements executed by the server.
Questions	`database/mysql/questions`	Delta count of statements executed by the server sent by the client.
InnoDB Dirty Pages	`database/mysql/innodb_buffer_pool_pages_dirty`	Number of unflushed pages in the InnoDB buffer pool.
InnoDB Fsync Calls	`database/mysql/innodb_data_fsyncs`	Delta count of InnoDB fsync() calls.
InnoDB Log Fsync Calls	`database/mysql/innodb_os_log_fsyncs`	Delta count of InnoDB fsync() calls to the log file.

Display Name	Source Metric	Description
CPU Limit	`database/cpu/reserved_cores`	Number of cores reserved for the database.
CPU Utilization (%)	`database/cpu/utilization`	Current CPU utilization represented as a percentage of the reserved CPU that is currently in use.
Storage Used (By)	`database/disk/bytes_used`	Data utilization in bytes.
Data Storage Space Allocated (By)	`database/disk/quota`	Maximum data disk size in bytes.
Storage Utilization (%)	`database/disk/utilization`	The fraction of the disk quota that is currently in use.
Memory Usage (%)	`database/memory/utilization`	The fraction of the memory quota that is currently in use.
Database Connections	`database/network/connections`	Number of connections to databases on the Cloud SQL instance.
Network In (By)	`database/network/received_bytes_count`	Delta count of bytes received by MySQL process.
Network Out (By)	`database/network/sent_bytes_count`	Delta count of bytes sent by MySQL process.
CPU Usage (By)	`database/cpu/usage_time`	Cumulative CPU usage time in seconds.
Disk IO Operations	`database/disk/read_ops_count` `database/disk/write_ops_count`	Delta count of data disk read/write IO operations.
Memory Quota (By)	`database/memory/quota`	Maximum RAM size in bytes.
Total Memory Usage (By)	`database/memory/total_usage`	Total RAM usage in bytes. This metric reports the RAM usage of the database process, including the buffer/cache.
Memory Usage (By)	`database/memory/usage`	RAM usage in bytes. This metric reports the RAM usage of the server, excluding the buffer/cache.
Server Up	`database/up`	Indicates if the server is up or not.
Uptime (s)	`database/uptime`	Delta count of the time in seconds the instance has been running.
Deadlocks	`database/postgresql/deadlock_count`	Number of deadlocks detected.
Number of Disk Blocks Read	`database/postgresql/blocks_read_count`	Number of disk blocks read.
PostgreSQL New Connections Count	`database/postgresql/new_connection_count`	Count of new connections added to the Cloud SQL PostgreSQL instance.
PostgreSQL Connections	`database/postgresql/num_backends`	Number of connections to the Cloud SQL PostgreSQL instance.
Data Written to Temporary (By)	`database/postgresql/temp_bytes_written_count`	Total amount of data (in bytes) written to temporary files by the queries.
Temporary Files Used for Writing Data	`database/postgresql/temp_files_written_count`	Total number of temporary files used for writing data while performing algorithms such as join and sort.
Number of Transactions	`database/postgresql/transaction_count`	Delta count of number of transactions.
Transaction ID Utilization (%)	`database/postgresql/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%.
Oldest Transaction Age	`database/postgresql/vacuum/oldest_transaction_age`	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.
Number of Tuples (Rows) in The Database	`database/postgresql/tuple_size`	Number of tuples (rows).
PostgreSQL Backends in Wait	`database/postgresql/backends_in_wait`	Number of backends in wait in the Cloud SQL PostgreSQL instance.
PostgreSQL Connections by State	`database/postgresql/num_backends_by_state`	Number of connections to the Cloud SQL PostgreSQL instance, grouped by its state.
PostgreSQL Connections by Application	`database/postgresql/num_backends_by_application`	Number of connections to the Cloud SQL PostgreSQL instance, grouped by applications.
Transaction ID Count	`database/postgresql/transaction_id_count`	Delta count of transaction ID.
Number of Tuples Fetched	`database/postgresql/tuples_fetched_count`	Total number of rows fetched as a result of queries in the PostgreSQL instance.
Number of Rows Processed	`database/postgresql/tuples_processed_count`	Number of tuples (rows) processed.
Number of Tuples Returned	`database/postgresql/tuples_returned_count`	Total number of rows scanned while processing the queries in the PostgreSQL instance.

Display Name	Source Metric	Description
CPU Limit	`database/cpu/reserved_cores`	Number of cores reserved for the database.
CPU Utilization (%)	`database/cpu/utilization`	Current CPU utilization represented as a percentage of the reserved CPU that is currently in use.
Storage Used (By)	`database/disk/bytes_used`	Data utilization in bytes.
Data Storage Space Allocated (By)	`database/disk/quota`	Maximum data disk size in bytes.
Storage Utilization (%)	`database/disk/utilization`	The fraction of the disk quota that is currently in use.
Memory Usage (%)	`database/memory/utilization`	The fraction of the memory quota that is currently in use.
Database Connections	`database/network/connections`	Number of connections to databases on the Cloud SQL instance.
Network In (By)	`database/network/received_bytes_count`	Delta count of bytes received by MySQL process.
Network Out (By)	`database/network/sent_bytes_count`	Delta count of bytes sent by MySQL process.
CPU Usage (By)	`database/cpu/usage_time`	Cumulative CPU usage time in seconds.
Disk IO Operations	`database/disk/read_ops_count` `database/disk/write_ops_count`	Delta count of data disk read/write IO operations.
Memory Quota (By)	`database/memory/quota`	Maximum RAM size in bytes.
Total Memory Usage (By)	`database/memory/total_usage`	Total RAM usage in bytes. This metric reports the RAM usage of the database process, including the buffer/cache.
Memory Usage (By)	`database/memory/usage`	RAM usage in bytes. This metric reports the RAM usage of the server, excluding the buffer/cache.
Server Up	`database/up`	Indicates if the server is up or not.
Uptime (s)	`database/uptime`	Delta count of the time in seconds the instance has been running.
Deadlocks	`database/sqlserver/transactions/deadlock_count`	Total number of lock requests that resulted in a deadlock.
Connection Resets	`database/sqlserver/connections/connection_reset_count`	Total number of logins started from the connection pool since the last restart of the SQL Server service.
Login Attempts	`database/sqlserver/connections/login_attempt_count`	Total number of login attempts since the last restart of the SQL Server service. This does not include pooled connections.
Logouts	`database/sqlserver/connections/logout_count`	Total number of logout operations since the last restart of the SQL Server service.
Processes Blocked	`database/sqlserver/connections/processes_blocked`	Current number of blocked processes.
Free List Stalls	`database/sqlserver/memory/free_list_stall_count`	Total number of requests that had to wait for a free page.
Memory Grants Pending	`database/sqlserver/memory/memory_grants_pending`	Current number of processes waiting for a workspace memory grant.
Page Life Expectancy (s)	`database/sqlserver/memory/page_life_expectancy`	Current number of seconds a page will stay in the buffer pool without references.
Page Operations	`database/sqlserver/memory/page_operation_count`	Total number of physical database page reads or writes. This statistic counts physical page reads or writes across all databases.
Number of Active Workers	`database/sqlserver/schedulers/active_workers`	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.
Number of Current Tasks	`database/sqlserver/schedulers/current_tasks`	Current number of current tasks. 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).
Number of Workers	`database/sqlserver/schedulers/current_workers`	Current number of workers. It includes workers that are not assigned any task.
Number of Pending I/O Operations	`database/sqlserver/schedulers/pending_disk_io`	Current number of pending I/Os that are waiting to be completed.
Number of Workers with Assigned Tasks	`database/sqlserver/schedulers/runnable_tasks`	Current number of workers, with tasks assigned to them.
Number of Pending Tasks	`database/sqlserver/schedulers/work_queue`	Current number of tasks in the pending queue.
Server Principals	`database/sqlserver/server_principals`	Current number of server principals on the instance.
SQL Server Agent Jobs	`database/sqlserver/sql_agent/jobs`	Current number of SQL Server agent jobs on the instance.
Full Scans	`database/sqlserver/transactions/full_scan_count`	Total number of unrestricted full scans. These can be either base-table or full-index scans.
Page Splits	`database/sqlserver/transactions/page_split_count`	Total number of page splits that occur as the result of overflowing index pages.
SQL Compilations	`database/sqlserver/transactions/sql_compilation_count`	Total number of SQL compilations.
SQL Recompilations	`database/sqlserver/transactions/sql_recompilation_count`	Total number of SQL recompilations.
Transactions Started	`database/sqlserver/transactions/transaction_count`	Total number of transactions started.
Lazy Writes	`database/sqlserver/memory/lazy_write_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.
Checkpoint Pages	`database/sqlserver/memory/checkpoint_page_count`	Total number of pages flushed to disk by a checkpoint or other operation that requires all dirty pages to be flushed.
Number of Schedulers	`database/sqlserver/schedulers/by_status`	Current number of schedulers.
Batch Requests	`database/sqlserver/transactions/batch_request_count`	Total number of Transact-SQL command batches received.
Forwarded Records	`database/sqlserver/transactions/forwarded_record_count`	Total number of records fetched through forwarded record pointers.
Log Bytes Flushed (By)	`database/sqlserver/transactions/log_bytes_flushed_count`	Total number of log bytes flushed.
Probe Scans	`database/sqlserver/transactions/probe_scan_count`	Total number of probe scans that are used to find at most one single qualified row in an index or base table directly.

Properties (Attributes)

Cisco Cloud Observability displays the following properties for Cloud SQL entities.

Display Name	Source Property Name	Description
ID	`selfLink`	The URI of this resource.
Name	`name`	Name of the Cloud SQL instance. This does not include the project ID.
Project ID	`project`	The project ID of the project containing the Cloud SQL instance. The Google apps domain is prefixed if applicable.
Region	`region`	The geographical region. This value can be: us-central (FIRST_GEN instances only) us-central1 (SECOND_GEN instances only) asia-east1 europe-west1 The value defaults to us-central or us-central1 depending on the instance type. The region cannot be changed after instance creation.
Zone	`gceZone`	The Compute Engine zone that the instance is currently serving from. This value could be different from the zone that was specified when the instance was created if the instance has failed over to its secondary zone. WARNING: Changing this might restart the instance.
Type	`-`	This property is hardcoded to one of the following values depending on the instance type: MySQL PostgreSQL SQL Server
Created At	`createTime`	The time when the instance was created in RFC 3339 format. For example, 2012-11-15T16:19:00.094Z.
Status	`state`	The current serving state of the Cloud SQL instance. This property is an enum with the following possible values: SQL_INSTANCE_STATE_UNSPECIFIED RUNNABLE SUSPENDED PENDING_DELETE PENDING_CREATE MAINTENANCE FAILED
VPC ID	`settings.ipConfiguration.privateNetwork`	The resource link for the VPC network from which the Cloud SQL instance is accessible for private IP. For example, `/projects/myProject/global/networks/default`. This setting can be updated, but it cannot be removed after it is set.
Secondary Gce Zone	`secondaryGceZone`	The Compute Engine zone that the failover instance is currently serving from for a regional instance. This value could be different from the zone that was specified when the instance was created if the instance has failed over to its secondary/failover zone.
Instance Type	`instanceType`	The instance type. This property is an enum with the following possible values: SQL_INSTANCE_TYPE_UNSPECIFIED CLOUD_SQL_INSTANCE ON_PREMISES_INSTANCE READ_REPLICA_INSTANCE
Ip Addresses	`ipAddresses[]`	The assigned IP addresses for the instance.
Backend Type	`backendType`	The backend type. This property is read-only. Use the tier property in the settings object to determine the database type. Possible values: SQL_BACKEND_TYPE_UNSPECIFIED SECOND_GEN: Cloud SQL database instance. EXTERNAL: A database server that is not managed by Google.
Database Version	`databaseVersion`	The database engine type and version. The databaseVersion field cannot be changed after instance creation. This property is an enum with the following possible values: SQL_DATABASE_VERSION_UNSPECIFIED MYSQL_5_6 MYSQL_5_7 SQLSERVER_2017_STANDARD SQLSERVER_2017_ENTERPRISE SQLSERVER_2017_EXPRESS SQLSERVER_2017_WEB POSTGRES_9_6 POSTGRES_10 POSTGRES_11 POSTGRES_12 POSTGRES_13 POSTGRES_14 MYSQL_8_0 MYSQL_8_0_18 MYSQL_8_0_26 MYSQL_8_0_27 MYSQL_8_0_28 MYSQL_8_0_30 MYSQL_8_0_31 MYSQL_8_0_32 MYSQL_8_0_33 SQLSERVER_2019_STANDARD SQLSERVER_2019_ENTERPRISE SQLSERVER_2019_EXPRESS SQLSERVER_2019_WEB
Database Installed Version	`databaseInstalledVersion`	Output only. Stores the current database version running on the instance including the minor version, such as MYSQL_8_0_18.
Kind	`kind`	The value of this property is always sql#instance.
Connection Name	`connectionName`	Connection name of the Cloud SQL instance used in connection strings.
Suspension Reasons	`suspensionReason[]`	If the instance state is SUSPENDED, this property describes the reason for the suspension. This property is an enum with the following possible values: SQL_SUSPENSION_REASON_UNSPECIFIED BILLING_ISSUE LEGAL_ISSUE OPERATIONAL_ISSUE KMS_KEY_ISSUE
Maintenance Start Time	`scheduledMaintenance.startTime`	The start time of any upcoming scheduled maintenance for this instance. The format is a timestamp in RFC3339 UTC "Zulu" format, with nanosecond resolution and up to nine fractional digits. Examples: "2014-10-02T15:01:23Z" "2014-10-02T15:01:23.045123456Z"
Reschedule Maintenance	`scheduledMaintenance.canReschedule`	Specifies if the scheduled maintenance can be rescheduled.
Maintenance Schedule Deadline Time	`scheduledMaintenance.scheduleDeadlineTime`	Maintenance cannot be rescheduled to start beyond this deadline. The format is a timestamp in RFC3339 UTC "Zulu" format, with nanosecond resolution and up to nine fractional digits. Examples: "2014-10-02T15:01:23Z" "2014-10-02T15:01:23.045123456Z"
Data Disk Type	`settings.dataDiskType`	The type of data disk. This property is an enum with the following possible values: SQL_DATA_DISK_TYPE_UNSPECIFIED PD_SSD (default) PD_HDD (not used for First Generation instances)
Availability Type	`settings.availabilityType`	Availability type. This property is an enum with the following possible values: SQL_AVAILABILITY_TYPE_UNSPECIFIED ZONAL: The instance serves data from only one zone. Outages in that zone affect data accessibility. REGIONAL: The instance can serve data from more than one zone in a region (it is highly available).
Size (Gb)	`settings.dataDiskSizeGb`	The size of data disk in GB. The data disk size minimum is 10GB.
Max Allocated Storage (By)	`settings.storageAutoResizeLimit`	The maximum size to which storage capacity can be automatically increased. The default value is 0, which specifies that there is no limit.
Storage Auto Resize	`settings.storageAutoResize`	Configuration to increase storage size automatically. The default value is true.

Display Name	Source Property Name	Description
ID	`selfLink`	The URI of this resource.
Name	`name`	Name of the Cloud SQL instance. This does not include the project ID.
Project ID	`project`	The project ID of the project containing the Cloud SQL instance. The Google apps domain is prefixed if applicable.
Region	`region`	The geographical region. Possible values: us-central (FIRST_GEN instances only) us-central1 (SECOND_GEN instances only) asia-east1 europe-west1 The value defaults to us-central or us-central1 depending on the instance type. The region cannot be changed after instance creation.
Zone	`gceZone`	The Compute Engine zone that the instance is currently serving from. This value could be different from the zone that was specified when the instance was created if the instance has failed over to its secondary zone. WARNING: Changing this might restart the instance.
Type	`-`	This property is hardcoded to one of the following values depending on the instance type: MySQL PostgreSQL SQL Server
Created At	`createTime`	The time when the instance was created in RFC 3339 format. For example, 2012-11-15T16:19:00.094Z.
Status	`state`	The current serving state of the Cloud SQL instance. This property is an enum with the following possible values: SQL_INSTANCE_STATE_UNSPECIFIED RUNNABLE SUSPENDED PENDING_DELETE PENDING_CREATE MAINTENANCE FAILED
VPC ID	`settings.ipConfiguration.privateNetwork`	The resource link for the VPC network from which the Cloud SQL instance is accessible for private IP. For example, `/projects/myProject/global/networks/default`. This setting can be updated, but it cannot be removed after it is set.
Secondary Gce Zone	`secondaryGceZone`	The Compute Engine zone that the failover instance is currently serving from for a regional instance. This value could be different from the zone that was specified when the instance was created if the instance has failed over to its secondary/failover zone.
Instance Type	`instanceType`	The instance type. This property is an enum with the following possible values: SQL_INSTANCE_TYPE_UNSPECIFIED CLOUD_SQL_INSTANCE ON_PREMISES_INSTANCE READ_REPLICA_INSTANCE
Ip Addresses	`ipAddresses[]`	The assigned IP addresses for the instance.
Backend Type	`backendType`	The backend type. This property is read-only. Use the tier property in the settings object to determine the database type. Possible values: SQL_BACKEND_TYPE_UNSPECIFIED SECOND_GEN: Cloud SQL database instance. EXTERNAL: A database server that is not managed by Google.
Database Version	`databaseVersion`	The database engine type and version. The databaseVersion field cannot be changed after instance creation. This property is an enum with the following possible values: SQL_DATABASE_VERSION_UNSPECIFIED MYSQL_5_6 MYSQL_5_7 SQLSERVER_2017_STANDARD SQLSERVER_2017_ENTERPRISE SQLSERVER_2017_EXPRESS SQLSERVER_2017_WEB POSTGRES_9_6 POSTGRES_10 POSTGRES_11 POSTGRES_12 POSTGRES_13 POSTGRES_14 MYSQL_8_0 MYSQL_8_0_18 MYSQL_8_0_26 MYSQL_8_0_27 MYSQL_8_0_28 MYSQL_8_0_30 MYSQL_8_0_31 MYSQL_8_0_32 MYSQL_8_0_33 SQLSERVER_2019_STANDARD SQLSERVER_2019_ENTERPRISE SQLSERVER_2019_EXPRESS SQLSERVER_2019_WEB
Database Installed Version	`databaseInstalledVersion`	Output only. Stores the current database version running on the instance including the minor version, such as MYSQL_8_0_18.
Kind	`kind`	The value of this property is always sql#instance.
Connection Name	`connectionName`	Connection name of the Cloud SQL instance used in connection strings.
Suspension Reasons	`suspensionReason[]`	If the instance state is SUSPENDED, this property specifies the reason for the suspension. The value of this property is an enum with the following possible values: SQL_SUSPENSION_REASON_UNSPECIFIED BILLING_ISSUE LEGAL_ISSUE OPERATIONAL_ISSUE KMS_KEY_ISSUE
Maintenance Start Time	`scheduledMaintenance.startTime`	The start time of any upcoming scheduled maintenance for this instance. The format is a timestamp in RFC3339 UTC "Zulu" format, with nanosecond resolution and up to nine fractional digits. Examples: "2014-10-02T15:01:23Z" "2014-10-02T15:01:23.045123456Z".
Reschedule Maintenance	`scheduledMaintenance.canReschedule`	Specifies if the scheduled maintenance can be rescheduled.
Maintenance Schedule Deadline Time	`scheduledMaintenance.scheduleDeadlineTime`	Maintenance cannot be rescheduled to start beyond this deadline. The format is a timestamp in RFC3339 UTC "Zulu" format, with nanosecond resolution and up to nine fractional digits. Examples: "2014-10-02T15:01:23Z" "2014-10-02T15:01:23.045123456Z".
Data Disk Type	`settings.dataDiskType`	The type of data disk. Not used for First Generation instances. This property is an enum with the following possible values: SQL_DATA_DISK_TYPE_UNSPECIFIED PD_SSD (default) PD_HDD
Availability Type	`settings.availabilityType`	Availability type. This property is an enum with the following possible values: SQL_AVAILABILITY_TYPE_UNSPECIFIED ZONAL: The instance serves data from only one zone. Outages in that zone affect data accessibility. REGIONAL: The instance can serve data from more than one zone in a region (it is highly available).
Size (Gb)	`settings.dataDiskSizeGb`	The size of the data disk in GB. The data disk size minimum is 10GB.
Max Allocated Storage (By)	`settings.storageAutoResizeLimit`	The maximum size to which storage capacity can be automatically increased. The default value is 0, which specifies that there is no limit.
Storage Auto Resize	`settings.storageAutoResize`	Configuration to increase storage size automatically. The default value is true.

Display Name	Source Property Name	Description
ID	`selfLink`	The URI of this resource.
Name	`name`	Name of the Cloud SQL instance. This does not include the project ID.
Project ID	`project`	The project ID of the project containing the Cloud SQL instance. The Google apps domain is prefixed if applicable.
Region	`region`	The geographical region. Possible values: us-central (FIRST_GEN instances only) us-central1 (SECOND_GEN instances only) asia-east1 europe-west1 The value defaults to us-central or us-central1 depending on the instance type. The region cannot be changed after instance creation.
Zone	`gceZone`	The Compute Engine zone that the instance is currently serving from. This value could be different from the zone that was specified when the instance was created if the instance has failed over to its secondary zone. WARNING: Changing this might restart the instance.
Type	`-`	Hardcoded to one of the values: MySQL, PostgreSQL or SQL Server, depending on the instance type.
Created At	`createTime`	The time when the instance was created in RFC 3339 format. For example, 2012-11-15T16:19:00.094Z.
Status	`state`	The current serving state of the Cloud SQL instance. This property is an enum with the following possible values: SQL_INSTANCE_STATE_UNSPECIFIED RUNNABLE SUSPENDED PENDING_DELETE PENDING_CREATE MAINTENANCE FAILED
VPC ID	`settings.ipConfiguration.privateNetwork`	The resource link for the VPC network from which the Cloud SQL instance is accessible for private IP. For example, `/projects/myProject/global/networks/default`. This setting can be updated, but it cannot be removed after it is set.
Secondary Gce Zone	`secondaryGceZone`	The Compute Engine zone that the failover instance is currently serving from for a regional instance. This value could be different from the zone that was specified when the instance was created if the instance has failed over to its secondary/failover zone.
Instance Type	`instanceType`	The instance type. This property is an enum with the following possible values: SQL_INSTANCE_TYPE_UNSPECIFIED CLOUD_SQL_INSTANCE ON_PREMISES_INSTANCE READ_REPLICA_INSTANCE
Ip Addresses	`ipAddresses[]`	The assigned IP addresses for the instance.
Backend Type	`backendType`	The backend type. This property is read-only. Use the tier property in the settings object to determine the database type. Possible values: SQL_BACKEND_TYPE_UNSPECIFIED SECOND_GEN: Cloud SQL database instance. EXTERNAL: A database server that is not managed by Google
Database Version	`databaseVersion`	The database engine type and version. The databaseVersion field cannot be changed after instance creation. This property is an enum with the following possible values: SQL_DATABASE_VERSION_UNSPECIFIED MYSQL_5_6 MYSQL_5_7 SQLSERVER_2017_STANDARD SQLSERVER_2017_ENTERPRISE SQLSERVER_2017_EXPRESS SQLSERVER_2017_WEB POSTGRES_9_6 POSTGRES_10 POSTGRES_11 POSTGRES_12 POSTGRES_13 POSTGRES_14 MYSQL_8_0 MYSQL_8_0_18 MYSQL_8_0_26 MYSQL_8_0_27 MYSQL_8_0_28 MYSQL_8_0_30 MYSQL_8_0_31 MYSQL_8_0_32 MYSQL_8_0_33 SQLSERVER_2019_STANDARD SQLSERVER_2019_ENTERPRISE SQLSERVER_2019_EXPRESS SQLSERVER_2019_WEB
Database Installed Version	`databaseInstalledVersion`	Output only. Stores the current database version running on the instance including minor version, such as MYSQL_8_0_18.
Kind	`kind`	This property is always sql#instance.
Connection Name	`connectionName`	Connection name of the Cloud SQL instance used in connection strings.
Suspension Reasons	`suspensionReason[]`	If the instance state is SUSPENDED, this property specifies the reason for the suspension. This property is an enum with the following possible values: SQL_SUSPENSION_REASON_UNSPECIFIED BILLING_ISSUE LEGAL_ISSUE OPERATIONAL_ISSUE KMS_KEY_ISSUE
Maintenance Start Time	`scheduledMaintenance.startTime`	The start time of any upcoming scheduled maintenance for this instance. The format is a timestamp in RFC3339 UTC "Zulu" format, with nanosecond resolution and up to nine fractional digits. Examples: "2014-10-02T15:01:23Z" "2014-10-02T15:01:23.045123456Z"
Reschedule Maintenance	`scheduledMaintenance.canReschedule`	Specifies if the scheduled maintenance can be rescheduled.
Maintenance Schedule Deadline Time	`scheduledMaintenance.scheduleDeadlineTime`	Maintenance cannot be rescheduled to start beyond this deadline. The format is a timestamp in RFC3339 UTC "Zulu" format, with nanosecond resolution and up to nine fractional digits. Examples: "2014-10-02T15:01:23Z" "2014-10-02T15:01:23.045123456Z"
Data Disk Type	`settings.dataDiskType`	The type of data disk. Not used for First Generation instances. This property is an enum with the following possible values: SQL_DATA_DISK_TYPE_UNSPECIFIED PD_SSD (default) PD_HDD
Availability Type	`settings.availabilityType`	Availability type. This property is an enum with the following possible values: SQL_AVAILABILITY_TYPE_UNSPECIFIED ZONAL: The instance serves data from only one zone. Outages in that zone affect data accessibility REGIONAL: The instance can serve data from more than one zone in a region (it is highly available).
Size (Gb)	`settings.dataDiskSizeGb`	The size of the data disk in GB. The data disk size minimum is 10GB.
Max Allocated Storage (By)	`settings.storageAutoResizeLimit`	The maximum size to which storage capacity can be automatically increased. The default value is 0, which specifies that there is no limit.
Storage Auto Resize	`settings.storageAutoResize`	Configuration to increase storage size automatically. The default value is true.
Time Zone	`settings.timeZone`	Server timezone, relevant only for Cloud SQL for SQL Server.
Active Directory Domain	`settings.activeDirectoryConfig.SqlActiveDirectoryConfig.domain`	The name of the domain (e.g., mydomain.com).

Retention and Purge Time-To-Live (TTL)

For all cloud and infrastructure entities, the retention TTL is 180 minutes (3 hours) and the purge TTL is 525,600 minutes (365 days).

Third party names, logos, marks, and general references used in these materials are the property of their respective owners or their affiliates in the United States and/or other countries. Inclusion of such references are for informational purposes only and are not intended to promote or otherwise suggest a relationship between Splunk AppDynamics and the third party.