Advanced Cloud Database Template for Aurora

Description

Advanced Cloud Database Template for Aurora

Prerequisites

No prerequisite

Supported Metric

Monitor NameMetric NameMetric Display NameUnitDescription
Advanced Cloud MySQL Database Threads Monitormysql.connected.threads.countMySQL Connected Threads countMySQL Connected Threads count.
mysql.created.threadsMySQL Created ThreadscountThe 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.countMySQL Cached Threads countMySQL Cached Threads count.
mysql.running.threadsMySQL Running ThreadscountThe number of threads that are not sleeping.
mysql.threads.stacksizeMySQL Threads StacksizeNULLThe 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 Monitormysq.tmp.table.delta.utilMySL temporary table delta utilizationMySL temporary table delta utilization.
mysq.tmp.table.utilMySQL temporary table utilizationMySQL temporary table utilization.
mysql.temporary.files.createdMySQL Temporary Files CreatedpsecThe rate of temporary files created by second.
mysql.disk.temporarytables.createdMySQL Disk Temporary Tables CreatedpsecThe rate of temporary tables created by second.
mysql.full.table.scan.delta.utilMySQL full table scan delta utilizationMySQL full table scan delta utilization.
mysql.full.table.scan.utilMySQL full table scan utilizationMySQL full table scan utilization.
mysq.open.files.utilMySQL Open file utilizationMySQL Open file utilization.
mysql.open.filesMySQL Open FilescountThe 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.tablesMySQL Open TablescountThe number of tables that have been opened with my_open().
mysql.table.locks_immediateMySQL Table Locks ImmediatecountThe number of times that a request for a table lock could be granted immediately.
Advanced Cloud MySQL Database Network Monitormysql.bytes.receivedMySQL Bytes ReceivedBpsThe number of bytes received from all clients.
mysql.bytes.sentMySQL Bytes SentBpsThe number of bytes sent to all clients.
Advanced Cloud MySQL Database Miscellaneous Monitormysql.slave.statusMySQL Slave StatusMySQL Slave Status.
mysq.slave.seconds.behind.masterMySQL Slave behind masterMySQL Slave behind master.
mysql.system.uptimeMySQL System UptimemMySQL System Uptime.
mysql.streams.openMySQL Streams OpencountThe number of streams that are open (used mainly for logging).
Advanced Cloud MySQL Database innoDB Monitormysql.innodb.data.pending.readsMySQL Innodb Data Pending ReadscountThe current number of pending reads.
mysql.innodb.data.pending.writesMySQL Innodb Data Pending WritescountThe total number of data writes.
mysql.innodb.bufferpool.pagesfreeMySQL Innodb Buffer Pool Pages freecountThe number of free pages in the InnoDB Buffer Pool.
mysql.innodb.bufferpool.pagestotalMysql Innodb Bufferpool PagestotalcountThe total number of pages in the InnoDB Buffer Pool.
mysql.innodb.buffer_pool_readsMySQL Innodb Bufferpool ReadscountThe 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_requestsMySQL Innodb Bufferpool Read RequestscountThe number of reads done to the InnoDB buffer pool.
mysql.innodb.buffer_pool_write_requestsMySQL Innodb Bufferpool Write RequestscountThe number of writes done to the InnoDB buffer pool.
mysql.innodb.bufferpool.dirtypagesMysql Innodb Bufferpool DirtypagescountThe current number of dirty pages in the InnoDB buffer pool.
mysql.innodb.bufferpool.utilizationMySQL Innodb Bufferpool Utilization%The utilization of the InnoDB Buffer Pool.shown as fraction.
mysql.innodb.data.readsMySQL Innodb Data ReadscountThe total number of data reads (OS file reads).
mysql.innodb.data.writesMySQL InnoDB Data WritescountThe total number of data writes.
mysql.innodb.row.lock.waitsMySQL Innodb Row Lock waitscountThe number of times operations on InnoDB tables had to wait for a row lock.
mysql.innodb.row.lock.timemysql Innodb Row Lock TimemsThe total time spent in acquiring row locks for InnoDB tables,in milliseconds.
Advanced Cloud MySQL Database Connection Monitormysql.aborted.clientsMySQL Aborted ClientscountThe number of connections that were aborted because the client died without closing the connection properly.
mysql.max.connectionsMySQL Max ConnectionscountMax Limit of Connections.
mysql.max.connections.connection_errorsMySQL Max Connections Connection ErrorscountThe number of connections refused due to internal server errors.
mysql.aborted.connectsMySQL Aborted ConnectscountThe number of failed attempts to connect to the MySQL server.
mysql.internal.connection.errorsMySQL Internal Connection ErrorscountThe 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.connectsMySQL SSL Client ConnectscountThe number of SSL connection attempts to an SSL-enabled master.
mysql.active.transactionsMySQL Active TransactionscountNumber of active transactions.
mysql.server.connectionsMySQL Server ConnectionscountThe number of connection attempts (successful or not) to the MySQL server.
Advanced Cloud MySQL Database Command Monitormysql.update.commandsMySQL Update CommandspsecThe number of times UPDATE command has been executed.
mysql.select.commandsMySQL Select CommandpsecThe number of times SELECT command has been executed.
mysql.delete.commandsMySQL Delete CommandpsecThe number of times Delete command has been executed.
mysql.insert.commandsMySQL Insert CommandpsecThe number of times Insert command has been executed.
mysql.rollback.commandsMySQL Rollback CommandpsecThe number of times RollBack command has been executed.
mysql.droptable.commandsMySQL DropTable CommandpsecThe number of times Drop Table command has been executed.
mysql.dropuser.commandsMySQL Dropuser CommandspsecThe number of times DROP USER command has been executed.
mysql.dropdatabase.commandsMySQL DropDatabase CommandspsecThe number of times DROP DATABASE command has been executed.
mysql.createtable.commandsMySQL CreateTable CommandspsecThe number of times CREATE TABLE command has been executed.
mysql.createuser.commandsMySQL Createuser CommandspsecThe number of times CREATE USER command has been executed.
mysql.createdatabase.commandsMySQL Createdatabase CommandspsecThe number of times CREATE DATABASE command has been executed
mysql.slow.query.countMySQL Slow Query CountqpmMySQL Slow Query Count

Advanced Cloud Database Template for MariaDB

Description

Advanced Cloud Database Template for MariaDB

Prerequisites

No prerequisite

Supported Metric

