dbWatch AS

Capacity

Jobs in the Capacity category

Control Center Jobs Description
Oracle
ASM disk statistics Checks ASM disks for status and statistics.
ASM diskgroup space Checks ASM diskgroups space statistics.
Monitor SYS.AUD$ table size Checks size of the AUD$ trail table.
Autoextensible data files Checks all tablespaces for total disk space usage (autoextensible data files).
Disk space check Disk space check requiring java support database. (Supports Linux, Solaris, AIX, HPUX and Windows).
Flash Recovery Area Usage Checks space usage in the flash recovery area.
Flash Recovery Area Usage Checks space usage in the flash recovery area.
Free extents Checks for free extents in all tablespaces. A warning or an alarm is returned if segments storage value is higher than the largest free extent chunk.
Max processes Checks the maximum number of processes.
ASM diskgroup space Checking available space on the ASM diskgroups
Extent fragmentation Checking for extent fragmentation in dba_free_space
Flash recovery space usage Checking available space on the Flash recovery area
Max processes Checking if database reaches max processes (processes) parameter
SYS.AUD size Checking if SYS.AUD$ fills up with data
Tablespace free space Checking tablespaces for free space
Segment size collector Collects size and number totals on all segment types per segment-owner and tablespace_name.
Segment size collector Collects size and number totals on all segment types per segment-owner and tablespace_name.
Segment size collector Collects size and extent number info for larger segments in the database.
Segment size status for old style tablespaces Checks segment storage definitions in tablespaces where extent management is not set to local.
Temporary tablespace free space check Checks level of free space for temporary tablespaces.
Tablespace free space check Checks level of free space for all tablespaces.
MS SQL Server
Auto growth event collector Collects statistics on how often an auto-growth event has occurred.
Data file size check Checks the remaining space for all databases where the data files are set with limited growth rate (max size not unlimited).
Data file size check for MS2000 Checks the remaining space for all databases where the data files are set with limited growth rate (max size not unlimited).
Database growth rate aggregated Collects size of all database files (including transaction log files) to visualize the growth rate for all databases.
Database growth rate aggregated for MS2000 Collects size of all database files (including transaction log files) to visualize the growth rate for all databases.
Database growth rate detailed Collects size of database files (including transaction log files) to visualize the growth rate for the largest databases.
Database growth rate detailed for MS2000 Collects size of database files (including transaction log files) to visualize the growth rate for the largest databases.
Database disk capacity Checks free space on drives where data and transaction log files are defined. An alarm (or warning) is raised if the percentage limit is reached OR if the abosulte limit is reached. IF the xp_cmdshell Instance configuration option is enabled the alert can check disk and mounted volumes where data-files are not present.
Database disk space usage Checks free space on drives where all data and transaction log files are defined. Drives where no data files exist will be ignored.
Databases NOT IN USE collector Collects information about most inactive databases.
Disk space check Checks the amount of free space on the available disk drives.
Instance error log file size check Checks the size og the Instance error log file by using the extended stored procedure xp_cmdshell.
Filegroups growth rate This procedure collects space usage for the largest filegroups defined in each database. The undocumented ‘sp_MSforeachdb’ Stored Procedure is used to execute T-SQL statements against dbo.sysfiles table in every database defined on a SQL Server instance.
Filegroups growth rate for MS2000 This procedure collects space usage for the largest filegroups defined in each database. The undocumented ‘sp_MSforeachdb’ Stored Procedure is used to execute T-SQL statements against dbo.sysfiles table in every database defined on a SQL Server instance.
Data file size check noschema This procedure collects space usage in all filegroups defined in each database. The undocumented ‘sp_MSforeachdb’ Stored Procedure is used to execute T-SQL statements against dbo.sysfiles table in every database defined to a SQL Server instance.
Database disk capacity noschema This procedure collects space usage in all filegroups defined in each database. The undocumented ‘sp_MSforeachdb’ Stored Procedure is used to execute T-SQL statements against dbo.sysfiles table in every database defined to a SQL Server instance.
Disk space check noschema This procedure collects space usage in all filegroups defined in each database. The undocumented ‘sp_MSforeachdb’ Stored Procedure is used to execute T-SQL statements against dbo.sysfiles table in every database defined to a SQL Server instance.
Transaction log space usage noschema This procedure collects space usage in all filegroups defined in each database. The undocumented ‘sp_MSforeachdb’ Stored Procedure is used to execute T-SQL statements against dbo.sysfiles table in every database defined to a SQL Server instance.
Objects size collector all databases Collects table and index size information for the largest objects for all databases.
Temporary database space usage Checks space usage in tempdb database, and collects statistics including size of data and transaction log files.
Transaction log size check This procedure checks the size of the transaction log (log file(s) size), and compares it to the database size (data file(s) size). If the size of the transaction log file(s) in percentage is greater than the warning/alarm parameter value, the check returns a warning/alarm.
Transaction log size check This procedure checks the size of the transaction log (log file(s) size), and compares it to the database size (data file(s) size). If the size of the transaction log file(s) in percentage is greater than the warning/alarm parameter value, the check returns a warning/alarm.
Transaction log space usage This procedure checks information returned by DBCC SQLPERF which is used to monitor the amount of space used in the transaction log.
Transaction log space usage for MS2000, MS2005 and MS2008 This procedure checks information returned by DBCC SQLPERF which is used to monitor the amount of space used in the transaction log.
Truncate transaction log This procedure truncates the transaction log for the dbWatch database.
Version store space usage Checks total space in tempdb used by version store records for each database.
PostgreSQL
Log size statistics Checks the size of the log file.
Schema growth collector Checks the size of the log file.
Vaccum alert Checks the size of the log file.
Schema growth and information Collects detailed schema growth rate information.
Schema growth statistics Collects and analyzes schema growth statistics from data collected by
Tablespace growth and information Shows an overview of tablespace growth and statistics.
MySQL
Database growth rate Collects database size and visualizes the growth rate of the server.
Database growth rate Collects detailed growth rate information.
MariaDB
Database growth rate Collects database size and visualizes the growth rate of the server.
Database growth rate Collects detailed growth rate information.
Sybase
Database space check Checks the amount of free space in all databases.
Database space check Checks the amount of free space in all databases.
Database growth rate Collects database growth rates statistics.
Transaction log space check Checks the amount of free space in all transaction logs.

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment