GEM FEATURE LIST

Architecture

• Simple & Elegant
• Central Monitoring Station (1 for unix, 1 for win32)
• Open Source Perl / Open Api Libraries
• Composed of many small, self documenting, easy to read programs

Monitoring

• Error/Event Logs
  1. Sybase ASE
  2. Oracle
  3. Windows
  4. Microsoft SQL Server
  5. Windows Scheduler
  6. Microsoft SQL Server Job Scheduler
  7. Sybase Replication Server
  8. Sybase IQ
  9. Sybase Replication
  10. Unix Messages
  11. Cisco Routers
• Availability
  1. Windows Services
  2. Port Monitoring (ie. host/portnum pairs)
  3. System Availability
• Space
  1. Disk Space
  2. Database Space
  3. Space History
• Internals Monitoring
  1. Blocks
  2. Process State
  3. Circular Deadlocks
  4. Users and Load
  5. Invalid Users
  6. Invalid Objects
  7. System Table Errors
  8. 30+ Rules Checked

Auditing

• Keeps track of configuration changes
• Significant Error Reporting
• Rules based facilities kept up to date
• Unix .rhost / .ssh Reporting
• Database Security Audit
• Object Change Auditing
• User Access Auditing

Alarming

• Configurable Operator Scheduler
• Blackout Periods
• Flexible Alarm Filtering
• Viewable on web or using graphical utility

Backups

• Maintenance Plan Based
• Full And Transaction Logs
• DBCC
• Update Statistics
• Critical Data Extracts
• Saves All Critical Data Needed To Rebuild Server
• Integrated Alarming
• Good Log Shipping Solution
• Reports both Success & Failure
• Cross Checks For Success
• Integrated Reorgs
• Extensive Backup Success Checking

Utilities

• 80+ New Stored Procedures!
• Disk Space Cleanup
• Database Comparison
  1. data comparison
  2. schema comparison
  3. schema generation
• Log Shrink (Microsoft Sql Server)
• Process Monitor
  1. Drill Down Server Monitor
  2. Sybase MDA Table support
• Hundreds of small easy to use Perl Utility Programs

GEM Introduction Presentation

Complete GEM Documentation