Monitor NameMetric NameMetric Display NameUnitDescription
Advanced Cloud MySQL Database Threads Monitormysql.connected.threads.countMySQL Connected Threads countMySQL Connected Threads count.
mysql.created.threadsMySQL Created ThreadscountThe 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.countMySQL Cached Threads countMySQL Cached Threads count.
mysql.running.threadsMySQL Running ThreadscountThe number of threads that are not sleeping.
mysql.threads.stacksizeMySQL Threads StacksizeNULLThe 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 Monitormysq.tmp.table.delta.utilMySL temporary table delta utilizationMySL temporary table delta utilization.
mysq.tmp.table.utilMySQL temporary table utilizationMySQL temporary table utilization.
mysql.temporary.files.createdMySQL Temporary Files CreatedpsecThe rate of temporary files created by second.
mysql.disk.temporarytables.createdMySQL Disk Temporary Tables CreatedpsecThe rate of temporary tables created by second.
mysql.full.table.scan.delta.utilMySQL full table scan delta utilizationMySQL full table scan delta utilization.
mysql.full.table.scan.utilMySQL full table scan utilizationMySQL full table scan utilization.
mysq.open.files.utilMySQL Open file utilizationMySQL Open file utilization.
mysql.open.filesMySQL Open FilescountThe 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.tablesMySQL Open TablescountThe number of tables that have been opened with my_open().
mysql.table.locks_immediateMySQL Table Locks ImmediatecountThe number of times that a request for a table lock could be granted immediately.
Advanced Cloud MySQL Database Network Monitormysql.bytes.receivedMySQL Bytes ReceivedBpsThe number of bytes received from all clients.
mysql.bytes.sentMySQL Bytes SentBpsThe number of bytes sent to all clients.
Advanced Cloud MySQL Database Miscellaneous Monitormysql.slave.statusMySQL Slave StatusMySQL Slave Status.
mysq.slave.seconds.behind.masterMySQL Slave behind masterMySQL Slave behind master.
mysql.system.uptimeMySQL System UptimemMySQL System Uptime.
mysql.streams.openMySQL Streams OpencountThe number of streams that are open (used mainly for logging).
Advanced Cloud MySQL Database innoDB Monitormysql.innodb.data.pending.readsMySQL Innodb Data Pending ReadscountThe current number of pending reads.
mysql.innodb.data.pending.writesMySQL Innodb Data Pending WritescountThe total number of data writes.
mysql.innodb.bufferpool.pagesfreeMySQL Innodb Buffer Pool Pages freecountThe number of free pages in the InnoDB Buffer Pool.
mysql.innodb.bufferpool.pagestotalMysql Innodb Bufferpool PagestotalcountThe total number of pages in the InnoDB Buffer Pool.
mysql.innodb.buffer_pool_readsMySQL Innodb Bufferpool ReadscountThe 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_requestsMySQL Innodb Bufferpool Read RequestscountThe number of reads done to the InnoDB buffer pool.
mysql.innodb.buffer_pool_write_requestsMySQL Innodb Bufferpool Write RequestscountThe number of writes done to the InnoDB buffer pool.
mysql.innodb.bufferpool.dirtypagesMysql Innodb Bufferpool DirtypagescountThe current number of dirty pages in the InnoDB buffer pool.
mysql.innodb.bufferpool.utilizationMySQL Innodb Bufferpool Utilization%The utilization of the InnoDB Buffer Pool. Shown as fraction.
mysql.innodb.data.readsMySQL Innodb Data ReadscountThe total number of data reads (OS file reads).
mysql.innodb.data.writesMySQL InnoDB Data WritescountThe total number of data writes.
mysql.innodb.row.lock.waitsMySQL Innodb Row Lock waitscountThe number of times operations on InnoDB tables had to wait for a row lock.
mysql.innodb.row.lock.timemysql Innodb Row Lock TimemsThe total time spent in acquiring row locks for InnoDB tables,in milliseconds.
Advanced Cloud MySQL Database Connection Monitormysql.aborted.clientsMySQL Aborted ClientscountThe number of connections that were aborted because the client died without closing the connection properly.
mysql.max.connectionsMySQL Max ConnectionscountMax Limit of Connections.
mysql.max.connections.connection_errorsMySQL Max Connections Connection ErrorscountThe number of connections refused due to internal server errors.
mysql.aborted.connectsMySQL Aborted ConnectscountThe number of failed attempts to connect to the MySQL server.
mysql.internal.connection.errorsMySQL Internal Connection ErrorscountThe 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.connectsMySQL SSL Client ConnectscountThe number of SSL connection attempts to an SSL-enabled master.
mysql.active.transactionsMySQL Active TransactionscountNumber of active transactions
mysql.server.connectionsMySQL Server ConnectionscountThe number of connection attempts (successful or not) to the MySQL server.
Advanced Cloud MySQL Database Command Monitormysql.update.commandsMySQL Update CommandspsecThe number of times UPDATE command has been executed.
mysql.select.commandsMySQL Select CommandpsecThe number of times SELECT command has been executed.
mysql.delete.commandsMySQL Delete CommandpsecThe number of times Delete command has been executed.
mysql.insert.commandsMySQL Insert CommandpsecThe number of times Insert command has been executed.
mysql.rollback.commandsMySQL Rollback CommandpsecThe number of times RollBack command has been executed.
mysql.droptable.commandsMySQL DropTable CommandpsecThe number of times Drop Table command has been executed.
mysql.dropuser.commandsMySQL Dropuser CommandspsecThe number of times DROP USER command has been executed.
mysql.dropdatabase.commandsMySQL DropDatabase CommandspsecThe number of times DROP DATABASE command has been executed.
mysql.createtable.commandsMySQL CreateTable CommandspsecThe number of times CREATE TABLE command has been executed.
mysql.createuser.commandsMySQL Createuser CommandspsecThe number of times CREATE USER command has been executed.
mysql.createdatabase.commandsMySQL Createdatabase CommandspsecThe number of times CREATE DATABASE command has been executed.
mysql.slow.query.countMySQL Slow Query CountqpmMySQL Slow Query Count.

Advanced Cloud Database Template for MsSQL

Description

Advanced Cloud Database Template for MsSQL

Prerequisites

No prerequisite

Supported Metric

Monitor NameMetric NameMetric Display NameUnitDescription
Advanced Cloud MSSQL Database Transactions Monitormssql.longest.transaction timeLongest transaction timesThe 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 Monitormssql.batch.requestsBatch requestspsecNumber of SQL batch requests received by server.
mssql.sql.compilationsSql compilationspsecNumber of SQL compilations.
msql.sql.recompilationsSql recompilationspsecNumber 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 Monitormssql.resource.pool.used.memoryResource pool used memoryKBThe amount of memory used,in kilobytes (KB),for the resource pool.
mssql.resource.pool.disk.read.ioResource pool disk read IOropsNumber of read operations from the disk in the last second.
mssql.resource.pool.disk.write.ioResource pool disk write IOwpsNumber of bytes written to the disk in the last second.
Advanced Cloud MSSQL Database Miscellaneous Monitormsql.last.elapsed.timeLast elapsed timemicrosecElapsed time,reported in microseconds (but only accurate to milliseconds),for the most recently completed execution of this plan.
mssql.buffer.cache.hit.ratioBuffer cache hit ratioNonePercentage of pages that were found in the buffer pool without having to incur a read from disk.
mssql.procedure.cache.hit.ratioProcedure Cache Hit RatioNULLProcedure Cache Hit ratio (calculated from server start-up).
mssql.page.life.expectancyMSSQL PageLifeExpectancysNumber of seconds a page will stay in the buffer pool without references.
Advanced Cloud MSSQL Database Memory Manager Monitormssql.total.server.memoryTotal server memoryKBTotal amount of dynamic memory the server is currently consuming.
mssql.memory.grants.pendingMemory Grants PendingNULLCurrent number of processes waiting for a workspace memory grant.
mssql.database.cache.memoryDatabase cache memoryKBAmount of memory the server is currently using for the database cache.
mssql.connection.memoryConnection MemoryKBTotal amount of dynamic memory the server is using for maintaining connections.
mssql.lock.memoryLock MemoryKBTotal amount of dynamic memory the server is using for locks.
mssql.free.memoryFree MemoryKBAmount of memory the server is currently not using.
mssql.sql.cache.memorySQL Cache MemoryKBTotal amount of dynamic memory the server is using for the dynamic SQL cache.
mssql.optimizer.memoryOptimizer MemoryKBTotal amount of dynamic memory the server is using for query optimization.
Advanced Cloud MSSQL Database Locks Monitormssql.lock.waitsLock waitspsecNumber of lock requests that could not be satisfied immediately and required the caller to wait before being granted the lock.
mssql.avg.lock.wait.timeAverage lock wait timemsThe average amount of wait time (milliseconds) for each lock request that resulted in a wait.
mssql.lock.timeoutsLock timeoutspsecNumber of lock requests that timed out. This includes requests for no wait locks.
Advanced Cloud MSSQL Database Latches Monitormssql.latch.waitsLatch waitspsecNumber of latch requests that could not be granted immediately and had to wait before being granted.
Advanced Cloud MSSQL Database General Statistics Monitormssql.user.connectionsUser connectionsNULLThe number of users connected to the system.
mssql.blocked.processBlocked processesNULLThe number of currently blocked processes.
Advanced Cloud MSSQL Database Databases Monitormssql.log.flushesLog FlushespsecThe number of log flushes.
mssql.db.transactionsDb transactionspsecThe number of transactions started for the database.
mssql.db.data.file.sizeData File SizeKBThe cumulative size of all the data files in the database.
mssql.lock.deadlocksDeadlockspsecThe number of lock requests that resulted in a deadlock.
Advanced Cloud MSSQL Database Buffer Monitormssql.database.page.readsPage readspsecNumber of physical database page reads issued.
mssql.database.page.writesDatabase Page writeswpsNumber of physical database page writes issued.
mssql.buffer.lazy.writesBuffer lazy writeswpsNumber of buffers written by buffer manager's lazy writer.
mssql.checkpoint.pagesCheckpoint pagespsecIndicates 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 Monitormssql.page.splitsPage splitspsecThe number of page splits per second that occur as the result of overflowing index pages.
mssql.full.scansFull scanspsecNumber 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 NameMetric NameMetric Display NameUnitDescription
Advanced Cloud MySQL Database Threads Monitormysql.connected.threads.countMySQL Connected Threads countMySQL Connected Threads count.
mysql.created.threadsMySQL Created ThreadscountThe 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.countMySQL Cached Threads countMySQL Cached Threads count.
mysql.running.threadsMySQL Running ThreadscountThe number of threads that are not sleeping.
mysql.threads.stacksizeMySQL Threads StacksizeNULLThe 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 Monitormysq.tmp.table.delta.utilMySL temporary table delta utilizationMySL temporary table delta utilization
mysq.tmp.table.utilMySQL temporary table utilizationMySQL temporary table utilization
mysql.temporary.files.createdMySQL Temporary Files CreatedpsecThe rate of temporary files created by second.
mysql.disk.temporarytables.createdMySQL Disk Temporary Tables CreatedpsecThe rate of temporary tables created by second.
mysql.full.table.scan.delta.utilMySQL full table scan delta utilizationMySQL full table scan delta utilization.
mysql.full.table.scan.utilMySQL full table scan utilizationMySQL full table scan utilization.
mysq.open.files.utilMySQL Open file utilizationMySQL Open file utilization
mysql.open.filesMySQL Open FilescountThe 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.tablesMySQL Open TablescountThe number of tables that have been opened with my_open().
mysql.table.locks_immediateMySQL Table Locks ImmediatecountThe number of times that a request for a table lock could be granted immediately.
Advanced Cloud MySQL Database Network Monitormysql.bytes.receivedMySQL Bytes ReceivedBpsThe number of bytes received from all clients.
mysql.bytes.sentMySQL Bytes SentBpsThe number of bytes sent to all clients.
Advanced Cloud MySQL Database Miscellaneous Monitormysql.slave.statusMySQL Slave StatusMySQL Slave Status.
mysq.slave.seconds.behind.masterMySQL Slave behind masterMySQL Slave behind master.
mysql.system.uptimeMySQL System UptimemMySQL System Uptime.
mysql.streams.openMySQL Streams OpencountThe number of streams that are open (used mainly for logging).
Advanced Cloud MySQL Database innoDB Monitormysql.innodb.data.pending.readsMySQL Innodb Data Pending ReadscountThe current number of pending reads.
mysql.innodb.data.pending.writesMySQL Innodb Data Pending WritescountThe total number of data writes.
mysql.innodb.bufferpool.pagesfreeMySQL Innodb Buffer Pool Pages freecountThe number of free pages in the InnoDB Buffer Pool.
mysql.innodb.bufferpool.pagestotalMysql Innodb Bufferpool PagestotalcountThe total number of pages in the InnoDB Buffer Pool.
mysql.innodb.buffer_pool_readsMySQL Innodb Bufferpool ReadscountThe 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_requestsMySQL Innodb Bufferpool Read RequestscountThe number of reads done to the InnoDB buffer pool.
mysql.innodb.buffer_pool_write_requestsMySQL Innodb Bufferpool Write RequestscountThe number of writes done to the InnoDB buffer pool.
mysql.innodb.bufferpool.dirtypagesMysql Innodb Bufferpool DirtypagescountThe current number of dirty pages in the InnoDB buffer pool.
mysql.innodb.bufferpool.utilizationMySQL Innodb Bufferpool Utilization%The utilization of the InnoDB Buffer Pool. Shown as fraction.
mysql.innodb.data.readsMySQL Innodb Data ReadscountThe total number of data reads (OS file reads).
mysql.innodb.data.writesMySQL InnoDB Data WritescountThe total number of data writes.
mysql.innodb.row.lock.waitsMySQL Innodb Row Lock waitscountThe number of times operations on InnoDB tables had to wait for a row lock.
mysql.innodb.row.lock.timemysql Innodb Row Lock TimemsThe total time spent in acquiring row locks for InnoDB tables,in milliseconds.
Advanced Cloud MySQL Database Connection Monitormysql.aborted.clientsMySQL Aborted ClientscountThe number of connections that were aborted because the client died without closing the connection properly.
mysql.max.connectionsMySQL Max ConnectionscountMax Limit of Connections.
mysql.max.connections.connection_errorsMySQL Max Connections Connection ErrorscountThe number of connections refused due to internal server errors.
mysql.aborted.connectsMySQL Aborted ConnectscountThe number of failed attempts to connect to the MySQL server.
mysql.internal.connection.errorsMySQL Internal Connection ErrorscountThe 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.connectsMySQL SSL Client ConnectscountThe number of SSL connection attempts to an SSL-enabled master.
mysql.active.transactionsMySQL Active TransactionscountNumber of active transactions.
mysql.server.connectionsMySQL Server ConnectionscountThe number of connection attempts (successful or not) to the MySQL server.
Advanced Cloud MySQL Database Command Monitormysql.update.commandsMySQL Update CommandspsecThe number of times UPDATE command has been executed.
mysql.select.commandsMySQL Select CommandpsecThe number of times SELECT command has been executed.
mysql.delete.commandsMySQL Delete CommandpsecThe number of times Delete command has been executed.
mysql.insert.commandsMySQL Insert CommandpsecThe number of times Insert command has been executed.
mysql.rollback.commandsMySQL Rollback CommandpsecThe number of times RollBack command has been executed.
mysql.droptable.commandsMySQL DropTable CommandpsecThe number of times Drop Table command has been executed.
mysql.dropuser.commandsMySQL Dropuser CommandspsecThe number of times DROP USER command has been executed.
mysql.dropdatabase.commandsMySQL DropDatabase CommandspsecThe number of times DROP DATABASE command has been executed.
mysql.createtable.commandsMySQL CreateTable CommandspsecThe number of times CREATE TABLE command has been executed.
mysql.createuser.commandsMySQL Createuser CommandspsecThe number of times CREATE USER command has been executed.
mysql.createdatabase.commandsMySQL Createdatabase CommandspsecThe number of times CREATE DATABASE command has been executed
mysql.slow.query.countMySQL Slow Query CountqpmMySQL Slow Query Count

