Database healthcheck and environment review

Why is a database health check important?

What do you get with the Database Health check?

Get in touch with our friendly consultants
Please enable JavaScript in your browser to complete this form.

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

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
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.

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.