Advanced Cloud

Advanced Cloud Database Template for Aurora

Description

Advanced Cloud Database Template for Aurora

Prerequisites

No prerequisite

Supported Metric

Monitor Name	Metric Name	Metric Display Name	Unit	Description
Advanced Cloud MySQL Database Threads Monitor	mysql.connected.threads.count	MySQL Connected Threads count		MySQL Connected Threads count.
	mysql.created.threads	MySQL Created Threads	count	The number of threads created to handle connections. If Threads_created is big,you may want to increase the thread_cache_size value. The cache miss rate can be calculated as Threads_created/Connections.
	mysql.threads.cached.count	MySQL Cached Threads count		MySQL Cached Threads count.
	mysql.running.threads	MySQL Running Threads	count	The number of threads that are not sleeping.
	mysql.threads.stacksize	MySQL Threads Stacksize	NULL	The stack size for each thread. Many of the limits detected by the crash-me test are dependent on this value.
Advanced Cloud MySQL Database Table Monitor	mysq.tmp.table.delta.util	MySL temporary table delta utilization		MySL temporary table delta utilization.
	mysq.tmp.table.util	MySQL temporary table utilization		MySQL temporary table utilization.
	mysql.temporary.files.created	MySQL Temporary Files Created	psec	The rate of temporary files created by second.
	mysql.disk.temporarytables.created	MySQL Disk Temporary Tables Created	psec	The rate of temporary tables created by second.
	mysql.full.table.scan.delta.util	MySQL full table scan delta utilization		MySQL full table scan delta utilization.
	mysql.full.table.scan.util	MySQL full table scan utilization		MySQL full table scan utilization.
	mysq.open.files.util	MySQL Open file utilization		MySQL Open file utilization.
	mysql.open.files	MySQL Open Files	count	The number of files that have been opened with my_open() (a mysys library function). Parts of the server that open files without using this function do not increment the count.
	mysql.open.tables	MySQL Open Tables	count	The number of tables that have been opened with my_open().
	mysql.table.locks_immediate	MySQL Table Locks Immediate	count	The number of times that a request for a table lock could be granted immediately.
Advanced Cloud MySQL Database Network Monitor	mysql.bytes.received	MySQL Bytes Received	Bps	The number of bytes received from all clients.
Advanced Cloud MySQL Database Network Monitor	mysql.bytes.sent	MySQL Bytes Sent	Bps	The number of bytes sent to all clients.
Advanced Cloud MySQL Database Miscellaneous Monitor	mysql.slave.status	MySQL Slave Status		MySQL Slave Status.
	mysq.slave.seconds.behind.master	MySQL Slave behind master		MySQL Slave behind master.
	mysql.system.uptime	MySQL System Uptime	m	MySQL System Uptime.
	mysql.streams.open	MySQL Streams Open	count	The number of streams that are open (used mainly for logging).
Advanced Cloud MySQL Database innoDB Monitor	mysql.innodb.data.pending.reads	MySQL Innodb Data Pending Reads	count	The current number of pending reads.
	mysql.innodb.data.pending.writes	MySQL Innodb Data Pending Writes	count	The total number of data writes.
	mysql.innodb.bufferpool.pagesfree	MySQL Innodb Buffer Pool Pages free	count	The number of free pages in the InnoDB Buffer Pool.
	mysql.innodb.bufferpool.pagestotal	Mysql Innodb Bufferpool Pagestotal	count	The total number of pages in the InnoDB Buffer Pool.
	mysql.innodb.buffer_pool_reads	MySQL Innodb Bufferpool Reads	count	The number of logical reads that InnoDB could not satisfy from the buffer pool,and had to read directly from the disk.
	mysql.innodb.buffer_pool_read_requests	MySQL Innodb Bufferpool Read Requests	count	The number of reads done to the InnoDB buffer pool.
	mysql.innodb.buffer_pool_write_requests	MySQL Innodb Bufferpool Write Requests	count	The number of writes done to the InnoDB buffer pool.
	mysql.innodb.bufferpool.dirtypages	Mysql Innodb Bufferpool Dirtypages	count	The current number of dirty pages in the InnoDB buffer pool.
	mysql.innodb.bufferpool.utilization	MySQL Innodb Bufferpool Utilization	%	The utilization of the InnoDB Buffer Pool.shown as fraction.
	mysql.innodb.data.reads	MySQL Innodb Data Reads	count	The total number of data reads (OS file reads).
	mysql.innodb.data.writes	MySQL InnoDB Data Writes	count	The total number of data writes.
	mysql.innodb.row.lock.waits	MySQL Innodb Row Lock waits	count	The number of times operations on InnoDB tables had to wait for a row lock.
	mysql.innodb.row.lock.time	mysql Innodb Row Lock Time	ms	The total time spent in acquiring row locks for InnoDB tables,in milliseconds.
Advanced Cloud MySQL Database Connection Monitor	mysql.aborted.clients	MySQL Aborted Clients	count	The number of connections that were aborted because the client died without closing the connection properly.
	mysql.max.connections	MySQL Max Connections	count	Max Limit of Connections.
	mysql.max.connections.connection_errors	MySQL Max Connections Connection Errors	count	The number of connections refused due to internal server errors.
	mysql.aborted.connects	MySQL Aborted Connects	count	The number of failed attempts to connect to the MySQL server.
	mysql.internal.connection.errors	MySQL Internal Connection Errors	count	The number of connections refused due to internal errors in the server,such as failure to start a new thread or an out-of-memory condition.
	mysql.ssl.client.connects	MySQL SSL Client Connects	count	The number of SSL connection attempts to an SSL-enabled master.
	mysql.active.transactions	MySQL Active Transactions	count	Number of active transactions.
	mysql.server.connections	MySQL Server Connections	count	The number of connection attempts (successful or not) to the MySQL server.
Advanced Cloud MySQL Database Command Monitor	mysql.update.commands	MySQL Update Commands	psec	The number of times UPDATE command has been executed.
	mysql.select.commands	MySQL Select Command	psec	The number of times SELECT command has been executed.
	mysql.delete.commands	MySQL Delete Command	psec	The number of times Delete command has been executed.
	mysql.insert.commands	MySQL Insert Command	psec	The number of times Insert command has been executed.
	mysql.rollback.commands	MySQL Rollback Command	psec	The number of times RollBack command has been executed.
	mysql.droptable.commands	MySQL DropTable Command	psec	The number of times Drop Table command has been executed.
	mysql.dropuser.commands	MySQL Dropuser Commands	psec	The number of times DROP USER command has been executed.
	mysql.dropdatabase.commands	MySQL DropDatabase Commands	psec	The number of times DROP DATABASE command has been executed.
	mysql.createtable.commands	MySQL CreateTable Commands	psec	The number of times CREATE TABLE command has been executed.
	mysql.createuser.commands	MySQL Createuser Commands	psec	The number of times CREATE USER command has been executed.
	mysql.createdatabase.commands	MySQL Createdatabase Commands	psec	The number of times CREATE DATABASE command has been executed
	mysql.slow.query.count	MySQL Slow Query Count	qpm	MySQL Slow Query Count

Advanced Cloud Database Template for MariaDB

Description

Advanced Cloud Database Template for MariaDB

Prerequisites

No prerequisite

Supported Metric

Monitor Name	Metric Name	Metric Display Name	Unit	Description
Advanced Cloud MySQL Database Threads Monitor	mysql.connected.threads.count	MySQL Connected Threads count		MySQL Connected Threads count.
	mysql.created.threads	MySQL Created Threads	count	The number of threads created to handle connections. If Threads_created is big,you may want to increase the thread_cache_size value. The cache miss rate can be calculated as Threads_created/Connections.
	mysql.threads.cached.count	MySQL Cached Threads count		MySQL Cached Threads count.
	mysql.running.threads	MySQL Running Threads	count	The number of threads that are not sleeping.
	mysql.threads.stacksize	MySQL Threads Stacksize	NULL	The stack size for each thread. Many of the limits detected by the crash-me test are dependent on this value.
Advanced Cloud MySQL Database Table Monitor	mysq.tmp.table.delta.util	MySL temporary table delta utilization		MySL temporary table delta utilization.
	mysq.tmp.table.util	MySQL temporary table utilization		MySQL temporary table utilization.
	mysql.temporary.files.created	MySQL Temporary Files Created	psec	The rate of temporary files created by second.
	mysql.disk.temporarytables.created	MySQL Disk Temporary Tables Created	psec	The rate of temporary tables created by second.
	mysql.full.table.scan.delta.util	MySQL full table scan delta utilization		MySQL full table scan delta utilization.
	mysql.full.table.scan.util	MySQL full table scan utilization		MySQL full table scan utilization.
	mysq.open.files.util	MySQL Open file utilization		MySQL Open file utilization.
	mysql.open.files	MySQL Open Files	count	The number of files that have been opened with my_open() (a mysys library function). Parts of the server that open files without using this function do not increment the count.
	mysql.open.tables	MySQL Open Tables	count	The number of tables that have been opened with my_open().
	mysql.table.locks_immediate	MySQL Table Locks Immediate	count	The number of times that a request for a table lock could be granted immediately.