Advanced Cloud Database Template for Oracle

Description

Advanced Cloud Database Template for Oracle

Prerequisites

No prerequisite

Supported Metric

Monitor NameMetric NameMetric Display NameUnitDescription
Advanced Cloud OracleDB Performanceoracle.invalid.objectsInvalid ObjectscountChecks for invalid objects in database.
oracle.failed.logon.countFailed Logon CountcountIt monitors the failed logon attempts of the current user
oracle.blocking.lock.queriesOracle Blocking Lock QueriescountValidates the how many block lock queries?on particular database.
oracle.long.running.queriesOracle Long Running QueriescountValidates the how many long running queries?on particular database.
Advanced Cloud Oracle Table Spaceoracle.table.space.utilTable Space Utilization%It monitors the table space utilization.
oracle.table.space.usedTable Space UsedMbIt monitors the table space used.
oracle.temp.table.space.freeTemp Table Space FreeMbIt monitors temporary table space free.
oracle.temp.table.space.usedTemp Table Space UsedMbIt monitors temporary table space used.
oracle.temp.table.space.utilTemp Table Space Utilization%It monitors temporary table space utilization.
oracle.table.space.freeOracle Table Space FreeMBValidates the Size allocated for the table by database.
Advanced Cloud Oracle System Summaryoracle.cpu.usage.per.secCPU Usage Per SecNULLThis metric represents the CPU usage per second by the database processes,measured in hundredths of a second.
oracle.cpu.usage.per.txnCPU Usage Per TxnNULLThe amount of CPU usage per transaction for the specific task or session.
oracle.database.cpu.time.ratioDatabase CPU Time RatioNULLThe 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.txnExecutions Per TxnNULLThe average amount of time per execution.
oracle.executions.per.secExecutions Per SecNULLThe average transactions per second.
oracle.sql.service.response.timeSql Service Response TimemsSQL Response Time is the average elapsed time per execution of a representative set of SQL statements,relative to a baseline.
oracle.user.transaction.per.secUser Transaction Per SecNULLThe 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.txnResponse Time Per TxnNULLThe 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.ratioDatabase Wait Time RatioNULLIt monitors database wait time ratio.
Advanced Cloud Oracle System Statsoracle.user.commitsUser CommitspsecThis metric represents the number of user commits performed per second in last two monitoring polls.
oracle.redo.log.space.requestsRedo Log Space RequestsReq per SecIt 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.persecUser RollbackspsecThis 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.lostCache Blocks LostcountThis metric represents the number of global cache blocks lost over the user-defined observation period.
oracle.table.scan.blocks.persecTable Scan BlockspsecNumber of blocks received via table scans.
oracle.io.wait.timeIO Wait TimemsHow much time the application was blocked,waiting for all I/O operation to complete
oracle.logons.per.secLogons Per SeccountThis metric represents the number of logons per second during the sample period.
oracle.db.instance.uptimeDB Instance UptimeDaysIt represents db instance uptime since start up.
oracle.check.db.aliveCheck Db AliveNULLMonitors connectivity to the database instance.
Advanced Cloud Oracle SGA statsoracle.shared.pool.freeShared Pool FreeMBIt monitors the free shared pool memory in MB.
oracle.java.pool.freeJava Pool FreeMBIt monitors the free java pool memory in MB.
oracle.large.pool.freeLarge Pool FreeMBIt monitors the free large pool memory in MB.
Advanced Cloud Oracle Sessionsoracle.session.cpu_usedSession Cpu UsedsIt monitors the session cpu usage in seconds.
oracle.active.sessionsActive SessionscountIt monitors the active sessions
oracle.inactive.sessionsInactive SessionscountIt monitors the inactive sessions
oracle.session.limit.usageSession Limit Usage%It monitors the sessions utilization.
oracle.session.waitsSession WaitssIt monitors the session waits.
Advanced Cloud Oracle Library statsoracle.library.cache.getsOracle Library Cache GetsValidates the Number of Library Cache gets by database.
oracle.library.cachereloadsLibrary Cache ReloadsNULLValidates the Number of Library Cache Reloads by database.
oracle.cache.invalidationsOracle Cache InvalidationsValidates the how many Cache invalidations on particular database.
Advanced Cloud Oracle Errorsoracle.errorsOracleErrorsNULLOracleErrors
Oracle System Summaryoracle.cpu.usage.per.secCPU Usage Per SecNULLThis metric represents the CPU usage per second by the database processes,measured in hundredths of a second.
oracle.cpu.usage.per.txnCPU Usage Per TxnNULLThe amount of CPU usage per transaction for the specific task or session.
oracle.database.cpu.time.ratioDatabase CPU Time RatioNULLThe 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.txnExecutions Per TxnNULLThe average amount of time per execution.
oracle.executions.per.secExecutions Per SecNULLThe average transactions per second.
oracle.sql.service.response.timeSql Service Response TimemsSQL Response Time is the average elapsed time per execution of a representative set of SQL statements,relative to a baseline.
oracle.user.transaction.per.secUser Transaction Per SecNULLThe 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.txnResponse Time Per TxnNULLThe 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.ratioDatabase Wait Time RatioNULLIt monitors database wait time ratio.

