header image

Monitoring Package

Our full monitoring package is included at no additional charge with our fixed price package.

Monitoring

Our full system monitoring allows us to respond to issues, often before they become problems.

Every 15 minutes
  • Server
    • Server UpDown: Checks server status
    • Listener UpDown: Checks database listener
    • CPU Utilization: Percentage of CPU utilization
    • File System Space: Check for adequate free space on all file systems
    • Wait Queue: Number of processes in the OS wait queue
    • Run Queue: Number of processes in the OS run queue
    • Free Memory: Amount of free RAM available to the OS
    • Swap Utilization: Amount of swap activity for the OS
    • Network Errors: Number of network errors that have occured
    • Network Collisions: Number of network collisions that have occured
  • Database
    • Database UpDown: Verify database is online and accepting connections
    • Alert Log Check: Check for new errors in the Database Log
    • Blocking Locks: Number of sessions waiting on database locks
    • Session Limit: Count active sessions and calculate percentage of max
    • Process Limit: Count active processes and calculate percentage of max
    • SGA Memory Allocation: Amount of SGA memory allocated
    • PGA Memory Allocation: Amount of PGA memory allocated
    • UGA Memory Allocation: Amount of UGA memory allocated
Every Hour
  • Server
    • Server Uptime: Amount of time since last reboot
    • Listener Uptime: Amount of time since last listner restart
  • Database
    • Lock Limit: Count active locks and calcualte percentage of max
    • DBA Jobs: Status of scheduled jobs within the database
    • In Doubt Transactions: Check for problems with Distributed Transactions
    • Replication Errors: Check for Replication errors
    • Refresh Status: Check for replication/streams data propogation status
Every Day
  • Server
    • Clean up old files: Log files, archived redo logs, network logs, etc...
    • Rotate Network Logs: Archive the current file with a date stamp
  • Database
    • Invalid Objects: List and try to compile all invalid objects
    • Rotate Database Logs: Archive the current file with a date stamp
    • Auto Extend: Verify database files can grow as needed
    • Max Extents: Verify database objects (tables and indexes) can grow
    • Chained Rows: Tables and indexes with performance problems
    • Percent Increase: Verify tables and indexes grow with minimal fragmentation
    • Extent Count: Check for objects with too many extents
    • Default Tablespace: Verify accounts have appropriate default tablespace
    • Percent Sorts to Disk: Sorting to disk is 1 Million+ times slower
    • Datafile checks: Record relevant information (size, maxsize, location, etc...)
    • Top 10 SQL statements for tuning
      • Top 10 by Executions: Most frequently executed queries
      • Top 10 by Disk Reads: Worst performing queries
      • Top 10 by Memory Reads: buffer cache abusing queries
    • Backup Critical files
      • Control File: Essential for startup and recovery
      • Initialization File: Database parameter file
      • SPFile: Binary version of the Initialization file
      • Password File: Password file for privileged accounts
      • Network Files: Including TNSnames, SQLnet and Listener