Advanced Cloud MySQL Database Network Monitor	mysql.bytes.received	MySQL Bytes Received	Bps	The number of bytes received from all clients.
Advanced Cloud MySQL Database Network Monitor	mysql.bytes.sent	MySQL Bytes Sent	Bps	The number of bytes sent to all clients.
Advanced Cloud MySQL Database Miscellaneous Monitor	mysql.slave.status	MySQL Slave Status		MySQL Slave Status.
	mysq.slave.seconds.behind.master	MySQL Slave behind master		MySQL Slave behind master.
	mysql.system.uptime	MySQL System Uptime	m	MySQL System Uptime.
	mysql.streams.open	MySQL Streams Open	count	The number of streams that are open (used mainly for logging).
Advanced Cloud MySQL Database innoDB Monitor	mysql.innodb.data.pending.reads	MySQL Innodb Data Pending Reads	count	The current number of pending reads.
	mysql.innodb.data.pending.writes	MySQL Innodb Data Pending Writes	count	The total number of data writes.
	mysql.innodb.bufferpool.pagesfree	MySQL Innodb Buffer Pool Pages free	count	The number of free pages in the InnoDB Buffer Pool.
	mysql.innodb.bufferpool.pagestotal	Mysql Innodb Bufferpool Pagestotal	count	The total number of pages in the InnoDB Buffer Pool.
	mysql.innodb.buffer_pool_reads	MySQL Innodb Bufferpool Reads	count	The number of logical reads that InnoDB could not satisfy from the buffer pool,and had to read directly from the disk.
	mysql.innodb.buffer_pool_read_requests	MySQL Innodb Bufferpool Read Requests	count	The number of reads done to the InnoDB buffer pool.
	mysql.innodb.buffer_pool_write_requests	MySQL Innodb Bufferpool Write Requests	count	The number of writes done to the InnoDB buffer pool.
	mysql.innodb.bufferpool.dirtypages	Mysql Innodb Bufferpool Dirtypages	count	The current number of dirty pages in the InnoDB buffer pool.
	mysql.innodb.bufferpool.utilization	MySQL Innodb Bufferpool Utilization	%	The utilization of the InnoDB Buffer Pool. Shown as fraction.
	mysql.innodb.data.reads	MySQL Innodb Data Reads	count	The total number of data reads (OS file reads).
	mysql.innodb.data.writes	MySQL InnoDB Data Writes	count	The total number of data writes.
	mysql.innodb.row.lock.waits	MySQL Innodb Row Lock waits	count	The number of times operations on InnoDB tables had to wait for a row lock.
	mysql.innodb.row.lock.time	mysql Innodb Row Lock Time	ms	The total time spent in acquiring row locks for InnoDB tables,in milliseconds.
Advanced Cloud MySQL Database Connection Monitor	mysql.aborted.clients	MySQL Aborted Clients	count	The number of connections that were aborted because the client died without closing the connection properly.
	mysql.max.connections	MySQL Max Connections	count	Max Limit of Connections.
	mysql.max.connections.connection_errors	MySQL Max Connections Connection Errors	count	The number of connections refused due to internal server errors.
	mysql.aborted.connects	MySQL Aborted Connects	count	The number of failed attempts to connect to the MySQL server.
	mysql.internal.connection.errors	MySQL Internal Connection Errors	count	The number of connections refused due to internal errors in the server,such as failure to start a new thread or an out-of-memory condition.
	mysql.ssl.client.connects	MySQL SSL Client Connects	count	The number of SSL connection attempts to an SSL-enabled master.
	mysql.active.transactions	MySQL Active Transactions	count	Number of active transactions
	mysql.server.connections	MySQL Server Connections	count	The number of connection attempts (successful or not) to the MySQL server.
Advanced Cloud MySQL Database Command Monitor	mysql.update.commands	MySQL Update Commands	psec	The number of times UPDATE command has been executed.
	mysql.select.commands	MySQL Select Command	psec	The number of times SELECT command has been executed.
	mysql.delete.commands	MySQL Delete Command	psec	The number of times Delete command has been executed.
	mysql.insert.commands	MySQL Insert Command	psec	The number of times Insert command has been executed.
	mysql.rollback.commands	MySQL Rollback Command	psec	The number of times RollBack command has been executed.
	mysql.droptable.commands	MySQL DropTable Command	psec	The number of times Drop Table command has been executed.
	mysql.dropuser.commands	MySQL Dropuser Commands	psec	The number of times DROP USER command has been executed.
	mysql.dropdatabase.commands	MySQL DropDatabase Commands	psec	The number of times DROP DATABASE command has been executed.
	mysql.createtable.commands	MySQL CreateTable Commands	psec	The number of times CREATE TABLE command has been executed.
	mysql.createuser.commands	MySQL Createuser Commands	psec	The number of times CREATE USER command has been executed.
	mysql.createdatabase.commands	MySQL Createdatabase Commands	psec	The number of times CREATE DATABASE command has been executed.
	mysql.slow.query.count	MySQL Slow Query Count	qpm	MySQL Slow Query Count.

Advanced Cloud Database Template for MsSQL

Description

Advanced Cloud Database Template for MsSQL

Prerequisites

No prerequisite

Supported Metric

Monitor Name	Metric Name	Metric Display Name	Unit	Description
Advanced Cloud MSSQL Database Transactions Monitor	mssql.longest.transaction time	Longest transaction time	s	The length of time (in seconds) since the start of the transaction that has been active longer than any other current transaction. This counter only shows activity when the database is under read committed snapshot isolation level. It does not log any activity if the database is in any other isolation level.
Advanced Cloud MSSQL Database SQL Statistics Monitor	mssql.batch.requests	Batch requests	psec	Number of SQL batch requests received by server.
	mssql.sql.compilations	Sql compilations	psec	Number of SQL compilations.
	msql.sql.recompilations	Sql recompilations	psec	Number of statement recompiles per second. Counts the number of times statement recompiles are triggered. Generally,you want the recompiles to be low.
Advanced Cloud MSSQL Database Resource pool Stats Monitor	mssql.resource.pool.used.memory	Resource pool used memory	KB	The amount of memory used,in kilobytes (KB),for the resource pool.
	mssql.resource.pool.disk.read.io	Resource pool disk read IO	rops	Number of read operations from the disk in the last second.
	mssql.resource.pool.disk.write.io	Resource pool disk write IO	wps	Number of bytes written to the disk in the last second.
Advanced Cloud MSSQL Database Miscellaneous Monitor	msql.last.elapsed.time	Last elapsed time	microsec	Elapsed time,reported in microseconds (but only accurate to milliseconds),for the most recently completed execution of this plan.
	mssql.buffer.cache.hit.ratio	Buffer cache hit ratio	None	Percentage of pages that were found in the buffer pool without having to incur a read from disk.
	mssql.procedure.cache.hit.ratio	Procedure Cache Hit Ratio	NULL	Procedure Cache Hit ratio (calculated from server start-up).
	mssql.page.life.expectancy	MSSQL PageLifeExpectancy	s	Number of seconds a page will stay in the buffer pool without references.
Advanced Cloud MSSQL Database Memory Manager Monitor	mssql.total.server.memory	Total server memory	KB	Total amount of dynamic memory the server is currently consuming.
	mssql.memory.grants.pending	Memory Grants Pending	NULL	Current number of processes waiting for a workspace memory grant.
	mssql.database.cache.memory	Database cache memory	KB	Amount of memory the server is currently using for the database cache.
	mssql.connection.memory	Connection Memory	KB	Total amount of dynamic memory the server is using for maintaining connections.
	mssql.lock.memory	Lock Memory	KB	Total amount of dynamic memory the server is using for locks.
	mssql.free.memory	Free Memory	KB	Amount of memory the server is currently not using.
	mssql.sql.cache.memory	SQL Cache Memory	KB	Total amount of dynamic memory the server is using for the dynamic SQL cache.
	mssql.optimizer.memory	Optimizer Memory	KB	Total amount of dynamic memory the server is using for query optimization.
Advanced Cloud MSSQL Database Locks Monitor	mssql.lock.waits	Lock waits	psec	Number of lock requests that could not be satisfied immediately and required the caller to wait before being granted the lock.
	mssql.avg.lock.wait.time	Average lock wait time	ms	The average amount of wait time (milliseconds) for each lock request that resulted in a wait.
	mssql.lock.timeouts	Lock timeouts	psec	Number of lock requests that timed out. This includes requests for no wait locks.