Advanced Cloud Database Template for PostgreSQL

Description

Advanced Cloud Database Template for PostgreSQL

Prerequisites

No prerequisite

Supported Metric

Monitor NameMetric NameMetric Display NameUnitDescription
Advanced Cloud PostgreSQL Database Transactions RolledBack Monitorpostgresql.database.transaction.rollbackPostgresql Database Transactions RolledBackNULLNumber of transactions in this database that have been rolled back.
Advanced Cloud PostgreSQL Database Session Monitorpostgresql.activity.countPostgresql Activity CountNULLThis will tell you how close you are to hitting your max_connections limit,and show up any clients which are leaking database connections.
postgresql.locks.countPostgresql Locks CountNULLThe 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 Monitorpostgresql.database.temp_bytesPostgresql Database Temporary BytesNULLTotal 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_fetchedPostgresql Database Rows FetchedNULLNumber of rows fetched by queries in this database.
postgresql.database.rows_returnedPostgresql Database Rows ReturnedNULLNumber of rows returned by queries in this database.
postgresql.database.rows_updatedPostgresql Database Rows UpdatedNULLNumber of rows updated by queries in this database.
postgresql.database.rows_deletedPostgresql Database Rows DeletedNULLNumber of rows deleted by queries in this database.
postgresql.database.rows_insertedPostgresql Database Rows InsertedNULLNumber of rows inserted by queries in this database.
postgresql.stat_tables.seq_tup_readPostgresql Tables Row Sequential ScanNULLNumber of live rows fetched by sequential scans.
postgresql.bgwriter.buffers_checkpointPostgresql Bgwriter Buffers CheckpointNULLNumber of buffers written during checkpoints.
postgresql.bgwriter.buffers_cleanPostgresql Bgwriter Buffers CleanNULLNumber of buffers written by the background writer.
postgresql.bgwriter.buffers_backendPostgresql Bgwriter Buffers BackendNULLNumber of buffers written directly by a backend.
postgresql.bgwriter.checkpoints_timedPostgresql Bgwriter Checkpoints TimedNULLNumber of scheduled checkpoints that have been performed.
postgresql.bgwriter.checkpoints_reqPostgresql Bgwriter Checkpoints RequestNULLNumber of requested checkpoints that have been performed.
Advanced Cloud PostgreSQL Database Memory Monitorpostgresql.database.sizePostgresql Database SizeGBThis helps is know the size of the database.
Advanced Cloud PostgreSQL Database Locks Monitorpostgresql.usertable.rowsdeadPostgresql User Table Rows DeadNULLThis query gives the number of dead rows (tuples) in the table.
postgresql.database.deadlocksPostgresql Database DeadlockscountNumber of deadlocks detected in this database.
postgresql.locks.grantedPostgresql Locks GrantedNULLTrue if lock is held,false if lock is awaited.
Advanced Cloud PostgreSQL Database IO Monitorpostgresql.statio_tables.buffer_hitsPostgresql Statio Tables Buffer HitshpsNumber of buffer hits in this table.
postgresql.statio_tables.index_block_readPostgresql Statio Tables Index Block ReadNULLNumber of disk blocks read from all indexes on this table.
postgresql.statio_tables.index_buffer_hitPostgresql Statio Tables Index Buffer HitshpsNumber of buffer hits in all indexes on this table.
Advanced Cloud PostgreSQL Database Disk Usage Monitorpostgresql.class.relpagesPostgresql Class RelpagescountThis query is used to display the tables and their respective indexes in descending order of relpages.
Advanced Cloud PostgreSQL Database Deadlocks Monitorpostgresql.database.deadlocksPostgresql Database DeadlockscountNumber of deadlocks detected in this database.
postgresql.database.conflict.deadlocksPostgresql Database Conflict DeadlockscountNumber of conflicts in this database that have been canceled due to deadlocks.
Advanced Cloud PostgreSQL Database Cpu Utilization Monitorpostgresql.activity.long_transactionsPostgresql Activity Long TransactionshLong-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 Monitorpostgresql.database.connectionsPostgresql Database ConnectionsNULLThe number of active connections to postgres database.
postgresql.settings.connectionPostgresql Settings ConnectionsNULLThe number of connections to this database as a fraction of the maximum number of allowed connections.
postgresql.user_tables.rows_countPostgresql User Tables Rows CountcountNumber of rows scans.
postgresql.max_connectionsPostgresql Max ConnectionsNULLThe maximum number of client connections allowed to this database.shown as connection.
postgresql.user.table.countUser Table CountNULLIt monitors the number of user tables in current database.
Advanced Cloud PostgreSQL Database BlockHits Monitorpostgresql.statiotables.toastblkshitPostgresql Statio Tables Toast Blks HitNULLNumber of buffer hits in this table's TOAST table (if any).
postgresql.statiotables.idxblkshitPostgresql Statio Tables Idx Blks HitcountNumber of buffer hits in all indexes on this table.
postgresql.database.blkshitPostgresql Database Blocks HitsNULLNumber 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.bufferhitsPostgresql Statio Indexes Buffer HitsNULLNumber 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 NameMetric NameMetric Display NameUnitDescription
Advanced Cloud MSSQL Database Access Methods Monitormssql.page.splitsPage splitspsecThe number of page splits per second that occur as the result of overflowing index pages.
mssql.full.scansFull scanspsecNumber 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 NameMetric NameMetric Display NameUnitDescription
Advanced Cloud MSSQL Database Buffer Monitormssql.database.page.readsPage readspsecNumber of physical database page reads issued.
mssql.database.page.writesDatabase Page writeswpsNumber of physical database page writes issued.
mssql.buffer.lazy.writesBuffer lazy writeswpsNumber of buffers written by buffer manager's lazy writer.
mssql.checkpoint.pagesCheckpoint pagespsecIndicates 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 NameMetric NameMetric Display NameUnitDescription
Advanced Cloud MSSQL Database Databases Monitormssql.log.flushesLog FlushespsecThe number of log flushes.
mssql.db.transactionsDb transactionspsecThe number of transactions started for the database.
mssql.db.data.file.sizeData File SizeKBThe cumulative size of all the data files in the database.
mssql.lock.deadlocksDeadlockspsecThe 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 NameMetric NameMetric Display NameUnitDescription
Advanced Cloud MSSQL Database General Statistics Monitormssql.user.connectionsUser connectionsNULLThe number of users connected to the system.
mssql.blocked.processBlocked processesNULLThe number of currently blocked processes.

