Database

The database serves as a critical component in Robility for managing and storing data related to automation processes, logs, business rules, user configurations, and more. The database solution must be selected carefully to ensure it meets performance, scalability, and security requirements to handle the volume of data generated by the platform and the automation workflows it supports.

Azure SQL Managed Instance

For optimal performance, scalability, and security, we recommend Azure SQL Managed Instance as your database solution. It offers high availability, automatic backups, and seamless integration with other Azure services, ensuring minimal downtime and robust disaster recovery. Deploying this option provides flexibility and high-performance data management with minimal disruption.

Hardware Requirements

1. Service Tier:

a. General Purpose (suitable for most workloads, uses remote storage for data).

2. vCores:

a. Minimum: 4 virtual CPU cores for essential compute capacity
b. Recommended: 8 virtual CPU cores for better compute capacity and performance.

3. Memory:

a. Minimum: 4 GB per vCore (~16 GB total).
b. Recommended: 7 GB per vCore (~56 GB total) for optimal performance and handling of higher workloads.

4. Storage:

a. Minimum: 128 GB of remote storage (expandable as needed).
b. Recommended: 256 GB of remote storage (expandable).

On-Premises database server

For organizations that require complete control over their database environment or have specific data governance needs, an on-premises database server might be a more suitable choice. Unlike cloud-based solutions like Azure SQL Managed Instance, on-premises setups offer greater control over the hardware, software, and security configurations. 

Organizations that choose this option should be prepared to handle server management, scalability issues, and the increased complexity of disaster recovery without the support of a cloud infrastructure provider.

Hardware Requirements

1. Processor:

a. Minimum: 8 physical cores (e.g., Intel Xeon Silver/Gold, 2.5 GHz or higher).
b. Recommended: 12 physical cores (e.g., Intel Xeon Gold, 2.8 GHz or higher) for better performance and support for high-transaction workloads.

2. Memory:

a. Minimum: 32 GB RAM.
b. Recommended: 64 GB 

3. Storage:

a. SSD/NVMe with at least 256 GB for data.
b. Additional 1 TB for logs, tempdb, and backups.

Software Requirements

1. Operating System

a. Windows Server 2019/2022 (Standard or Datacenter Edition).

2. SQL Server Edition:

a. SQL Server 2019/2022 (Standard or Enterprise).
b. Licensing: Core-based (minimum 8 cores).

Security

a. Enable Transparent Data Encryption (TDE).
b. Use Windows Authentication.

Development Environment

Below are the recommended minimum hardware requirements for the SQL Server development environment.