Advanced Cloud MSSQL Database Latches Monitor	mssql.latch.waits	Latch waits	psec	Number of latch requests that could not be granted immediately and had to wait before being granted.
Advanced Cloud MSSQL Database General Statistics Monitor	mssql.user.connections	User connections	NULL	The number of users connected to the system.
Advanced Cloud MSSQL Database General Statistics Monitor	mssql.blocked.process	Blocked processes	NULL	The number of currently blocked processes.
Advanced Cloud MSSQL Database Databases Monitor	mssql.log.flushes	Log Flushes	psec	The number of log flushes.
	mssql.db.transactions	Db transactions	psec	The number of transactions started for the database.
	mssql.db.data.file.size	Data File Size	KB	The cumulative size of all the data files in the database.
	mssql.lock.deadlocks	Deadlocks	psec	The number of lock requests that resulted in a deadlock.
Advanced Cloud MSSQL Database Buffer Monitor	mssql.database.page.reads	Page reads	psec	Number of physical database page reads issued.
	mssql.database.page.writes	Database Page writes	wps	Number of physical database page writes issued.
	mssql.buffer.lazy.writes	Buffer lazy writes	wps	Number of buffers written by buffer manager's lazy writer.
	mssql.checkpoint.pages	Checkpoint pages	psec	Indicates the number of pages flushed to disk per second by a checkpoint or other operation that require all dirty pages to be flushed.
Advanced Cloud MSSQL Database Access Methods Monitor	mssql.page.splits	Page splits	psec	The number of page splits per second that occur as the result of overflowing index pages.
Advanced Cloud MSSQL Database Access Methods Monitor	mssql.full.scans	Full scans	psec	Number of unrestricted full scans. These can either be base table or full index scans.

Advanced Cloud Database Template for MySQL

Description

Advanced Cloud Database Template for MySQL

Prerequisites

No prerequisite

Supported Metric

Monitor Name	Metric Name	Metric Display Name	Unit	Description
Advanced Cloud MySQL Database Threads Monitor	mysql.connected.threads.count	MySQL Connected Threads count		MySQL Connected Threads count.
	mysql.created.threads	MySQL Created Threads	count	The number of threads created to handle connections. If Threads_created is big,you may want to increase the thread_cache_size value. The cache miss rate can be calculated as Threads_created/Connections.
	mysql.threads.cached.count	MySQL Cached Threads count		MySQL Cached Threads count.
	mysql.running.threads	MySQL Running Threads	count	The number of threads that are not sleeping.
	mysql.threads.stacksize	MySQL Threads Stacksize	NULL	The stack size for each thread. Many of the limits detected by the crash-me test are dependent on this value.
Advanced Cloud MySQL Database Table Monitor	mysq.tmp.table.delta.util	MySL temporary table delta utilization		MySL temporary table delta utilization
	mysq.tmp.table.util	MySQL temporary table utilization		MySQL temporary table utilization
	mysql.temporary.files.created	MySQL Temporary Files Created	psec	The rate of temporary files created by second.
	mysql.disk.temporarytables.created	MySQL Disk Temporary Tables Created	psec	The rate of temporary tables created by second.
	mysql.full.table.scan.delta.util	MySQL full table scan delta utilization		MySQL full table scan delta utilization.
	mysql.full.table.scan.util	MySQL full table scan utilization		MySQL full table scan utilization.
	mysq.open.files.util	MySQL Open file utilization		MySQL Open file utilization
	mysql.open.files	MySQL Open Files	count	The number of files that have been opened with my_open() (a mysys library function). Parts of the server that open files without using this function do not increment the count.
	mysql.open.tables	MySQL Open Tables	count	The number of tables that have been opened with my_open().
	mysql.table.locks_immediate	MySQL Table Locks Immediate	count	The number of times that a request for a table lock could be granted immediately.
Advanced Cloud MySQL Database Network Monitor	mysql.bytes.received	MySQL Bytes Received	Bps	The number of bytes received from all clients.
Advanced Cloud MySQL Database Network Monitor	mysql.bytes.sent	MySQL Bytes Sent	Bps	The number of bytes sent to all clients.
Advanced Cloud MySQL Database Miscellaneous Monitor	mysql.slave.status	MySQL Slave Status		MySQL Slave Status.
	mysq.slave.seconds.behind.master	MySQL Slave behind master		MySQL Slave behind master.
	mysql.system.uptime	MySQL System Uptime	m	MySQL System Uptime.
	mysql.streams.open	MySQL Streams Open	count	The number of streams that are open (used mainly for logging).
Advanced Cloud MySQL Database innoDB Monitor	mysql.innodb.data.pending.reads	MySQL Innodb Data Pending Reads	count	The current number of pending reads.
	mysql.innodb.data.pending.writes	MySQL Innodb Data Pending Writes	count	The total number of data writes.
	mysql.innodb.bufferpool.pagesfree	MySQL Innodb Buffer Pool Pages free	count	The number of free pages in the InnoDB Buffer Pool.
	mysql.innodb.bufferpool.pagestotal	Mysql Innodb Bufferpool Pagestotal	count	The total number of pages in the InnoDB Buffer Pool.
	mysql.innodb.buffer_pool_reads	MySQL Innodb Bufferpool Reads	count	The number of logical reads that InnoDB could not satisfy from the buffer pool,and had to read directly from the disk.
	mysql.innodb.buffer_pool_read_requests	MySQL Innodb Bufferpool Read Requests	count	The number of reads done to the InnoDB buffer pool.
	mysql.innodb.buffer_pool_write_requests	MySQL Innodb Bufferpool Write Requests	count	The number of writes done to the InnoDB buffer pool.
	mysql.innodb.bufferpool.dirtypages	Mysql Innodb Bufferpool Dirtypages	count	The current number of dirty pages in the InnoDB buffer pool.
	mysql.innodb.bufferpool.utilization	MySQL Innodb Bufferpool Utilization	%	The utilization of the InnoDB Buffer Pool. Shown as fraction.
	mysql.innodb.data.reads	MySQL Innodb Data Reads	count	The total number of data reads (OS file reads).
	mysql.innodb.data.writes	MySQL InnoDB Data Writes	count	The total number of data writes.
	mysql.innodb.row.lock.waits	MySQL Innodb Row Lock waits	count	The number of times operations on InnoDB tables had to wait for a row lock.
	mysql.innodb.row.lock.time	mysql Innodb Row Lock Time	ms	The total time spent in acquiring row locks for InnoDB tables,in milliseconds.
Advanced Cloud MySQL Database Connection Monitor	mysql.aborted.clients	MySQL Aborted Clients	count	The number of connections that were aborted because the client died without closing the connection properly.
	mysql.max.connections	MySQL Max Connections	count	Max Limit of Connections.
	mysql.max.connections.connection_errors	MySQL Max Connections Connection Errors	count	The number of connections refused due to internal server errors.
	mysql.aborted.connects	MySQL Aborted Connects	count	The number of failed attempts to connect to the MySQL server.
	mysql.internal.connection.errors	MySQL Internal Connection Errors	count	The number of connections refused due to internal errors in the server,such as failure to start a new thread or an out-of-memory condition.
	mysql.ssl.client.connects	MySQL SSL Client Connects	count	The number of SSL connection attempts to an SSL-enabled master.
	mysql.active.transactions	MySQL Active Transactions	count	Number of active transactions.
	mysql.server.connections	MySQL Server Connections	count	The number of connection attempts (successful or not) to the MySQL server.
Advanced Cloud MySQL Database Command Monitor	mysql.update.commands	MySQL Update Commands	psec	The number of times UPDATE command has been executed.
	mysql.select.commands	MySQL Select Command	psec	The number of times SELECT command has been executed.
	mysql.delete.commands	MySQL Delete Command	psec	The number of times Delete command has been executed.
	mysql.insert.commands	MySQL Insert Command	psec	The number of times Insert command has been executed.
	mysql.rollback.commands	MySQL Rollback Command	psec	The number of times RollBack command has been executed.
	mysql.droptable.commands	MySQL DropTable Command	psec	The number of times Drop Table command has been executed.
	mysql.dropuser.commands	MySQL Dropuser Commands	psec	The number of times DROP USER command has been executed.
	mysql.dropdatabase.commands	MySQL DropDatabase Commands	psec	The number of times DROP DATABASE command has been executed.
	mysql.createtable.commands	MySQL CreateTable Commands	psec	The number of times CREATE TABLE command has been executed.
	mysql.createuser.commands	MySQL Createuser Commands	psec	The number of times CREATE USER command has been executed.
	mysql.createdatabase.commands	MySQL Createdatabase Commands	psec	The number of times CREATE DATABASE command has been executed
	mysql.slow.query.count	MySQL Slow Query Count	qpm	MySQL Slow Query Count

Advanced Cloud Database Template for Oracle

Description

Advanced Cloud Database Template for Oracle

Prerequisites

No prerequisite

Supported Metric

