Skip to main content

Implement well-architected database configurations in workload factory

Contributors netapp-rlithman

Using configuration analysis insights and recommendations, leverage workload factory to implement best practices for your database configurations with Microsoft SQL Server and Oracle. You can easily review the well-architected status, learn about issues with database configurations, and take action to improve any configurations that aren't optimized for reliability, security, efficiency, performance, and cost.

You can also dismiss the analysis of specific configurations that don't apply to your environment to avoid unnecessary alerts and inaccurate optimization results.

About this task

Workload factory analyzes database configurations daily. The daily analysis provides the well-architected status, and insights and recommendations with options to automatically fix configuration issues so that your configurations meet best practices.

You have options to review the recommendations for configuration issues and fix those issues from the Databases inventory within the workload factory console.

What is analyzed

Workload factory analyzes the well-architected status of the following configurations:

For Microsoft SQL Server instances:

  • Storage sizing: includes storage tier, file system headroom, log drive size, and TempDB drive size

  • Storage layout: includes user data files placement, log files placement, and TempDB placement

  • Storage configuration: includes capacity management, thin provisioning, tiering policy, snapshots, Microsoft Multipath I/O (MPIO) status, and MPIO timeout setting

  • Compute: includes rightsizing, operating system patches, and network adapter settings like Receive Side Scaling (RSS), TCP offloading, and MTU alignment

  • Applications: includes Microsoft SQL Server licenses, Microsoft SQL Server patch, and MAXDOP settings

  • Resiliency: includes local snapshots, FSx for ONTAP backups, cross-region replication (CRR), and Microsoft SQL High Availability.

  • Clones: includes options to refresh and delete clones (sandboxes) that were created in or outside of workload factory and are older than 60 days

For Oracle databases:

  • Storage configuration: includes capacity management, thin provisioning, tiering policy, snapshots, and storage efficiencies

Before you begin

  • You must have AWS account credentials and read/write permissions to analyze your database configurations.

  • To assess the storage of a Microsoft SQL Server instance or Oracle database, the resource must be registered in workload factory and the storage type must be FSx for ONTAP. Learn how to register resources.

  • Make sure you review each recommendation carefully before selecting to fix a setting or configuration. For RSS and MAXDOP settings, we suggest that you test the recommended settings to determine performance improvements before making changes to your production environment.

Note The remediation process may cause instance downtimes or service interruptions. Make sure you review the recommendation carefully before you choose to fix a configuration.

Fix a configuration issue

Fix configuration issues for SQL Server or Oracle environments running on FSx for ONTAP storage.

Note The remediation process may cause instance downtimes or service interruptions. Make sure you review the recommendation carefully before you choose to fix a configuration issue.
Steps
  1. Log in using one of the console experiences.

  2. In the Databases tile, select Go to Databases inventory.

  3. In the Inventory tab, select the Instances tab.

  4. Select Fix issues to view configuration issues for the instance.

  5. On the Well-architected status page for the instance, review the findings from the analysis.

    You can filter configuration issues by categories, subcategories, status, severity, and tags.

    You can also download a report of the findings by selecting Export PDF.

  6. Select the dropdown arrow to view the recommendation for any configuration. Recommendations include best practices, potential pitfalls of unoptimized configurations, and important considerations. Make sure you review the recommendation carefully.

  7. Select to View and fix configuration issues when the option is available.

    Select all is the default, but you can select specific resources to fix.

    1. For all configurations except clone cleanup, review the recommendation details to learn what will happen if you choose to fix the issue. Some remediation operations may cause instance downtimes or service interruptions.

    2. For clone cleanup, select cloned databases (sandboxes) to refresh or delete.

      • Refreshing a clone synchronizes it with its source database. Refresh is available only for clones created in workload factory.

      • Deleting a clone removes it permanently, frees up storage space, and reduces costs. You can delete clones created in and outside of workload factory.

  8. Select Continue to fix the configuration issue.

Result

Workload factory begins fixing the issue(s). Select the Job monitoring tab to view the status of the operation.

Postpone or dismiss the analysis of database configurations

Postpone or dismiss the analysis of specific database configurations that don't apply to your database environment to avoid unnecessary alerts and inaccurate optimization results. You can reactivate a postponed or dismissed configuration analysis at any time.

The application requirements for database configurations vary. Workload factory gives you two options for skipping the analysis of specific database configurations so that you can monitor only relevant issues and get an accurate view of the health of relevant configurations. When a specific configuration analysis is postponed or dismissed, the configuration isn't included in the total optimization score.

You can postpone, dismiss, and reactivate the configuration analysis at the configuration level and at the SQL Server instance or at the Oracle database level.

  • Postpone for 30 days: Postponing the analysis will stop the analysis for 30 days. After 30 days, the analysis will restart automatically.

  • Dismiss: Dismissing the analysis postpones the analysis indefinitely. You can restart the analysis if needed.

The following instructions describe how to postpone, dismiss, or reactivate an analysis at the configuration level. To complete the following tasks for specific SQL Server instances or Oracle databases, start in the Dashboard tab.

Postpone

Postpone to stop a configuration analysis for 30 days. After 30 days, the analysis will restart automatically.

Steps
  1. Log in using one of the console experiences.

  2. In the Databases tile, select Go to Databases inventory.

  3. In the Inventory tab, scroll down to the configuration to postpone, select the three-dot menu, and then select Postpone for 30 days.

  4. Select Continue.

Result

The configuration analysis stops for 30 days.

Dismiss

Dismiss to stop a configuration analysis indefinitely. You can restart the analysis when needed.

Steps
  1. Log in using one of the console experiences.

  2. In the Databases tile, select Go to Databases inventory.

  3. In the Inventory tab, scroll down to the configuration to dismiss, select the three-dot menu, and then select Dismiss.

  4. Select Continue.

Result

The configuration analysis stops.

Reactivate

Reactivate a postponed or dismissed configuration analysis at any time.

Steps
  1. Log in using one of the console experiences.

  2. In the Databases tile, select Go to Databases inventory.

  3. In the Inventory tab, scroll down to the configuration to reactivate, select the three-dot menu, and then select Reactivate.

  4. Select Continue.

Result

The configuration analysis is reactivated and occurs daily moving forward.