Topic outline

• Monitoring Databases

  Monitoring Databases

  Note:

  This resource guide points to InterSystems Caché® documentation. While the names of some utilities may have changed in InterSystems IRIS® data platform, the utilities' functions have not changed.

  This guide offers resources on database monitoring for InterSystems Caché®, InterSystems Ensemble®, and InterSystems Healthshare®. Check the status of your database system regularly, and automate some activities such as monitoring and alerting if possible. Questions to ask when monitoring include:
  

  • Are there any errors being reported?
  • Does the system have adequate disk space? Should you plan to acquire more?
  • Does the system have adequate memory? Should you plan to acquire more?
  • Does the database have integrity issues?
  • Is the system functioning normally?

  Note: If you are managing HealthShare databases, please review the entire HealthShare Monitoring resource guide to be certain that you have addressed monitoring requirements at the operating system, web server, database, integration, and application levels.
• Collapse allExpand all
  Key Resources

  Key Resources

  The following resources describe most of the tools and topics mentioned in this guide. Exceptions or additions are noted within each section throughout this guide.

  • URLDocumentation: Caché Monitoring Guide
  • URLClassroom course: Managing InterSystems Servers
• System Dashboard

  System Dashboard

  The System Dashboard displays key performance indicators, including system performance, shadowing, system up time, system usage, errors and alerts, licensing, and task manager tasks. Access the System Dashboard by selecting System Operation > System Dashboard.

  
  

  • URLDocumentation: Monitoring System Dashboard Indicators
• Caché System Monitor

  Caché System Monitor

  Caché System Monitor is a user-extensible utility for monitoring an instance. It has three parts: Caché System Monitor, Caché Health Monitor, and Caché Application Monitor.
  

  • URLDocumentation: Using Caché System Monitor
  • URLPresentation: Application Performance Management (45m)
• Logs

  Logs

  There are multiple logs at the database level that should be inspected for errors:

  • Console log
  • SYSLOG
  • Application Error Log
  • xDBC log

  • URLDocumentation: Monitoring Caché Logs
• Caché Monitor

  Caché Monitor

  Caché Monitor scans the console log for each instance, and generates notifications that can either be written to an alert log or emailed. It is configured using the ^MONMGR utility.
  

  • URLDocumentation: Using Caché Monitor
• Caché Audit Log

  Caché Audit Log

  There is a database-level audit log which enables tracking of system events at both the system and application level. System-level events include startup, shutdown, logins, and changes to security settings.
  

  • URLDocumentation: Audit Log
• Database Freespace

  Database Freespace

  The monitoring of disk space on InterSystems systems is a critical function. The Database Freespace page on the Management Portal and the ^%FREECNT utility will help.
  

  • URLDocumentation: Displaying Free Space Information
  • URLPresentation: Monitoring Message Volume and Disk Space In Ensemble and HealthShare (1h)
• Database Integrity

  Database Integrity

  Database integrity is maintained by the system, but failure of a storage device may result in a compromised data structure.
  

  • URLDocumentation: Verifying Structural Integrity
• Performance Utilities

  Performance Utilities

  Performance utilities include the Diagnostic Report and Performance Analysis utility. They provide information on system configuration and performance. They are frequently used to troubleshoot a system with the InterSystems Worldwide Response Center.
  

  • Diagnostic Report (Buttons)

    The Diagnostic Report gathers information about how the system is configured and provides a snapshot of what is happening at a given instance in time. 
    

  • URLDocumentation: Using the Caché Diagnostic Report
  • Performance Analysis (pButtons)

    Performance Analysis is the performance version of the Diagnostic Report. It is run for a predetermined period of time, preferably 24 hours, and it records information at pre-determined intervals about what the system is doing so you can see how the system is behaving. If you discover performance problems during the Performance Analysis, contact the InterSystems Worldwide Response Center for help.
    

  • URLDocumentation: Monitoring Performance using ^pButtons
  • URLClassroom course: Managing InterSystems Servers
• License Status

  License Status

  The system's license status can be checked in several places:

  • License usage is shown in the System Monitor. 
  • License keys and license servers can be viewed and managed by selecting Management Portal > System Administration > Licensing.

  • URLDocumentation: Managing Caché Licensing
• Journal Space

  Journal Space

  Journal space status can be checked using the ^Journal utility routine.
  

  • URLDocumentation: Display Journal Status Using Status^JOURNAL
• Share Your Feedback!

  Share Your Feedback!