Database Health Check

Home Database Health Check
Why database health check is important?

Identify configuration issue

Ability to meet recovery objectives

Identify performance bottlenecks

Access disaster recovery and high availability requirements

Reduce the risks of vulnerabilities and downtime

Actionable recommendations to improve and fix issues

What do you get with the Database Health check?

A comprehensive report with analysis of more than 50 check points of your database environment for availability, performance, stability, robustness and security aspects.

Our findings and recommendations

Action plan to fix identified issues

FREE consultation to plan remediation

Get in touch with our friendly consultants
REQUEST A CALL BACK
What is included in SQL Server Database Health Check?

DATABASE SETTINGS

  • Database options
  • Data file configurations
  • Encryption settings
  • Fragmented index
  • Outdated statistics
  • Log file settings

PERFORMANCE REVIEW

  • Wait event analysis
  • Missing indexes
  • Analyse indexes
  • Blocking and deadlocks
  • Identify slow running queries
  • I/O, CPU and memory bottlenecks

BACKUP AND RECOVERY

  • Backup jobs and configuration
  • Missing backups
  • Log backup settings
  • RTO and RPO review

INSTANCE CONFIGURATION

  • Memory options
  • Workload settings
  • Tempdb files
  • Data file location and configuration
  • Configured trace flags
  • Performance options
  • Compatibility settings
  • User rights assignment
  • Recovery models
  • Email settings
  • Alerts and notifications

SECURITY CONFIGURATION

  • Privileged users
  • SA user settings
  • Auditing
  • TDE and backup settings
  • Investigate unauthorized access

HOST CONFIGURATION

  • Disk layout and allocation
  • Memory and CPU
  • Swap setting
  • Performance options
  • Security policy settings
  • User rights assignment
  • Cluster settings

ANALYSE LOGS

  • Windows event log
  • SQL Server logs
  • SQL Server agent log
  • Cluster logs

HIGH AVAILABILITY AND DR

  • Database mirroring
  • AlwaysOn settings
  • Cluster settings
  • Log Shipping settings
  • Replication configuration
What is included in Oracle Database Health Check?

HOST CONFIGURATION

  • Kernel parameters
  • Memory and CPU
  • Disk layout and file system
  • Disk space
  • Network configuration

BACKUP AND RECOVERY

  • Review backup strategy
  • Evaluate RTO and RPO
  • RMAN settings
  • Retention and recoverability

PERFORMANCE TUNING

  • Analyse AWR reports
  • Analyse ADDM, ASH reports
  • Analyse OSWatcher
  • Investigate disk/CPU intensive queries
  • Identify options for SQL tuning
  • Analyse database advisor reports

INSTANCE CONFIGURATION

  • Review database parameters
  • Memory settings
  • Redo and archivelog configuration

PATCH AND VERSION REVIEW

  • Check applied patches
  • Compare with life cycle support options
  • Review patching strategy
  • Identify missing patches
  • Review upgrade strategy

SECURITY

  • Privileged users and permissions
  • TDE and backup encryption
  • Analyse transport layer security

LICENSE REVIEW

  • Review existing license
  • Discuss options to reduce TCO

SCHEMA AND DATABASE

  • Analyse indexes and tables
  • Tablespace setting, free space and growth
  • Invalid objects
  • Fragmentations

HIGH AVAILABILITY AND DR

  • Review high availability and DR strategy
  • Review RAC configuration
  • Review data guard settings

ANALYSE LOG FILES

  • Check alert log
  • Check listener log
  • Check cluster logs
  • Check OS level logs

REVIEW ADVISORS

  • PGA Target Advice
  • TDE and backup encryption
  • DB Cache Target Advice
  • Shared Pool Target Advice
  • Memory/SGA Target Advice
  • Segment advice
Tailor-made database support solution for your specific business needs

We understand that each business is unique, and you may have different requirements. We’ll discuss your needs and provide a tailor-made solution for your specific business environment.

Request a Callback
Supported Database Platforms
Partner Accreditation

reliable database services

Onsys Technologies

We deliver breakthrough and enduring results, creating bold, innovative solutions that work.
We monitor, manage, and Improve your database infrastructure