Skip to main content

Learn about Workload Factory for Databases

Contributors netapp-rlithman

Workload Factory for Databases is an end-to-end database deployment and maintenance service with built-in best practices for optimization, automatic thin cloning, and monitoring and resolution capabilities.

What is Workload Factory for Databases?

Workload Factory for Databases detects, assesses, plans, provisions, and moves Microsoft SQL Server data to Amazon FSx for NetApp ONTAP (FSx for ONTAP) deployments optimized to meet your performance and cost expectations while adhering to industry best practices. Throughout the life cycle, Workload Factory delivers continuous optimization and management for databases on FSx for ONTAP.

For more information about Workload Factory, refer to the Workload Factory overview.

Workload Factory benefits for self-managed databases

Workload Factory offers the following beneficial best practices and automation for self-managed databases.

Best practices

  • Integrated knowledge from AWS Cloud, Microsoft Windows and SQL servers, and NetApp ONTAP for SQL server deployments on EC2 instances.

  • Total cost of ownership optimized deployment.

  • End-to-end deployment automation that follows AWS, Microsoft and ONTAP best practices.

  • “Quick create” deployment mode helps you avoid potential pitfalls with manual configuration.

Automation with Workload Factory Codebox

Workload Factory introduces built-in automation with the Codebox. The Codebox offers the following automation benefits:

  • Code snippet generation: Infrastructure-as-Code (IaC) snippets are generated during resource creation, allowing seamless integration with existing orchestration workflows.

  • Infrastructure-as-code co-pilot: the Codebox is an Infrastructure-as-code (IaC) co-pilot that helps developers and DevOps generate code to execute any operation supported by Workload Factory.

  • Code viewer and automation catalog: the Codebox provides a code viewer for quick analysis of automation and an automation catalog for quick future re-use.

Workload Factory for Databases features

Workload Factory for Databases offers the following features:

  • Simple, fast deployments: simplify and streamline your provisioning experience by selecting answers to specification questions and eliminating the time typically required to investigate how to provision and configure your Microsoft SQL Server on AWS.

  • Automated orchestration: available via the Workload Factory user interface with Quick and Advanced create deployment modes, Workload Factory's Chatbot, and API with AWS CloudFormation.

  • Built-in features: utilize NetApp, Microsoft, and Amazon best practices and AWS resource selections built in to deployment configuration.

  • Cost estimation: assess potential cost savings with Workload Factory's storage calculator that estimates and details storage, compute, SQL licensing, snapshot, and clone itemized costs for existing Microsoft SQL Server deployments with Elastic Block Store compared with FSx for ONTAP.

  • Reusable automation templates: create, re-use, and customize CloudFormation templates from the Workload Factory Codebox for future Microsoft SQL Server deployments in multiple environments.

  • AWS resource discovery and provisioning: automatically detect Microsoft SQL Servers on FSx for ONTAP, FSx for Windows File Servers, and Elastic Block Store deployed from your AWS account. The Databases Inventory serves as a launching point for exploring costs savings opportunities for servers in other AWS storage systems or a management tool for FSx for ONTAP based servers and instances.

  • Sandbox creation: create an on-demand, isolated database environment that can be used for testing, integration, diagnostics, and training, without affecting production data.

  • Database creation: create a user database for your existing Microsoft SQL Servers with Quick or Advanced create modes to configure your database collation, file names, and sizes. Storage configuration is included.

  • Job Monitoring: monitor and track database job execution progress and diagnose and troubleshoot issues in case any failure occurs.

  • Continuous optimization: continuously scans your Microsoft SQL Server estate offline, providing you with a comprehensive report of insights, opportunities, and recommendations to help you achieve operational excellence.

Benefits of Amazon FSx for ONTAP for self-managed databases

  • Durability, availability, and reliability: FSx for ONTAP offers multiple features that enhance the durability and availability of self-managed databases hosted on FSx for ONTAP, such as high availability supporting Single and Multiple Availability Zones deployments, application-aware snapshots, improved disaster recovery using replication, and efficient backup.

  • Performance and scalability: FSx for ONTAP offers performance optimization with high throughput, low latency, high-speed network connections, and scalability with multiple file systems for scaling aggregate performance required for a workload.

  • Data management and efficiency: FSx for ONTAP offers multiple features that enhance data management and efficiency, such as space efficient thin clones, thin provisioning, compression and deduplication, and tiering infrequently accessed data to the capacity pool.

Operational modes in Workload Factory

Three different operational modes - basic, read and automate - offer flexible options for deployment inside and outside of Workload Factory. Gain immediate value at zero-trust in basic mode with code snippets for use outside Workload Factory. Get incremental value with incremental trust in read and automate modes.

Tools to use Workload Factory

You can use BlueXP Workload Factory with the following tools:

  • Workload Factory console: the Workload Factory console provides a visual interface that gives you a holistic view of your applications and projects

  • REST API: Workload Factory REST APIs let you deploy and manage Microsoft SQL Server and other AWS resources

  • CloudFormation: AWS CloudFormation code lets you perform the actions you defined in the Workload Factory console to model, provision, and manage AWS and third-party resources from the CloudFormation stack in your AWS account.

  • Terraform BlueXP Workload Factory Provider: Terraform lets you build and manage infrastructure workflows generated in the Workload Factory console.

Deployment details

Supported configurations

Workload Factory for Microsoft SQL Server supports both high availability (Always on Failover Cluster Instances) and single instance deployments according to AWS, NetApp ONTAP and SQL Server best practices.

SQL Server Version Windows Server 2016 Windows Server 2019 Windows Server 2022

SQL Server 2016

Yes

Yes

No

SQL Server 2019

Yes

Yes

Yes

SQL Server 2022

No

Yes

Yes

Deployment architectures

Single Availability Zone and Multiple Availability Zones deployment architectures are supported for Databases.

Single Availability Zone

The following diagram displays standalone architecture with a Single Availability Zone in a single region.

A diagram of standalone architecture with a single Availability Zone deployment of Amazon FSx for NetApp ONTAP in a single region

Multiple Availability Zones

The following diagram displays two-node high-availability (HA) architecture with failover cluster instance (FCI) cluster in a single region.

A diagram of two-node high-availability architecture with failover cluster instance cluster in a single region

Integrated AWS services

Databases includes the following integrated AWS services:

  • CloudFormation

  • Simple Notification Service

  • CloudWatch

  • Systems Manager

  • Secrets Manager

Supported regions

Databases is supported in all commercial regions where FSx for ONTAP is supported. View supported Amazon regions.

The following AWS regions aren't supported:

  • China regions

  • GovCloud (US) regions

  • Secret Cloud

  • Top Secret Cloud

Getting help

Amazon FSx for NetApp ONTAP is an AWS first-party solution. For questions or technical support issues associated with your FSx for ONTAP file system, infrastructure, or any solution using this service, use the Support Center in your AWS Management Console to open a support case with AWS. Select the “FSx for ONTAP” service and appropriate category. Provide the remaining information required to create your AWS support case.

For general questions about Workload Factory or Workload Factory applications and services, refer to Get help for Databases for Workload Factory.