Optimize Database Performance and Hardware Usage with AHF 24.11

November 28, 2024 | 5 minute read
Gareth Chapman
Senior Principal Development Operations Manager
Text Size 100%:

Oracle Autonomous Health Framework (AHF) helps maximize application resilience, performance, and security using cutting-edge AI to prevent and resolve issues.

It's the same technology Oracle uses in the cloud to keep the Autonomous Database running, and it's available for you at no extra cost as part of your existing software support agreement.

Autonomous Health Framework 24.11 is released and available to download

 

New Features in 24.11

 

Optimize Database Performance and Hardware Usage

The number of databases included within AHF Balance performance tuning recommendations can now be limited. This makes it easier to make gradual configuration changes to improve performance.

AHF Balance uses AI to provide Database CPU_COUNT tuning recommendations. DBAs, Cluster Admins and Fleet Admins can use AHF Balance to improve database performance while making greatest usage of available hardware resources.

Recommendations are made for a cluster. In previous releases, all the databases running in the cluster were considered candidates for CPU_COUNT adjustment. Often, Balance would recommend changing the CPU_COUNT for 50 or more databases.

Implementing these configuration changes to so many databases at the same time can be difficult from a change control point of view. Now AHF Balance makes it easier to improve database performance incrementally.

Using the new option --limit-db-changes puts a cap on the number of databases for which CPU_COUNT changes may be recommended. This allows successive iterations of tuning, changing a manageable number of databases each time.

For example:

AHF Balance CPU_COUNT recommendation

To get fleet performance tuning recommendations use:

Copied to Clipboard
Error: Could not Copy
Copied to Clipboard
Error: Could not Copy
ahf analysis create --type impact --scope fleet --name FLEET_NAME --limit-db-changes NUM_DBS

Fleet report will limit the number of database changes recommendations across each cluster.

To get cluster performance tuning recommendations use:

Copied to Clipboard
Error: Could not Copy
Copied to Clipboard
Error: Could not Copy
ahf analysis create --type impact --scope cluster --name FLEET_NAME --limit-db-changes NUM_DBS

See the AHF user guide for more information on AHF Balance or read more about using AHF for database performance tuning.

 

 

Latest Third/Fourth-Party Libraries

AHF has upgraded the versions of third/fourth-party software libraries.

AHF 24.11 has upgraded the following libraries to these versions:

  • nbconvert 7.16.4
  • AIOHTTP 3.11.7
  • Tornado 6.4.2

See the user guide for more information on third party usage.

 

Recent AHF Features

Here are recent AHF releases and features:

AHF 24.10

AHF Fleet Insights 24.2

AHF Fleet Insights helps Database Fleet Admins to maximize application resilience, performance, and security through issue prevention and resolution.

  • Best practice compliance checking – Keep track of configuration fleet-wide, identify where you are out of compliance with best practice and the most critical issues you should be addressing today, along with exactly what you need to do to prevent them.
  • Pin-point problem root causes – Oversee Database diagnostics across the fleet, if an issue does occur, identify the root cause and resolve it as soon as possible.
  • Explore configuration at scale – Easily see where you have differences in configuration and understand how to bring environments back in-line with each other.
  • Analyze historical issue trends – Go beyond just monitoring current performance. Analyze historical trends and identify areas for improvement and optimization. Plan for future capacity needs and keep costs under control.

ahf fleet insights setup

AHF 24.9

AHF 24.8

AHF 24.7

AHF 24.6

AHF 24.5

AHF 24.4

AHF 24.3

AHF 24.2

AHF 24.1

AHF 23.11

 

Get started with Autonomous Health Framework today

To get started today download Oracle Autonomous Health Framework.

Gareth Chapman

Senior Principal Development Operations Manager

Gareth is Senior Principal Development Operations Manager for Oracle Autonomous Health Framework.


Previous Post

Oracle Transaction Manager for Microservices (MicroTx) on Azure, AWS, and GCP

Todd Little | 3 min read

Next Post


Getting Started with Exadata Database Service on Oracle Database@AWS

Tammy Bednar | 6 min read