Monitor Name	Metric Name	Metric Display Name	Unit	Description
Advanced Cloud OracleDB Performance	oracle.invalid.objects	Invalid Objects	count	Checks for invalid objects in database.
	oracle.failed.logon.count	Failed Logon Count	count	It monitors the failed logon attempts of the current user
	oracle.blocking.lock.queries	Oracle Blocking Lock Queries	count	Validates the how many block lock queries?on particular database.
	oracle.long.running.queries	Oracle Long Running Queries	count	Validates the how many long running queries?on particular database.
Advanced Cloud Oracle Table Space	oracle.table.space.util	Table Space Utilization	%	It monitors the table space utilization.
	oracle.table.space.used	Table Space Used	Mb	It monitors the table space used.
	oracle.temp.table.space.free	Temp Table Space Free	Mb	It monitors temporary table space free.
	oracle.temp.table.space.used	Temp Table Space Used	Mb	It monitors temporary table space used.
	oracle.temp.table.space.util	Temp Table Space Utilization	%	It monitors temporary table space utilization.
	oracle.table.space.free	Oracle Table Space Free	MB	Validates the Size allocated for the table by database.
Advanced Cloud Oracle System Summary	oracle.cpu.usage.per.sec	CPU Usage Per Sec	NULL	This metric represents the CPU usage per second by the database processes,measured in hundredths of a second.
	oracle.cpu.usage.per.txn	CPU Usage Per Txn	NULL	The amount of CPU usage per transaction for the specific task or session.
	oracle.database.cpu.time.ratio	Database CPU Time Ratio	NULL	The Database CPU Time Ratio is of limited value as a tuning tool. The Database CPU Time Ratio is computed by dividing the amount of CPU used in the database by the amount of total database time. Total database time is the time spent by the database on user-level calls.
	oracle.executions.per.txn	Executions Per Txn	NULL	The average amount of time per execution.
	oracle.executions.per.sec	Executions Per Sec	NULL	The average transactions per second.
	oracle.sql.service.response.time	Sql Service Response Time	ms	SQL Response Time is the average elapsed time per execution of a representative set of SQL statements,relative to a baseline.
	oracle.user.transaction.per.sec	User Transaction Per Sec	NULL	The User Commits Per Sec Oracle metric data item represents the number of user commits performed,per second during the sample period.
	oracle.response.time.per.txn	Response Time Per Txn	NULL	The Response Time Per Txn Oracle metric is using only statistics available within the database,this data item gives the best approximation of response time,in seconds,per transaction during this sample period.
	oracle.database.wait.time.ratio	Database Wait Time Ratio	NULL	It monitors database wait time ratio.
Advanced Cloud Oracle System Stats	oracle.user.commits	User Commits	psec	This metric represents the number of user commits performed per second in last two monitoring polls.
	oracle.redo.log.space.requests	Redo Log Space Requests	Req per Sec	It represents the active log file is full and Oracle is waiting for disk space to be allocated for the redo log entries.
	oracle.user.rollbacks.persec	User Rollbacks	psec	This metric represents the number of times,per second,that users manually issue the ROLLBACK statement or an error occurred during a user's transactions.
	oracle.cache.blocks.lost	Cache Blocks Lost	count	This metric represents the number of global cache blocks lost over the user-defined observation period.
	oracle.table.scan.blocks.persec	Table Scan Blocks	psec	Number of blocks received via table scans.
	oracle.io.wait.time	IO Wait Time	ms	How much time the application was blocked,waiting for all I/O operation to complete
	oracle.logons.per.sec	Logons Per Sec	count	This metric represents the number of logons per second during the sample period.
	oracle.db.instance.uptime	DB Instance Uptime	Days	It represents db instance uptime since start up.
	oracle.check.db.alive	Check Db Alive	NULL	Monitors connectivity to the database instance.
Advanced Cloud Oracle SGA stats	oracle.shared.pool.free	Shared Pool Free	MB	It monitors the free shared pool memory in MB.
	oracle.java.pool.free	Java Pool Free	MB	It monitors the free java pool memory in MB.
	oracle.large.pool.free	Large Pool Free	MB	It monitors the free large pool memory in MB.
Advanced Cloud Oracle Sessions	oracle.session.cpu_used	Session Cpu Used	s	It monitors the session cpu usage in seconds.
	oracle.active.sessions	Active Sessions	count	It monitors the active sessions
	oracle.inactive.sessions	Inactive Sessions	count	It monitors the inactive sessions
	oracle.session.limit.usage	Session Limit Usage	%	It monitors the sessions utilization.
	oracle.session.waits	Session Waits	s	It monitors the session waits.
Advanced Cloud Oracle Library stats	oracle.library.cache.gets	Oracle Library Cache Gets		Validates the Number of Library Cache gets by database.
	oracle.library.cachereloads	Library Cache Reloads	NULL	Validates the Number of Library Cache Reloads by database.
	oracle.cache.invalidations	Oracle Cache Invalidations		Validates the how many Cache invalidations on particular database.
Advanced Cloud Oracle Errors	oracle.errors	OracleErrors	NULL	OracleErrors
Oracle System Summary	oracle.cpu.usage.per.sec	CPU Usage Per Sec	NULL	This metric represents the CPU usage per second by the database processes,measured in hundredths of a second.
	oracle.cpu.usage.per.txn	CPU Usage Per Txn	NULL	The amount of CPU usage per transaction for the specific task or session.
	oracle.database.cpu.time.ratio	Database CPU Time Ratio	NULL	The Database CPU Time Ratio is of limited value as a tuning tool. The Database CPU Time Ratio is computed by dividing the amount of CPU used in the database by the amount of total database time. Total database time is the time spent by the database on user-level calls.
	oracle.executions.per.txn	Executions Per Txn	NULL	The average amount of time per execution.
	oracle.executions.per.sec	Executions Per Sec	NULL	The average transactions per second.
	oracle.sql.service.response.time	Sql Service Response Time	ms	SQL Response Time is the average elapsed time per execution of a representative set of SQL statements,relative to a baseline.
	oracle.user.transaction.per.sec	User Transaction Per Sec	NULL	The User Commits Per Sec Oracle metric data item represents the number of user commits performed,per second during the sample period.
	oracle.response.time.per.txn	Response Time Per Txn	NULL	The Response Time Per Txn Oracle metric is using only statistics available within the database,this data item gives the best approximation of response time,in seconds,per transaction during this sample period.
	oracle.database.wait.time.ratio	Database Wait Time Ratio	NULL	It monitors database wait time ratio.

Advanced Cloud Database Template for PostgreSQL

Description

Advanced Cloud Database Template for PostgreSQL

Prerequisites

No prerequisite

Supported Metric

Monitor Name	Metric Name	Metric Display Name	Unit	Description
Advanced Cloud PostgreSQL Database Transactions RolledBack Monitor	postgresql.database.transaction.rollback	Postgresql Database Transactions RolledBack	NULL	Number of transactions in this database that have been rolled back.
Advanced Cloud PostgreSQL Database Session Monitor	postgresql.activity.count	Postgresql Activity Count	NULL	This will tell you how close you are to hitting your max_connections limit,and show up any clients which are leaking database connections.
Advanced Cloud PostgreSQL Database Session Monitor	postgresql.locks.count	Postgresql Locks Count	NULL	The number of connections blocked waiting for a lock can be an indicator of a slow transaction with an exclusive lock.
Advanced Cloud PostgreSQL Database Performance Monitor	postgresql.database.temp_bytes	Postgresql Database Temporary Bytes	NULL	Total amount of data written to temporary files by queries in this database. All temporary files are counted,regardless of why the temporary file was created,and regardless of the log_temp_files setting.
	postgresql.database.rows_fetched	Postgresql Database Rows Fetched	NULL	Number of rows fetched by queries in this database.
	postgresql.database.rows_returned	Postgresql Database Rows Returned	NULL	Number of rows returned by queries in this database.
	postgresql.database.rows_updated	Postgresql Database Rows Updated	NULL	Number of rows updated by queries in this database.
	postgresql.database.rows_deleted	Postgresql Database Rows Deleted	NULL	Number of rows deleted by queries in this database.
	postgresql.database.rows_inserted	Postgresql Database Rows Inserted	NULL	Number of rows inserted by queries in this database.
	postgresql.stat_tables.seq_tup_read	Postgresql Tables Row Sequential Scan	NULL	Number of live rows fetched by sequential scans.
	postgresql.bgwriter.buffers_checkpoint	Postgresql Bgwriter Buffers Checkpoint	NULL	Number of buffers written during checkpoints.
	postgresql.bgwriter.buffers_clean	Postgresql Bgwriter Buffers Clean	NULL	Number of buffers written by the background writer.
	postgresql.bgwriter.buffers_backend	Postgresql Bgwriter Buffers Backend	NULL	Number of buffers written directly by a backend.
	postgresql.bgwriter.checkpoints_timed	Postgresql Bgwriter Checkpoints Timed	NULL	Number of scheduled checkpoints that have been performed.
	postgresql.bgwriter.checkpoints_req	Postgresql Bgwriter Checkpoints Request	NULL	Number of requested checkpoints that have been performed.
