Absolute Performance Inc.

Error
  • Entry #0 Not Found
  • Entry #0 Not Found
Home

Database Management

Absolute Performance provides managed services – from Database Monitoring to Database Management – for a variety of leading databases, including:
  • Oracle
  • Microsoft SQL Server
  • DB2
  • Sybase
  • Informix
  • MySQL
  • PostgreSQL
  • Progress

And, because System Shepherd® was designed with flexibility in mind, we can rapidly adapt our templates to collect data from virtually any database you may have in your IT environment.

For managed customer environments, we provide a full range of standard Database Management Services, including:

  • 24x7x365 response to alerts generated by the System Shepherd platform
  • IT best practices - incident, problem, and change management
  • Troubleshooting and resolution of performance issues
  • Proactive performance analysis and tuning
  • Comprehensive database administration
    • Space administration
    • Object defragmentation
    • Logfile administration
    • Basic memory tuning
    • Checkpoint tuning
    • Disk I/O tuning
  • Testing and application of relevant patches and updates
  • Execution of tested changes to production environment (including schema modifications, application code updates, etc.)
  • Monthly performance analysis report

The following table highlights some of the key data points we collect from Oracle databases:

Tablespace Statistics
  • Tablespace Size
  • Percent Space Available
  • Available Extends
  • Largest Extent Size
  • Free Extents
Datafile Statistics
  • File Status
  • I/O Weight
  • Total I/O
  • Reads per Second
  • Writes per Second
Memory Utilization Statistics
  • Buffer Cache Hit Ratio Trend
  • Dictionary Cache Hit Ratio Trend
  • Library Cache Hit Ratio Trend
  • Total Oracle Resident Segment Size
  • Disk vs. Memory Sort Ratio
  • Shared Pool Free Memory
  • Java Pool Free Memory
Database System Statistics
  • Current connections
  • Redo Buffer Allocation Retries
  • Total Physical Reads
  • Total Physical Writes
  • Transaction Rollbacks
  • User Rollbacks
  • DBWR Checkpoints
  • Background Checkpoints
Latch Statistics
  • Redo Allocation Latch
  • Library Cache Latch
  • Shared Pool Latch
  • Redo Copy Latch
Undo Statistics
  • No Space Errors
  • Snapshot Errors
  • Expired Undo Block Steal Attempts
  • Expired Undo Block Steals
  • Max Concurrency
  • Max Query Length
  • Transaction Count
  • Undo Blocks
  • Unexpired Blocks Removed
  • Unexpired Blocks Reused
  • Unexpired Extents Stolen
Miscellaneous Statistics
  • Redo Log Switches
  • Rollback Segment Status
  • Critical processes availability
  • Database memory utilization
  • Database CPU utilization
  • Log file error monitoring
  • Archive Log Processing
  • Deadlock Detection and Notification
Object Fragmentation Statistics 

Database Monitoring
Regardless of whether you are using System Shepherd® to provide your team with the visibility they need to manage your IT infrastructure in-house or relying on Absolute Performance experts to manage it for you, System Shepherd collects hundreds of performance and availability metrics from each monitored database.