Advanced Cloud MSSQL Database Latches Template

Description

Advanced Cloud MSSQL Database Latches Template

Prerequisites

No prerequisite

Supported Metric

Monitor NameMetric NameMetric Display NameUnitDescription
Advanced Cloud MSSQL Database Latches Monitormssql.latch.waitsLatch waitspsecNumber 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 NameMetric NameMetric Display NameUnitDescription
Advanced Cloud MSSQL Database Locks Monitormssql.lock.waitsLock waitspsecNumber of lock requests that could not be satisfied immediately and required the caller to wait before being granted the lock.
mssql.avg.lock.wait.timeAverage lock wait timemsThe average amount of wait time (milliseconds) for each lock request that resulted in a wait.
mssql.lock.timeoutsLock timeoutspsecNumber 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 NameMetric NameMetric Display NameUnitDescription
Advanced Cloud MSSQL Database Memory Manager Monitormssql.total.server.memoryTotal server memoryKBTotal amount of dynamic memory the server is currently consuming.
mssql.memory.grants.pendingMemory Grants PendingNULLCurrent number of processes waiting for a workspace memory grant.
mssql.database.cache.memoryDatabase cache memoryKBAmount of memory the server is currently using for the database cache.
mssql.connection.memoryConnection MemoryKBTotal amount of dynamic memory the server is using for maintaining connections.
mssql.lock.memoryLock MemoryKBTotal amount of dynamic memory the server is using for locks.
mssql.free.memoryFree MemoryKBAmount of memory the server is currently not using.
mssql.sql.cache.memorySQL Cache MemoryKBTotal amount of dynamic memory the server is using for the dynamic SQL cache.
mssql.optimizer.memoryOptimizer MemoryKBTotal 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 NameMetric NameMetric Display NameUnitDescription
Advanced Cloud MSSQL Database Miscellaneous Monitormsql.last.elapsed.timeLast elapsed timemicrosecElapsed time,reported in microseconds (but only accurate to milliseconds),for the most recently completed execution of this plan.
mssql.buffer.cache.hit.ratioBuffer cache hit ratioNonePercentage of pages that were found in the buffer pool without having to incur a read from disk.
mssql.procedure.cache.hit.ratioProcedure Cache Hit RatioNULLProcedure Cache Hit ratio (calculated from server start-up).
mssql.page.life.expectancyMSSQL PageLifeExpectancysNumber 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 NameMetric NameMetric Display NameUnitDescription
Advanced Cloud MSSQL Database Resource pool Stats Monitormssql.resource.pool.used.memoryResource pool used memoryKBThe amount of memory used,in kilobytes (KB),for the resource pool.
mssql.resource.pool.disk.read.ioResource pool disk read IOropsNumber of read operations from the disk in the last second.
mssql.resource.pool.disk.write.ioResource pool disk write IOwpsNumber 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 NameMetric NameMetric Display NameUnitDescription
Advanced Cloud MSSQL Database SQL Statistics Monitormssql.batch.requestsBatch requestspsecNumber of SQL batch requests received by server.
mssql.sql.compilationsSql compilationspsecNumber of SQL compilations.
msql.sql.recompilationsSql recompilationspsecNumber 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 NameMetric NameMetric Display NameUnitDescription
Advanced Cloud MSSQL Database Transactions Monitormssql.longest.transaction timeLongest transaction timesThe 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 NameMetric NameMetric Display NameUnitDescription
Advanced Cloud MySQL Database Command Monitormysql.update.commandsMySQL Update CommandspsecThe number of times UPDATE command has been executed.
mysql.select.commandsMySQL Select CommandpsecThe number of times SELECT command has been executed.
mysql.delete.commandsMySQL Delete CommandpsecThe number of times Delete command has been executed.
mysql.insert.commandsMySQL Insert CommandpsecThe number of times Insert command has been executed.
mysql.rollback.commandsMySQL Rollback CommandpsecThe number of times RollBack command has been executed.
mysql.droptable.commandsMySQL DropTable CommandpsecThe number of times Drop Table command has been executed.
mysql.dropuser.commandsMySQL Dropuser CommandspsecThe number of times DROP USER command has been executed.
mysql.dropdatabase.commandsMySQL DropDatabase CommandspsecThe number of times DROP DATABASE command has been executed.
mysql.createtable.commandsMySQL CreateTable CommandspsecThe number of times CREATE TABLE command has been executed.
mysql.createuser.commandsMySQL Createuser CommandspsecThe number of times CREATE USER command has been executed.
mysql.createdatabase.commandsMySQL Createdatabase CommandspsecThe number of times CREATE DATABASE command has been executed.
mysql.slow.query.countMySQL Slow Query CountqpmMySQL Slow Query Count.

Advanced Cloud MySQL Database Connection Template

Description

Advanced Cloud MySQL Database Connection Template

Prerequisites

No prerequisite

Supported Metric