Advanced Cloud PostgreSQL Database Memory Monitor	postgresql.database.size	Postgresql Database Size	GB	This helps is know the size of the database.
Advanced Cloud PostgreSQL Database Locks Monitor	postgresql.usertable.rowsdead	Postgresql User Table Rows Dead	NULL	This query gives the number of dead rows (tuples) in the table.
	postgresql.database.deadlocks	Postgresql Database Deadlocks	count	Number of deadlocks detected in this database.
	postgresql.locks.granted	Postgresql Locks Granted	NULL	True if lock is held,false if lock is awaited.
Advanced Cloud PostgreSQL Database IO Monitor	postgresql.statio_tables.buffer_hits	Postgresql Statio Tables Buffer Hits	hps	Number of buffer hits in this table.
	postgresql.statio_tables.index_block_read	Postgresql Statio Tables Index Block Read	NULL	Number of disk blocks read from all indexes on this table.
	postgresql.statio_tables.index_buffer_hit	Postgresql Statio Tables Index Buffer Hits	hps	Number of buffer hits in all indexes on this table.
Advanced Cloud PostgreSQL Database Disk Usage Monitor	postgresql.class.relpages	Postgresql Class Relpages	count	This query is used to display the tables and their respective indexes in descending order of relpages.
Advanced Cloud PostgreSQL Database Deadlocks Monitor	postgresql.database.deadlocks	Postgresql Database Deadlocks	count	Number of deadlocks detected in this database.
Advanced Cloud PostgreSQL Database Deadlocks Monitor	postgresql.database.conflict.deadlocks	Postgresql Database Conflict Deadlocks	count	Number of conflicts in this database that have been canceled due to deadlocks.
Advanced Cloud PostgreSQL Database Cpu Utilization Monitor	postgresql.activity.long_transactions	Postgresql Activity Long Transactions	h	Long-running transactions are bad because they prevent Postgres from vacuuming old data. This causes database bloat and,in extreme circumstances,shutdown due to transaction ID (xid) wraparound. Transactions should be kept as short as possible,ideally less than a minute.
Advanced Cloud PostgreSQL Database Connection Statistics Monitor	postgresql.database.connections	Postgresql Database Connections	NULL	The number of active connections to postgres database.
	postgresql.settings.connection	Postgresql Settings Connections	NULL	The number of connections to this database as a fraction of the maximum number of allowed connections.
	postgresql.user_tables.rows_count	Postgresql User Tables Rows Count	count	Number of rows scans.
	postgresql.max_connections	Postgresql Max Connections	NULL	The maximum number of client connections allowed to this database.shown as connection.
	postgresql.user.table.count	User Table Count	NULL	It monitors the number of user tables in current database.
