Database healthcheck and environment review

contact us

Why database health check is essential?

    • 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 checkpoints 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
=

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

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

HOST CONFIGURATION

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

PERFORMANCE REVIEW

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

SECURITY CONFIGURATION

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

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

INSTANCE CONFIGURATION

  • Review database parameters
  • Memory settings
  • Redo and archive log configuration

SCHEMA AND DATABASE

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

BACKUP AND RECOVERY

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

PATCH AND VERSION REVIEW

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

HIGH AVAILABILITY AND DR

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

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

SECURITY

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

ANALYSE LOG FILES

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

LICENSE REVIEW

  • Review existing license
  • Discuss options to reduce TCO

REVIEW ADVISORS

  • PGA Target Advice
  • TDE and backup encryption
  • DB Cache Target Advice
  • Shared Pool Target Advice
  • Memory/SGA Target Advice
  • Segment advice

SQL Server Health check

$ 1400 per host
  • Performs remotely over VPN or MS Teams
  • Comprehensive report
  • Recommendations
  • Action plan
  • 2 Professional hours to discuss the recommendations and plan remediation
Book Now

Oracle Database Health check

$ 1800 per database
  • Performs remotely over VPN or MS Teams
  • Comprehensive report
  • Recommendations
  • Action plan
  • 2 Professional hours to discuss the recommendations and plan remediation
Book Now
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 Call back

Supported Database Platforms

Partner Accreditation

reliable database services

Onsys Technologies

The most flexible, innovative and customer-centric technology service provider with the utmost affordability

Our Database Specialists have many years of Industry experience improving performance in EDB, SQL Server and Oracle Database environments in various industries.