ITS offers SQL Server 2019 database hosting on a shared platform at no cost to customers. To be eligible for this service, the database must meet several requirements including:
- All accounts must follow a least-privilege security model and not require membership in the db_owner database role or sysadmin server role for day-to-day operations
- Applications must connect to the database server with drivers that support encryption in transit
- Transactional (application) databases should be no larger than 100 GB and data mart (reporting) databases should be no larger than 200 GB
- Resource utilization (e.g. memory, CPU, TempDB) must not negatively impact other customers of the service. Typically, applications with fewer than 10,000 database transactions daily and databases under 300 MB do not cause resource issues.
Platform-specific requirements and restrictions are listed in the matrix below. Customers with databases that are unable to meet requirements for any of the shared hosting options must request their own dedicated SQL Server instance: contact the SQL Server DBA team at ITS-SQL-Help@uiowa.edu for assistance.
| IOWASQLPROD7 & IOWASQLTEST7 | IOWASQLPROD8 & IOWASQLTEST8 | IOWASQLDMHOST5 & IOWASQLDMTEST5 | |
|---|---|---|---|
| Description | Default platform for transactional (application) databases | Platform for transactional (application) databases that have higher sensitivity data classifications | Platform for data mart (reporting) databases with larger ETL workloads |
| Data classifications permitted (sensitivity) |
|
|
|
| Data encryption in transit (connection string contains encrypt=true) | Required | Required | Required |
| Database encryption at rest (TDE) | Not available | Enabled | Not available |
| Network access to SQL Server (port 1433) | All ITS data center subnets Non-ITS data center systems with static IP addresses (on request) | Systems with static IP addresses (on request) | All ITS data center subnets Non-ITS data center systems with static IP addresses (on request) |
| High availability (production) | Failover clustering | Failover clustering | Standalone VM |
| Maximum database size | 100 GB | 100 GB | 200 GB |
To request a new database on the SQL Server shared hosting platform, follow the instructions in the support article How to request a new SQL Server database