MaiChMon: Database Maintenance ,Change Management and Monitoring Scheduler.
Monitor Database Activities , Database Resources, Database Growth, Schema Changes, Latency, Unix Jobs, Windows Jobs and Automate Database Maintenance jobs like Update Statistics, Index Rebuild, DBCC etc.
supports: Oracle Server , SAP Sybase ASE, SAP Sybase Replication Server and Microsoft SQL Server.
Features:
Choice of repository database (Oracle, SAP Sybase, MS-SQL Server).
Define separate groups and server environment like PROD,QA etc .
Password is stored in encrypted format (Secured).
Define only one job and run across multiple servers.
Define holiday calendar for multiple countries .
Monitor network activities.
Monitor CPU resources.
Generate DDLs for schema objects.
Get to know server/database/user level changes are made.
like Password Changes, Database Size Changes, Configuration Changes etc.
Automate database backup and restore.
Automate export/import.
Automate maintenance activities like index rebuild / update statistics etc.
Automate file clean_up.
Monitor server health.
Monitor cron job changes.
| Sybase ASE Monitoring |
| AUDITING – Monitor what queries are running. BLOCKED_PROCESSES – Monitor Blocked Processes. BCP – Bulk Copy table data In and Out. CONFIG_CHANGES – Audit Server Configuration Changes. CACHE_HIT_RATIO – Monitor Cache Hit Ratio CHECK_SERVER_UP – Verify Server availability. CHECK_ERROR_LOG – Check Error Log for messages. CONFIGURATION – Generate DDLs for modified configuration parameters only. CREATE_DATABASE – Generate DDLs for create database . CONNECTIONS_USED – Monitor max number of connections used. DATABASE_GROWTH – Monitor database growth in terms of size and percentage (%). DATABASE_OWNERS – Generate DDLs for database owners. DBOPTION_CHANGES – Monitor database option changes. DBOPTIONS – Generate DDLs for database options . DISKINIT – Generate DDLs for database device creation. DUMP_DATABASE – Automate database backup . DUMP_TRAN – Automate database transaction log backup DUMP_N_LOAD – Backup and Restore database and log . DBCC – Automate Database Consistency Checker (DBCC) checks. DBSPACE_FULL – Monitor current database space usage. DATABASESIZE_CHANGES – Audit database size changes. FRAGMENTATION – Monitor Table/Index fragmentation. INDEX_CHANGES – Monitor changes made to index (es). INDEX_REBUILD – Automate index rebuild. LOAD_DATABASE – Automate database restore . LOAD_TRAN – Automate database transaction log restore. LOGSPACE_FULL – Monitor current transaction log space usage. LONG_RUNNING_TRANS – Monitor long running processes . PASSWORD_CHANGES – Track changed passwords. SQL_SCRIPT – Execute SQL script . SERVER_UPTIME – Monitor how long the server is up. SHUTDOWN_SERVER – Automate server shutdown. TOP10_TABLE_GROWTH – Monitor top 10 table growths in terms of size and rows. TABLE_CHANGES – Monitor changes made to table structure. UPDATE_STATISTICS – Automate update statistics. USER_IO – Monitor user level I/O and CPU I/O activities. |
| Sybase Rep Monitoring |
| CONFIG_CHANGES – Audit server configuration changes. CHECK_SERVER_UP – Verify server availability. CHECK_ERROR_LOG – Check Error Log for rrrors and warning messages. CONFIGURATION – Generate DDLs for modified configuration parameters only. LATENCY – Check replication latency. WHO_IS_DOWN – Monitor down threads. PARTITION_SPACE – Monitor partition space. SQL_SCRIPT – Execute SQL script . SERVER_UPTIME – Monitor how long the server is up. SHUTDOWN_SERVER – Automate Server Shutdown. |
| Oracle Monitoring |
| AUDITING – Monitor what queries are running. BLOCKED_PROCESSES – Monitor Blocked Processes. CONFIG_CHANGES – Audit server configuration changes. CACHE_HIT_RATIO – Monitor Cache Hit Ratio CHECK_SERVER_UP – Verify server availability. CHECK_ALERT_LOG – Check Error Log for errors and warning messages. CONFIGURATION – Generate DDLs for modified configuration parameters only. CREATE_TABLESPACE – Generate DDLs for create table space . CONNECTIONS_USED – Monitor maximum number of connections used. EXPORT – Automate table level exports with option to suffix timestamp. IMPORT – Automate table level exports with option to suffix timestamp. FILELIST – Keep track of table space files. INDEX_CHANGES – Monitor changes made to index (es). INDEX_REBUILD – Automate index rebuild. LONG_RUNNING_TRANS – Monitor long running queries . PASSWORD_CHANGES – Track changed passwords. SCHEMA – Generate DDLs for schema creation. SQL_SCRIPT – Execute SQL script . SERVER_UPTIME – Monitor how long the server is up. SHUTDOWN_SERVER – Automate server shutdown. TOP10_TABLE_GROWTH – Monitor top 10 table growth in terms of size and rows. TABLE_CHANGES – Monitor changes made to the table structure. TABLESPACE_GROWTH – Monitor table space growth in terms of size and percentage (%). TABLESPACE_FULL – Monitor current table space space usage. TBLSPCSIZE_CHANGES – Audit table space size changes. UPDATE_STATISTICS – Automate Update Statistics. |
| MSSql Monitoring |
| AUDITING – Monitor what queries are running. BLOCKED_PROCESSES – Monitor Blocked Processes. BCP – Bulk copy table data in and out. BACKUP_DATABASE – Automate database backup with option to suffix timestamp. BACKUP_TRAN – Automate database transaction log backup with option to suffix timestamp. CONFIG_CHANGES – Audit server configuration changes. CACHE_HIT_RATIO – Monitor Cache Hit Ratio CHECK_SERVER_UP – Verify server availability. CHECK_ERROR_LOG – Check Error Log for errors and warning messages. CONFIGURATION – Generate DDLs for modified configuration parameters only. CREATE_DATABASE – Generate DDLs for create database . CONNECTIONS_USED – Monitor maximum number of connections used. DATABASE_GROWTH – Monitor database growth in terms of size and percentage (%). DATABASE_OWNERS – Generate DDLs for database owners. DBOPTION_CHANGES – Monitor database option changes. DBOPTIONS – Generate DDLs for database options . DISKINIT – Generate DDLs for database device creation. DUMP_N_LOAD – Backup and Restore database and log with option to suffix timestamp. DBCC – Automate Database Consistency Checker (DBCC) checks. DBSPACE_FULL – Monitor current database space usage. DATABASESIZE_CHANGES – Audit database size changes. INDEX_CHANGES – Monitor changes made to the index (es). INDEX_REBUILD – Automate Index Rebuild. LOGSPACE_FULL – Monitor current transaction log space usage. LONG_RUNNING_TRANS – Monitor long running transactions . PASSWORD_CHANGES -Track changed passwords. RESTORE_DATABASE – Automate database restore . RESTORE_TRAN – Automate database transaction log restore. SQL_SCRIPT – Execute SQL script . SERVER_UPTIME – Monitor how long the server is up. SHUTDOWN_SERVER – Automate server shutdown. TOP10_TABLE_GROWTH – Monitor top 10 table Growth in terms of size and rows. TABLE_CHANGES – Monitor changes made to the table structure. UPDATE_STATISTICS – Automate Update Statistics. |
| Unix Monitoring |
| CHECK_HOST_UP -Verify host availability. FILE_SYSTEM_FULL – Monitor file system space usage. UNIX_SCRIPT – Execute unix shell scripts. CRONJOB_CHANGES – Monitor changes made to cron jobs. BACKUP_CRONTAB – Backup cron jobs file. RESTORE_CRONTAB – Restore cron jobs file. CLEAN_UP – Perform file cleanup . IOSTAT – Monitor I/O activities. NETSTAT – Monitor network activities. VMSTAT – Monitor memory activities. |
| Windows Monitoring |
| CHECK_HOST_UP – Verify host availability. FILE_SYSTEM_FULL – Monitor file system space usage. EXTERNAL_EXE – Execute executables. CLEAN_UP – Perform file cleanup . |