Monitor NameMetric NameMetric Display NameUnitDescription
Advanced Cloud MySQL Database Connection Monitormysql.aborted.clientsMySQL Aborted ClientscountThe number of connections that were aborted because the client died without closing the connection properly.
mysql.max.connectionsMySQL Max ConnectionscountMax Limit of Connections.
mysql.max.connections.connection_errorsMySQL Max Connections Connection ErrorscountThe number of connections refused due to internal server errors.
mysql.aborted.connectsMySQL Aborted ConnectscountThe number of failed attempts to connect to the MySQL server.
mysql.internal.connection.errorsMySQL Internal Connection ErrorscountThe 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.connectsMySQL SSL Client ConnectscountThe number of SSL connection attempts to an SSL-enabled master.
mysql.active.transactionsMySQL Active TransactionscountNumber of active transactions
mysql.server.connectionsMySQL Server ConnectionscountThe 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 NameMetric NameMetric Display NameUnitDescription
Advanced Cloud MySQL Database innoDB Monitormysql.innodb.data.pending.readsMySQL Innodb Data Pending ReadscountThe current number of pending reads.
mysql.innodb.data.pending.writesMySQL Innodb Data Pending WritescountThe total number of data writes.
mysql.innodb.bufferpool.pagesfreeMySQL Innodb Buffer Pool Pages freecountThe number of free pages in the InnoDB Buffer Pool.
mysql.innodb.bufferpool.pagestotalMysql Innodb Bufferpool PagestotalcountThe total number of pages in the InnoDB Buffer Pool.
mysql.innodb.buffer_pool_readsMySQL Innodb Bufferpool ReadscountThe 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_requestsMySQL Innodb Bufferpool Read RequestscountThe number of reads done to the InnoDB buffer pool.
mysql.innodb.buffer_pool_write_requestsMySQL Innodb Bufferpool Write RequestscountThe number of writes done to the InnoDB buffer pool.
mysql.innodb.bufferpool.dirtypagesMysql Innodb Bufferpool DirtypagescountThe current number of dirty pages in the InnoDB buffer pool.
mysql.innodb.bufferpool.utilizationMySQL Innodb Bufferpool Utilization%The utilization of the InnoDB Buffer Pool. Shown as fraction.
mysql.innodb.data.readsMySQL Innodb Data ReadscountThe total number of data reads (OS file reads).
mysql.innodb.data.writesMySQL InnoDB Data WritescountThe total number of data writes.
mysql.innodb.row.lock.waitsMySQL Innodb Row Lock waitscountThe number of times operations on InnoDB tables had to wait for a row lock.
mysql.innodb.row.lock.timemysql Innodb Row Lock TimemsThe 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 NameMetric NameMetric Display NameUnitDescription
Advanced Cloud MySQL Database Miscellaneous Monitormysql.slave.statusMySQL Slave StatusMySQL Slave Status.
mysq.slave.seconds.behind.masterMySQL Slave behind masterMySQL Slave behind master.
mysql.system.uptimeMySQL System UptimemMySQL System Uptime.
mysql.streams.openMySQL Streams OpencountThe 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 NameMetric NameMetric Display NameUnitDescription
Advanced Cloud MySQL Database Network Monitormysql.bytes.receivedMySQL Bytes ReceivedBpsThe number of bytes received from all clients.
mysql.bytes.sentMySQL Bytes SentBpsThe 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 NameMetric NameMetric Display NameUnitDescription
Advanced Cloud MySQL Database Table Monitormysq.tmp.table.delta.utilMySL temporary table delta utilizationMySL temporary table delta utilization.
mysq.tmp.table.utilMySQL temporary table utilizationMySQL temporary table utilization.
mysql.temporary.files.createdMySQL Temporary Files CreatedpsecThe rate of temporary files created by second.
mysql.disk.temporarytables.createdMySQL Disk Temporary Tables CreatedpsecThe rate of temporary tables created by second.
mysql.full.table.scan.delta.utilMySQL full table scan delta utilizationMySQL full table scan delta utilization.
mysql.full.table.scan.utilMySQL full table scan utilizationMySQL full table scan utilization.
mysq.open.files.utilMySQL Open file utilizationMySQL Open file utilization.
mysql.open.filesMySQL Open FilescountThe 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.tablesMySQL Open TablescountThe number of tables that have been opened with my_open().
mysql.table.locks_immediateMySQL Table Locks ImmediatecountThe 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 NameMetric NameMetric Display NameUnitDescription
Advanced Cloud MySQL Database Threads Monitormysql.connected.threads.countMySQL Connected Threads countMySQL Connected Threads count
mysql.created.threadsMySQL Created ThreadscountThe 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.countMySQL Cached Threads countMySQL Cached Threads count
mysql.running.threadsMySQL Running ThreadscountThe number of threads that are not sleeping.
mysql.threads.stacksizeMySQL Threads StacksizeNULLThe 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 NameMetric NameMetric Display NameUnitDescription
Advanced Cloud Oracle Errorsoracle.errorsOracleErrorsNULLOracleErrors

Advanced Cloud Oracle Database Library stats Template

Description

Advanced Cloud Oracle Database Library stats Template

Prerequisites

No prerequisite

Supported Metric

Monitor NameMetric NameMetric Display NameUnitDescription
Advanced Cloud Oracle Library statsoracle.library.cache.getsOracle Library Cache GetsValidates the Number of Library Cache gets by database.
oracle.library.cachereloadsLibrary Cache ReloadsNULLValidates the Number of Library Cache Reloads by database.
oracle.cache.invalidationsOracle Cache InvalidationsValidates 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 NameMetric NameMetric Display NameUnitDescription
Advanced Cloud OracleDB Performanceoracle.invalid.objectsInvalid ObjectscountChecks for invalid objects in database.
oracle.failed.logon.countFailed Logon CountcountIt monitors the failed logon attempts of the current user.
oracle.blocking.lock.queriesOracle Blocking Lock QueriescountValidates the how many block lock queries?on particular database.
oracle.long.running.queriesOracle Long Running QueriescountValidates 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 NameMetric NameMetric Display NameUnitDescription
Advanced Cloud Oracle Sessionsoracle.session.cpu_usedSession Cpu UsedsIt monitors the session cpu usage in seconds.
oracle.active.sessionsActive SessionscountIt monitors the active sessions.
oracle.inactive.sessionsInactive SessionscountIt monitors the inactive sessions.
oracle.session.limit.usageSession Limit Usage%It monitors the sessions utilization.
oracle.session.waitsSession WaitssIt 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 NameMetric NameMetric Display NameUnitDescription
Advanced Cloud Oracle SGA statsoracle.shared.pool.freeShared Pool FreeMBIt monitors the free shared pool memory in MB.
oracle.java.pool.freeJava Pool FreeMBIt monitors the free java pool memory in MB.
oracle.large.pool.freeLarge Pool FreeMBIt 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 NameMetric NameMetric Display NameUnitDescription
Advanced Cloud Oracle System Statsoracle.user.commitsUser CommitspsecThis metric represents the number of user commits performed per second in last two monitoring polls.
oracle.redo.log.space.requestsRedo Log Space RequestsReq per SecIt 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.persecUser RollbackspsecThis 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.lostCache Blocks LostcountThis metric represents the number of global cache blocks lost over the user-defined observation period.
oracle.table.scan.blocks.persecTable Scan BlockspsecNumber of blocks received via table scans.
oracle.io.wait.timeIO Wait TimemsHow much time the application was blocked,waiting for all I/O operation to complete.
oracle.logons.per.secLogons Per SeccountThis metric represents the number of logons per second during the sample period.
oracle.db.instance.uptimeDB Instance UptimeDaysIt represents db instance uptime since start up.
oracle.check.db.aliveCheck Db AliveNULLMonitors 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 NameMetric NameMetric Display NameUnitDescription
Advanced Cloud Oracle System Summaryoracle.cpu.usage.per.secCPU Usage Per SecNULLThis metric represents the CPU usage per second by the database processes,measured in hundredths of a second.
oracle.cpu.usage.per.txnCPU Usage Per TxnNULLThe amount of CPU usage per transaction for the specific task or session.
oracle.database.cpu.time.ratioDatabase CPU Time RatioNULLThe 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.txnExecutions Per TxnNULLThe average amount of time per execution
oracle.executions.per.secExecutions Per SecNULLThe average transactions per second
oracle.sql.service.response.timeSql Service Response TimemsSQL Response Time is the average elapsed time per execution of a representative set of SQL statements,relative to a baseline.
oracle.user.transaction.per.secUser Transaction Per SecNULLThe 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.txnResponse Time Per TxnNULLThe 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.ratioDatabase Wait Time RatioNULLIt 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 NameMetric NameMetric Display NameUnitDescription
Oracle Table Spaceoracle.table.space.utilTable Space Utilization%It monitors the table space utilization.
oracle.table.space.usedTable Space UsedMbIt monitors the table space used.
oracle.temp.table.space.freeTemp Table Space Free.MbIt monitors temporary table space free.
oracle.temp.table.space.usedTemp Table Space UsedMbIt monitors temporary table space used.
oracle.temp.table.space.utilTemp Table Space Utilization%It monitors temporary table space utilization.
oracle.table.space.freeOracle Table Space FreeMBValidates the Size allocated for the table by database.
Advanced Cloud Oracle Table Spaceoracle.table.space.utilTable Space Utilization%It monitors the table space utilization.
oracle.table.space.usedTable Space UsedMbIt monitors the table space used.
oracle.temp.table.space.freeTemp Table Space FreeMbIt monitors temporary table space free.
oracle.temp.table.space.usedTemp Table Space UsedMbIt monitors temporary table space used.
oracle.temp.table.space.utilTemp Table Space Utilization%It monitors temporary table space utilization.
oracle.table.space.freeOracle Table Space FreeMBValidates 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 NameMetric NameMetric Display NameUnitDescription
Advanced Cloud PostgreSQL Database BlockHits Monitorpostgresql.statiotables.toastblkshitPostgresql Statio Tables Toast Blks HitNULLNumber of buffer hits in this table's TOAST table (if any).
postgresql.statiotables.idxblkshitPostgresql Statio Tables Idx Blks HitcountNumber of buffer hits in all indexes on this table.
postgresql.database.blkshitPostgresql Database Blocks HitsNULLNumber 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.bufferhitsPostgresql Statio Indexes Buffer HitsNULLNumber 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 NameMetric NameMetric Display NameUnitDescription
Advanced Cloud PostgreSQL Database Connection Statistics Monitorpostgresql.database.connectionsPostgresql Database ConnectionsNULLThe number of active connections to postgres database.
postgresql.settings.connectionPostgresql Settings ConnectionsNULLThe number of connections to this database as a fraction of the maximum number of allowed connections.
postgresql.user_tables.rows_countPostgresql User Tables Rows Countcountnumber of rows scans.
postgresql.max_connectionsPostgresql Max ConnectionsNULLThe maximum number of client connections allowed to this database.shown as connection.
postgresql.user.table.countUser Table CountNULLIt 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 NameMetric NameMetric Display NameUnitDescription
Advanced Cloud PostgreSQL Database Cpu Utilization Monitorpostgresql.activity.long_transactionsPostgresql Activity Long TransactionshLong-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 NameMetric NameMetric Display NameUnitDescription
Advanced Cloud PostgreSQL Database Deadlocks Monitorpostgresql.database.deadlocksPostgresql Database DeadlockscountNumber of deadlocks detected in this database.
postgresql.database.conflict.deadlocksPostgresql Database Conflict DeadlockscountNumber 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 NameMetric NameMetric Display NameUnitDescription
Advanced Cloud PostgreSQL Database Disk Usage Monitorpostgresql.class.relpagesPostgresql Class RelpagescountThis 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 NameMetric NameMetric Display NameUnitDescription
Advanced Cloud PostgreSQL Database IO Monitorpostgresql.statio_tables.buffer_hitsPostgresql Statio Tables Buffer HitshpsNumber of buffer hits in this table.
postgresql.statio_tables.index_block_readPostgresql Statio Tables Index Block Read.NULLNumber of disk blocks read from all indexes on this table.
postgresql.statio_tables.index_buffer_hitPostgresql Statio Tables Index Buffer HitshpsNumber 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 NameMetric NameMetric Display NameUnitDescription
Advanced Cloud PostgreSQL Database Locks Monitorpostgresql.usertable.rowsdeadPostgresql User Table Rows DeadNULLThis query gives the number of dead rows (tuples) in the table.
postgresql.database.deadlocksPostgresql Database DeadlockscountNumber of deadlocks detected in this database.
postgresql.locks.grantedPostgresql Locks GrantedNULLTrue 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 NameMetric NameMetric Display NameUnitDescription
Advanced Cloud PostgreSQL Database Memory MonitorAdvanced Cloud PostgreSQL Database Memory MonitorPostgresql Database SizeGBThis 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 NameMetric NameMetric Display NameUnitDescription
Advanced Cloud PostgreSQL Database Performance Monitorpostgresql.database.temp_bytesPostgresql Database Temporary BytesNULLTotal 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_fetchedPostgresql Database Rows FetchedNULLNumber of rows fetched by queries in this database.
postgresql.database.rows_returnedPostgresql Database Rows ReturnedNULLNumber of rows returned by queries in this database.
postgresql.database.rows_updatedPostgresql Database Rows UpdatedNULLNumber of rows updated by queries in this database.
postgresql.database.rows_deletedPostgresql Database Rows DeletedNULLNumber of rows deleted by queries in this database.
postgresql.database.rows_insertedPostgresql Database Rows InsertedNULLNumber of rows inserted by queries in this database.
postgresql.stat_tables.seq_tup_readPostgresql Tables Row Sequential ScanNULLNumber of live rows fetched by sequential scans.
postgresql.bgwriter.buffers_checkpointPostgresql Bgwriter Buffers CheckpointNULLNumber of buffers written during checkpoints
postgresql.bgwriter.buffers_cleanPostgresql Bgwriter Buffers CleanNULLNumber of buffers written by the background writer.
postgresql.bgwriter.buffers_backendPostgresql Bgwriter Buffers BackendNULLNumber of buffers written directly by a backend.
postgresql.bgwriter.checkpoints_timedPostgresql Bgwriter Checkpoints TimedNULLNumber of scheduled checkpoints that have been performed.
postgresql.bgwriter.checkpoints_reqPostgresql Bgwriter Checkpoints RequestNULLNumber 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 NameMetric NameMetric Display NameUnitDescription
Advanced Cloud PostgreSQL Database Session Monitorpostgresql.activity.countPostgresql Activity CountNULLThis will tell you how close you are to hitting your max_connections limit,and show up any clients which are leaking database connections.
postgresql.locks.countPostgresql Locks CountNULLThe 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 NameMetric NameMetric Display NameUnitDescription
Advanced Cloud PostgreSQL Database Transactions RolledBack Monitorpostgresql.database.transaction.rollbackPostgresql Database Transactions RolledBackNULLNumber of transactions in this database that have been rolled back.