Database Services Infrastructure
This section outlines Trapeze's recommendations for the relational database instance required to service the production environment.
For increased operational consistency and reliability, Trapeze recommends configuring Microsoft SQL Server to leverage SQL Server Always On capabilities whenever possible.
Non-production environments may utilize the same underlined database instance while
retaining unique environment database and credential sets. Depending on actual usage
patterns, overall performance should be monitored for acceptability.
| Environment type | License | Memory | Disk |
|---|---|---|---|
| Production | 16 Core @ 2.5GHz | 128 GB | 200GB |
| Non-production | 8 Core @ 2.5GHz | 64 GB | 200GB |
Important:
The above table does not itemize the underlined storage requirements
to store the database files. The Disk should only contain the necessary binaries to operate
the core operating system and the Microsoft SQL Server itself.
Trapeze recommends following Microsoft best practices when considering the storage of SQL data, logs and temporary files residing on separate disks.
Database Performance and Resiliency Characteristics
Trapeze recommends leveraging premium SSDs to deliver high-performance and low-latency disk
support for I/O intensive workloads required for ideal SQL Server operation.
| Disk type | Disk throughput | IOPS | Disk |
|---|---|---|---|
| P10 | 100 MB/s | 500 | 200 GB |
|
This refers to a Microsoft Azure Premium SSD. Similar commercial offerings are available. Please contact your hardware provider for more details and guided recommendations. |
|||
Trapeze OPS Database(s)
The following database size is recommended for each environment.
| Database | Hosted by | Size |
|---|---|---|
| OPS database | SQL Server | 500 GB |
Database Backup Storage
Production and non-production environments require access to the following generic
infrastructure for long-term database backups.
| Storage type | Size |
|---|---|
| Network storage | 1 TB |