Advanced Cloud PostgreSQL Database BlockHits Monitor	postgresql.statiotables.toastblkshit	Postgresql Statio Tables Toast Blks Hit	NULL	Number of buffer hits in this table's TOAST table (if any).
	postgresql.statiotables.idxblkshit	Postgresql Statio Tables Idx Blks Hit	count	Number of buffer hits in all indexes on this table.
	postgresql.database.blkshit	Postgresql Database Blocks Hits	NULL	Number of times disk blocks were found already in the buffer cache,so that a read was not necessary (this only includes hits in the PostgreSQL buffer cache,not the operating system's file system cache).
	postgresql.statioindexes.bufferhits	Postgresql Statio Indexes Buffer Hits	NULL	Number of buffer hits in this index

Advanced Cloud MSSQL Database Access Methods Template

Description

Advanced Cloud MSSQL Database Access Methods Template.

Prerequisites

No prerequisite

Supported Metric

Monitor Name	Metric Name	Metric Display Name	Unit	Description
Advanced Cloud MSSQL Database Access Methods Monitor	mssql.page.splits	Page splits	psec	The number of page splits per second that occur as the result of overflowing index pages.
Advanced Cloud MSSQL Database Access Methods Monitor	mssql.full.scans	Full scans	psec	Number of unrestricted full scans. These can either be base table or full index scans.

Advanced Cloud MSSQL Database Buffer Template

Description

Advanced Cloud MSSQL Database Buffer Template

Prerequisites

No prerequisite

Supported Metric

Monitor Name	Metric Name	Metric Display Name	Unit	Description
Advanced Cloud MSSQL Database Buffer Monitor	mssql.database.page.reads	Page reads	psec	Number of physical database page reads issued.
	mssql.database.page.writes	Database Page writes	wps	Number of physical database page writes issued.
	mssql.buffer.lazy.writes	Buffer lazy writes	wps	Number of buffers written by buffer manager's lazy writer.
	mssql.checkpoint.pages	Checkpoint pages	psec	Indicates the number of pages flushed to disk per second by a checkpoint or other operation that require all dirty pages to be flushed.

Advanced Cloud MSSQL Database Databases Template

Description

Advanced Cloud MSSQL Database Databases Template

Prerequisites

No prerequisite

Supported Metric

Monitor Name	Metric Name	Metric Display Name	Unit	Description
Advanced Cloud MSSQL Database Databases Monitor	mssql.log.flushes	Log Flushes	psec	The number of log flushes.
	mssql.db.transactions	Db transactions	psec	The number of transactions started for the database.
	mssql.db.data.file.size	Data File Size	KB	The cumulative size of all the data files in the database.
	mssql.lock.deadlocks	Deadlocks	psec	The number of lock requests that resulted in a deadlock.

Advanced Cloud MSSQL Database General Statistics Template

Description

Advanced Cloud MSSQL Database General Statistics Template

Prerequisites

No prerequisite

Supported Metric

Monitor Name	Metric Name	Metric Display Name	Unit	Description
Advanced Cloud MSSQL Database General Statistics Monitor	mssql.user.connections	User connections	NULL	The number of users connected to the system.
Advanced Cloud MSSQL Database General Statistics Monitor	mssql.blocked.process	Blocked processes	NULL	The number of currently blocked processes.

Advanced Cloud MSSQL Database Latches Template

Description

Advanced Cloud MSSQL Database Latches Template

Prerequisites

No prerequisite

Supported Metric

Monitor Name	Metric Name	Metric Display Name	Unit	Description
Advanced Cloud MSSQL Database Latches Monitor	mssql.latch.waits	Latch waits	psec	Number of latch requests that could not be granted immediately and had to wait before being granted.

Advanced Cloud MSSQL Database Locks Template

Description

Advanced Cloud MSSQL Database Locks Template

Prerequisites

No prerequisite

Supported Metric

Monitor Name	Metric Name	Metric Display Name	Unit	Description
Advanced Cloud MSSQL Database Locks Monitor	mssql.lock.waits	Lock waits	psec	Number of lock requests that could not be satisfied immediately and required the caller to wait before being granted the lock.
	mssql.avg.lock.wait.time	Average lock wait time	ms	The average amount of wait time (milliseconds) for each lock request that resulted in a wait.
	mssql.lock.timeouts	Lock timeouts	psec	Number of lock requests that timed out. This includes requests for no wait locks.

Advanced Cloud MSSQL Database Memory Manager Template

Description

Advanced Cloud MSSQL Database Memory Manager Template

Prerequisites

No prerequisite

Supported Metric

Monitor Name	Metric Name	Metric Display Name	Unit	Description
Advanced Cloud MSSQL Database Memory Manager Monitor	mssql.total.server.memory	Total server memory	KB	Total amount of dynamic memory the server is currently consuming.
	mssql.memory.grants.pending	Memory Grants Pending	NULL	Current number of processes waiting for a workspace memory grant.
	mssql.database.cache.memory	Database cache memory	KB	Amount of memory the server is currently using for the database cache.
	mssql.connection.memory	Connection Memory	KB	Total amount of dynamic memory the server is using for maintaining connections.
	mssql.lock.memory	Lock Memory	KB	Total amount of dynamic memory the server is using for locks.
	mssql.free.memory	Free Memory	KB	Amount of memory the server is currently not using.
	mssql.sql.cache.memory	SQL Cache Memory	KB	Total amount of dynamic memory the server is using for the dynamic SQL cache.
	mssql.optimizer.memory	Optimizer Memory	KB	Total amount of dynamic memory the server is using for query optimization.

Advanced Cloud MSSQL Database Miscellaneous Template

Description

Advanced Cloud MSSQL Database Miscellaneous Template

Prerequisites

No prerequisite

Supported Metric

Monitor Name	Metric Name	Metric Display Name	Unit	Description
Advanced Cloud MSSQL Database Miscellaneous Monitor	msql.last.elapsed.time	Last elapsed time	microsec	Elapsed time,reported in microseconds (but only accurate to milliseconds),for the most recently completed execution of this plan.
	mssql.buffer.cache.hit.ratio	Buffer cache hit ratio	None	Percentage of pages that were found in the buffer pool without having to incur a read from disk.
	mssql.procedure.cache.hit.ratio	Procedure Cache Hit Ratio	NULL	Procedure Cache Hit ratio (calculated from server start-up).
	mssql.page.life.expectancy	MSSQL PageLifeExpectancy	s	Number of seconds a page will stay in the buffer pool without references.

Advanced Cloud MSSQL Database Resource pool Stats Template

Description

Advanced Cloud MSSQL Database Resource pool Stats Template

Prerequisites

No prerequisite

Supported Metric

Monitor Name	Metric Name	Metric Display Name	Unit	Description
Advanced Cloud MSSQL Database Resource pool Stats Monitor	mssql.resource.pool.used.memory	Resource pool used memory	KB	The amount of memory used,in kilobytes (KB),for the resource pool.
	mssql.resource.pool.disk.read.io	Resource pool disk read IO	rops	Number of read operations from the disk in the last second.
	mssql.resource.pool.disk.write.io	Resource pool disk write IO	wps	Number of bytes written to the disk in the last second.

Advanced Cloud MSSQL Database SQL Statistics Template

Description

Advanced Cloud MSSQL Database SQL Statistics Template

Prerequisites

No prerequisite

Supported Metric

Monitor Name	Metric Name	Metric Display Name	Unit	Description
Advanced Cloud MSSQL Database SQL Statistics Monitor	mssql.batch.requests	Batch requests	psec	Number of SQL batch requests received by server.
	mssql.sql.compilations	Sql compilations	psec	Number of SQL compilations.
	msql.sql.recompilations	Sql recompilations	psec	Number of statement recompiles per second. Counts the number of times statement recompiles are triggered. Generally,you want the recompiles to be low.

Advanced Cloud MSSQL Database Transactions Template

Description

Advanced Cloud MSSQL Database Transactions Template

Prerequisites

No prerequisite

Supported Metric

Monitor Name	Metric Name	Metric Display Name	Unit	Description
Advanced Cloud MSSQL Database Transactions Monitor	mssql.longest.transaction time	Longest transaction time	s	The length of time (in seconds) since the start of the transaction that has been active longer than any other current transaction. This counter only shows activity when the database is under read committed snapshot isolation level. It does not log any activity if the database is in any other isolation level.

Advanced Cloud MySQL Database Command Template

Description

Advanced Cloud MySQL Database Command Template

Prerequisites

No prerequisite

Supported Metric

Monitor Name	Metric Name	Metric Display Name	Unit	Description
Advanced Cloud MySQL Database Command Monitor	mysql.update.commands	MySQL Update Commands	psec	The number of times UPDATE command has been executed.
	mysql.select.commands	MySQL Select Command	psec	The number of times SELECT command has been executed.
	mysql.delete.commands	MySQL Delete Command	psec	The number of times Delete command has been executed.
	mysql.insert.commands	MySQL Insert Command	psec	The number of times Insert command has been executed.
	mysql.rollback.commands	MySQL Rollback Command	psec	The number of times RollBack command has been executed.
	mysql.droptable.commands	MySQL DropTable Command	psec	The number of times Drop Table command has been executed.
	mysql.dropuser.commands	MySQL Dropuser Commands	psec	The number of times DROP USER command has been executed.
	mysql.dropdatabase.commands	MySQL DropDatabase Commands	psec	The number of times DROP DATABASE command has been executed.
	mysql.createtable.commands	MySQL CreateTable Commands	psec	The number of times CREATE TABLE command has been executed.
	mysql.createuser.commands	MySQL Createuser Commands	psec	The number of times CREATE USER command has been executed.
	mysql.createdatabase.commands	MySQL Createdatabase Commands	psec	The number of times CREATE DATABASE command has been executed.
	mysql.slow.query.count	MySQL Slow Query Count	qpm	MySQL Slow Query Count.

Advanced Cloud MySQL Database Connection Template

Description

Advanced Cloud MySQL Database Connection Template

Prerequisites

No prerequisite

Supported Metric

Monitor Name	Metric Name	Metric Display Name	Unit	Description
Advanced Cloud MySQL Database Connection Monitor	mysql.aborted.clients	MySQL Aborted Clients	count	The number of connections that were aborted because the client died without closing the connection properly.
	mysql.max.connections	MySQL Max Connections	count	Max Limit of Connections.
	mysql.max.connections.connection_errors	MySQL Max Connections Connection Errors	count	The number of connections refused due to internal server errors.
	mysql.aborted.connects	MySQL Aborted Connects	count	The number of failed attempts to connect to the MySQL server.
	mysql.internal.connection.errors	MySQL Internal Connection Errors	count	The number of connections refused due to internal errors in the server,such as failure to start a new thread or an out-of-memory condition.
	mysql.ssl.client.connects	MySQL SSL Client Connects	count	The number of SSL connection attempts to an SSL-enabled master.
	mysql.active.transactions	MySQL Active Transactions	count	Number of active transactions
	mysql.server.connections	MySQL Server Connections	count	The number of connection attempts (successful or not) to the MySQL server.

Advanced Cloud MySQL Database innoDB Template

Description

Advanced Cloud MySQL Database innoDB Template

Prerequisites

No prerequisite

Supported Metric

Monitor Name	Metric Name	Metric Display Name	Unit	Description
Advanced Cloud MySQL Database innoDB Monitor	mysql.innodb.data.pending.reads	MySQL Innodb Data Pending Reads	count	The current number of pending reads.
	mysql.innodb.data.pending.writes	MySQL Innodb Data Pending Writes	count	The total number of data writes.
	mysql.innodb.bufferpool.pagesfree	MySQL Innodb Buffer Pool Pages free	count	The number of free pages in the InnoDB Buffer Pool.
	mysql.innodb.bufferpool.pagestotal	Mysql Innodb Bufferpool Pagestotal	count	The total number of pages in the InnoDB Buffer Pool.
	mysql.innodb.buffer_pool_reads	MySQL Innodb Bufferpool Reads	count	The number of logical reads that InnoDB could not satisfy from the buffer pool,and had to read directly from the disk.
	mysql.innodb.buffer_pool_read_requests	MySQL Innodb Bufferpool Read Requests	count	The number of reads done to the InnoDB buffer pool.
	mysql.innodb.buffer_pool_write_requests	MySQL Innodb Bufferpool Write Requests	count	The number of writes done to the InnoDB buffer pool.
	mysql.innodb.bufferpool.dirtypages	Mysql Innodb Bufferpool Dirtypages	count	The current number of dirty pages in the InnoDB buffer pool.
	mysql.innodb.bufferpool.utilization	MySQL Innodb Bufferpool Utilization	%	The utilization of the InnoDB Buffer Pool. Shown as fraction.
	mysql.innodb.data.reads	MySQL Innodb Data Reads	count	The total number of data reads (OS file reads).
	mysql.innodb.data.writes	MySQL InnoDB Data Writes	count	The total number of data writes.
	mysql.innodb.row.lock.waits	MySQL Innodb Row Lock waits	count	The number of times operations on InnoDB tables had to wait for a row lock.
	mysql.innodb.row.lock.time	mysql Innodb Row Lock Time	ms	The total time spent in acquiring row locks for InnoDB tables,in milliseconds.

Advanced Cloud MySQL Database Miscellaneous Template

Description

Advanced Cloud MySQL Database Miscellaneous Template

Prerequisites

No prerequisite

Supported Metric

Monitor Name	Metric Name	Metric Display Name	Unit	Description
Advanced Cloud MySQL Database Miscellaneous Monitor	mysql.slave.status	MySQL Slave Status		MySQL Slave Status.
	mysq.slave.seconds.behind.master	MySQL Slave behind master		MySQL Slave behind master.
	mysql.system.uptime	MySQL System Uptime	m	MySQL System Uptime.
	mysql.streams.open	MySQL Streams Open	count	The number of streams that are open (used mainly for logging).

Advanced Cloud MySQL Database Network Template

Description

Advanced Cloud MySQL Database Network Template

Prerequisites

No prerequisite

Supported Metric

Monitor Name	Metric Name	Metric Display Name	Unit	Description
Advanced Cloud MySQL Database Network Monitor	mysql.bytes.received	MySQL Bytes Received	Bps	The number of bytes received from all clients.
Advanced Cloud MySQL Database Network Monitor	mysql.bytes.sent	MySQL Bytes Sent	Bps	The number of bytes sent to all clients.

Advanced Cloud MySQL Database Table Template

Description

Advanced Cloud MySQL Database Table Template

Prerequisites

No prerequisite

Supported Metric

Monitor Name	Metric Name	Metric Display Name	Unit	Description
Advanced Cloud MySQL Database Table Monitor	mysq.tmp.table.delta.util	MySL temporary table delta utilization		MySL temporary table delta utilization.
	mysq.tmp.table.util	MySQL temporary table utilization		MySQL temporary table utilization.
	mysql.temporary.files.created	MySQL Temporary Files Created	psec	The rate of temporary files created by second.
	mysql.disk.temporarytables.created	MySQL Disk Temporary Tables Created	psec	The rate of temporary tables created by second.
	mysql.full.table.scan.delta.util	MySQL full table scan delta utilization		MySQL full table scan delta utilization.
	mysql.full.table.scan.util	MySQL full table scan utilization		MySQL full table scan utilization.
	mysq.open.files.util	MySQL Open file utilization		MySQL Open file utilization.
	mysql.open.files	MySQL Open Files	count	The number of files that have been opened with my_open() (a mysys library function). Parts of the server that open files without using this function do not increment the count
	mysql.open.tables	MySQL Open Tables	count	The number of tables that have been opened with my_open().
	mysql.table.locks_immediate	MySQL Table Locks Immediate	count	The number of times that a request for a table lock could be granted immediately.

Advanced Cloud MySQL Database Threads Template

Description

Advanced Cloud MySQL Database Threads Template

Prerequisites

No prerequisite

Supported Metric

Monitor Name	Metric Name	Metric Display Name	Unit	Description
Advanced Cloud MySQL Database Threads Monitor	mysql.connected.threads.count	MySQL Connected Threads count		MySQL Connected Threads count
	mysql.created.threads	MySQL Created Threads	count	The number of threads created to handle connections. If Threads_created is big,you may want to increase the thread_cache_size value. The cache miss rate can be calculated as Threads_created/Connections.
	mysql.threads.cached.count	MySQL Cached Threads count		MySQL Cached Threads count
	mysql.running.threads	MySQL Running Threads	count	The number of threads that are not sleeping.
	mysql.threads.stacksize	MySQL Threads Stacksize	NULL	The stack size for each thread. Many of the limits detected by the crash-me test are dependent on this value.

Advanced Cloud Oracle Database Errors Template

Description

Advanced Cloud Oracle Database Errors Template

Prerequisites

No prerequisite

Supported Metric

Monitor Name	Metric Name	Metric Display Name	Unit	Description
Advanced Cloud Oracle Errors	oracle.errors	OracleErrors	NULL	OracleErrors

Advanced Cloud Oracle Database Library stats Template

Description

Advanced Cloud Oracle Database Library stats Template

Prerequisites

No prerequisite

Supported Metric

Monitor Name	Metric Name	Metric Display Name	Unit	Description
Advanced Cloud Oracle Library stats	oracle.library.cache.gets	Oracle Library Cache Gets		Validates the Number of Library Cache gets by database.
	oracle.library.cachereloads	Library Cache Reloads	NULL	Validates the Number of Library Cache Reloads by database.
	oracle.cache.invalidations	Oracle Cache Invalidations		Validates the how many Cache invalidations on particular database.

Advanced Cloud Oracle Database Performance Template

Description

Advanced Cloud Oracle Database Performance Template

Prerequisites

No prerequisite

Supported Metric

Monitor Name	Metric Name	Metric Display Name	Unit	Description
Advanced Cloud OracleDB Performance	oracle.invalid.objects	Invalid Objects	count	Checks for invalid objects in database.
	oracle.failed.logon.count	Failed Logon Count	count	It monitors the failed logon attempts of the current user.
	oracle.blocking.lock.queries	Oracle Blocking Lock Queries	count	Validates the how many block lock queries?on particular database.
	oracle.long.running.queries	Oracle Long Running Queries	count	Validates the how many long running queries?on particular database.

Advanced Cloud Oracle Database Sessions Template

Description

Advanced Cloud Oracle Database Sessions Template

Prerequisites

No prerequisite

Supported Metric

Monitor Name	Metric Name	Metric Display Name	Unit	Description
Advanced Cloud Oracle Sessions	oracle.session.cpu_used	Session Cpu Used	s	It monitors the session cpu usage in seconds.
	oracle.active.sessions	Active Sessions	count	It monitors the active sessions.
	oracle.inactive.sessions	Inactive Sessions	count	It monitors the inactive sessions.
	oracle.session.limit.usage	Session Limit Usage	%	It monitors the sessions utilization.
	oracle.session.waits	Session Waits	s	It monitors the session waits.

Advanced Cloud Oracle Database SGA stats Template

Description

Advanced Cloud Oracle Database SGA stats Template

Prerequisites

No prerequisite

Supported Metric

Monitor Name	Metric Name	Metric Display Name	Unit	Description
Advanced Cloud Oracle SGA stats	oracle.shared.pool.free	Shared Pool Free	MB	It monitors the free shared pool memory in MB.
	oracle.java.pool.free	Java Pool Free	MB	It monitors the free java pool memory in MB.
	oracle.large.pool.free	Large Pool Free	MB	It monitors the free large pool memory in MB.

Advanced Cloud Oracle Database System Stats Template

Description

Advanced Cloud Oracle Database System Stats Template

Prerequisites

No prerequisite

Supported Metric

Monitor Name	Metric Name	Metric Display Name	Unit	Description
Advanced Cloud Oracle System Stats	oracle.user.commits	User Commits	psec	This metric represents the number of user commits performed per second in last two monitoring polls.
	oracle.redo.log.space.requests	Redo Log Space Requests	Req per Sec	It represents the active log file is full and Oracle is waiting for disk space to be allocated for the redo log entries.
	oracle.user.rollbacks.persec	User Rollbacks	psec	This metric represents the number of times,per second,that users manually issue the ROLLBACK statement or an error occurred during a user's transactions.
	oracle.cache.blocks.lost	Cache Blocks Lost	count	This metric represents the number of global cache blocks lost over the user-defined observation period.
	oracle.table.scan.blocks.persec	Table Scan Blocks	psec	Number of blocks received via table scans.
	oracle.io.wait.time	IO Wait Time	ms	How much time the application was blocked,waiting for all I/O operation to complete.
	oracle.logons.per.sec	Logons Per Sec	count	This metric represents the number of logons per second during the sample period.
	oracle.db.instance.uptime	DB Instance Uptime	Days	It represents db instance uptime since start up.
	oracle.check.db.alive	Check Db Alive	NULL	Monitors connectivity to the database instance.

Advanced Cloud Oracle Database System Summary Template

Description

Advanced Cloud Oracle Database System Summary Template

Prerequisites

No prerequisite

Supported Metric

Monitor Name	Metric Name	Metric Display Name	Unit	Description
Advanced Cloud Oracle System Summary	oracle.cpu.usage.per.sec	CPU Usage Per Sec	NULL	This metric represents the CPU usage per second by the database processes,measured in hundredths of a second.
	oracle.cpu.usage.per.txn	CPU Usage Per Txn	NULL	The amount of CPU usage per transaction for the specific task or session.
	oracle.database.cpu.time.ratio	Database CPU Time Ratio	NULL	The Database CPU Time Ratio is of limited value as a tuning tool.The Database CPU Time Ratio is computed by dividing the amount of CPU used in the database by the amount of total database time. Total database time is the time spent by the database on user-level calls.
	oracle.executions.per.txn	Executions Per Txn	NULL	The average amount of time per execution
	oracle.executions.per.sec	Executions Per Sec	NULL	The average transactions per second
	oracle.sql.service.response.time	Sql Service Response Time	ms	SQL Response Time is the average elapsed time per execution of a representative set of SQL statements,relative to a baseline.
	oracle.user.transaction.per.sec	User Transaction Per Sec	NULL	The User Commits Per Sec Oracle metric data item represents the number of user commits performed,per second during the sample period.
	oracle.response.time.per.txn	Response Time Per Txn	NULL	The Response Time Per Txn Oracle metric is using only statistics available within the database,this data item gives the best approximation of response time,in seconds,per transaction during this sample period.
	oracle.database.wait.time.ratio	Database Wait Time Ratio	NULL	It monitors database wait time ratio.

Advanced Cloud Oracle Database Table Space Template

Description

Advanced Cloud Oracle Database Table Space Template

Prerequisites

No prerequisite

Supported Metric

Monitor Name	Metric Name	Metric Display Name	Unit	Description
Oracle Table Space	oracle.table.space.util	Table Space Utilization	%	It monitors the table space utilization.
	oracle.table.space.used	Table Space Used	Mb	It monitors the table space used.
	oracle.temp.table.space.free	Temp Table Space Free.	Mb	It monitors temporary table space free.
	oracle.temp.table.space.used	Temp Table Space Used	Mb	It monitors temporary table space used.
	oracle.temp.table.space.util	Temp Table Space Utilization	%	It monitors temporary table space utilization.
	oracle.table.space.free	Oracle Table Space Free	MB	Validates the Size allocated for the table by database.
Advanced Cloud Oracle Table Space	oracle.table.space.util	Table Space Utilization	%	It monitors the table space utilization.
	oracle.table.space.used	Table Space Used	Mb	It monitors the table space used.
	oracle.temp.table.space.free	Temp Table Space Free	Mb	It monitors temporary table space free.
	oracle.temp.table.space.used	Temp Table Space Used	Mb	It monitors temporary table space used.
	oracle.temp.table.space.util	Temp Table Space Utilization	%	It monitors temporary table space utilization.
	oracle.table.space.free	Oracle Table Space Free	MB	Validates the Size allocated for the table by database.

Advanced Cloud PostgreSQL Database BlockHits Template

Description

Advanced Cloud PostgreSQL Database BlockHits Template.

Prerequisites

No prerequisite

Supported Metric

Monitor Name	Metric Name	Metric Display Name	Unit	Description
Advanced Cloud PostgreSQL Database BlockHits Monitor	postgresql.statiotables.toastblkshit	Postgresql Statio Tables Toast Blks Hit	NULL	Number of buffer hits in this table's TOAST table (if any).
	postgresql.statiotables.idxblkshit	Postgresql Statio Tables Idx Blks Hit	count	Number of buffer hits in all indexes on this table.
	postgresql.database.blkshit	Postgresql Database Blocks Hits	NULL	Number of times disk blocks were found already in the buffer cache,so that a read was not necessary (this only includes hits in the PostgreSQL buffer cache,not the operating system's file system cache).
	postgresql.statioindexes.bufferhits	Postgresql Statio Indexes Buffer Hits	NULL	Number of buffer hits in this index.

Advanced Cloud PostgreSQL Database Connection Statistics Template

Description

Advanced Cloud PostgreSQL Database Connection Statistics Template.

Prerequisites

No prerequisite

Supported Metric

Monitor Name	Metric Name	Metric Display Name	Unit	Description
Advanced Cloud PostgreSQL Database Connection Statistics Monitor	postgresql.database.connections	Postgresql Database Connections	NULL	The number of active connections to postgres database.
	postgresql.settings.connection	Postgresql Settings Connections	NULL	The number of connections to this database as a fraction of the maximum number of allowed connections.
	postgresql.user_tables.rows_count	Postgresql User Tables Rows Count	count	number of rows scans.
	postgresql.max_connections	Postgresql Max Connections	NULL	The maximum number of client connections allowed to this database.shown as connection.
	postgresql.user.table.count	User Table Count	NULL	It monitors the number of user tables in current database.

Advanced Cloud PostgreSQL Database Cpu Utilization Template

Description

Advanced Cloud PostgreSQL Database Cpu Utilization Template.

Prerequisites

No prerequisite

Supported Metric

Monitor Name	Metric Name	Metric Display Name	Unit	Description
Advanced Cloud PostgreSQL Database Cpu Utilization Monitor	postgresql.activity.long_transactions	Postgresql Activity Long Transactions	h	Long-running transactions are bad because they prevent Postgres from vacuuming old data. This causes database bloat and,in extreme circumstances,shutdown due to transaction ID (xid) wraparound. Transactions should be kept as short as possible,ideally less than a minute.

Advanced Cloud PostgreSQL Database Deadlocks Template

Description

Advanced Cloud PostgreSQL Database Deadlocks Template

Prerequisites

No prerequisite

Supported Metric

Monitor Name	Metric Name	Metric Display Name	Unit	Description
Advanced Cloud PostgreSQL Database Deadlocks Monitor	postgresql.database.deadlocks	Postgresql Database Deadlocks	count	Number of deadlocks detected in this database.
Advanced Cloud PostgreSQL Database Deadlocks Monitor	postgresql.database.conflict.deadlocks	Postgresql Database Conflict Deadlocks	count	Number of conflicts in this database that have been canceled due to deadlocks.

Advanced Cloud PostgreSQL Database Disk Usage Template

Description

Advanced Cloud PostgreSQL Database Disk Usage Template.

Prerequisites

No prerequisite

Supported Metric

Monitor Name	Metric Name	Metric Display Name	Unit	Description
Advanced Cloud PostgreSQL Database Disk Usage Monitor	postgresql.class.relpages	Postgresql Class Relpages	count	This query is used to display the tables and their respective indexes in descending order of relpages.

Advanced Cloud PostgreSQL Database IO Template

Description

Advanced Cloud PostgreSQL Database IO Template.

Prerequisites

No prerequisite

Supported Metric

Monitor Name	Metric Name	Metric Display Name	Unit	Description
Advanced Cloud PostgreSQL Database IO Monitor	postgresql.statio_tables.buffer_hits	Postgresql Statio Tables Buffer Hits	hps	Number of buffer hits in this table.
	postgresql.statio_tables.index_block_read	Postgresql Statio Tables Index Block Read.	NULL	Number of disk blocks read from all indexes on this table.
	postgresql.statio_tables.index_buffer_hit	Postgresql Statio Tables Index Buffer Hits	hps	Number of buffer hits in all indexes on this table

Advanced Cloud PostgreSQL Database Locks Template

Description

Advanced Cloud PostgreSQL Database Locks Template.

Prerequisites

No prerequisite

Supported Metric

Monitor Name	Metric Name	Metric Display Name	Unit	Description
Advanced Cloud PostgreSQL Database Locks Monitor	postgresql.usertable.rowsdead	Postgresql User Table Rows Dead	NULL	This query gives the number of dead rows (tuples) in the table.
	postgresql.database.deadlocks	Postgresql Database Deadlocks	count	Number of deadlocks detected in this database.
	postgresql.locks.granted	Postgresql Locks Granted	NULL	True if lock is held,false if lock is awaited.

Advanced Cloud PostgreSQL Database Memory Template

Description

Advanced Cloud PostgreSQL Database Memory Template.

Prerequisites

No prerequisite

Supported Metric

Monitor Name	Metric Name	Metric Display Name	Unit	Description
Advanced Cloud PostgreSQL Database Memory Monitor	Advanced Cloud PostgreSQL Database Memory Monitor	Postgresql Database Size	GB	This helps is know the size of the database.

Advanced Cloud PostgreSQL Database Performance Template

Description

Advanced Cloud PostgreSQL Database Performance Template.

Prerequisites

No prerequisite

Supported Metric

Monitor Name	Metric Name	Metric Display Name	Unit	Description
Advanced Cloud PostgreSQL Database Performance Monitor	postgresql.database.temp_bytes	Postgresql Database Temporary Bytes	NULL	Total amount of data written to temporary files by queries in this database. All temporary files are counted,regardless of why the temporary file was created,and regardless of the log_temp_files setting.
	postgresql.database.rows_fetched	Postgresql Database Rows Fetched	NULL	Number of rows fetched by queries in this database.
	postgresql.database.rows_returned	Postgresql Database Rows Returned	NULL	Number of rows returned by queries in this database.
	postgresql.database.rows_updated	Postgresql Database Rows Updated	NULL	Number of rows updated by queries in this database.
	postgresql.database.rows_deleted	Postgresql Database Rows Deleted	NULL	Number of rows deleted by queries in this database.
	postgresql.database.rows_inserted	Postgresql Database Rows Inserted	NULL	Number of rows inserted by queries in this database.
	postgresql.stat_tables.seq_tup_read	Postgresql Tables Row Sequential Scan	NULL	Number of live rows fetched by sequential scans.
	postgresql.bgwriter.buffers_checkpoint	Postgresql Bgwriter Buffers Checkpoint	NULL	Number of buffers written during checkpoints
	postgresql.bgwriter.buffers_clean	Postgresql Bgwriter Buffers Clean	NULL	Number of buffers written by the background writer.
	postgresql.bgwriter.buffers_backend	Postgresql Bgwriter Buffers Backend	NULL	Number of buffers written directly by a backend.
	postgresql.bgwriter.checkpoints_timed	Postgresql Bgwriter Checkpoints Timed	NULL	Number of scheduled checkpoints that have been performed.
	postgresql.bgwriter.checkpoints_req	Postgresql Bgwriter Checkpoints Request	NULL	Number of requested checkpoints that have been performed.

Advanced Cloud PostgreSQL Database Session Template

Description

Advanced Cloud PostgreSQL Database Session Template.

Prerequisites

No prerequisite

Supported Metric

Monitor Name	Metric Name	Metric Display Name	Unit	Description
Advanced Cloud PostgreSQL Database Session Monitor	postgresql.activity.count	Postgresql Activity Count	NULL	This will tell you how close you are to hitting your max_connections limit,and show up any clients which are leaking database connections.
Advanced Cloud PostgreSQL Database Session Monitor	postgresql.locks.count	Postgresql Locks Count	NULL	The number of connections blocked waiting for a lock can be an indicator of a slow transaction with an exclusive lock.

Advanced Cloud PostgreSQL Database Transactions RolledBack Template

Description

Advanced Cloud PostgreSQL Database Transactions RolledBack Template.

Prerequisites

No prerequisite

Supported Metric

Monitor Name	Metric Name	Metric Display Name	Unit	Description
Advanced Cloud PostgreSQL Database Transactions RolledBack Monitor	postgresql.database.transaction.rollback	Postgresql Database Transactions RolledBack	NULL	Number of transactions in this database that have been rolled back.