How to put Data file and log file on separate EBS volume to avoid contention in AWS RDS for SQL Server Standard 2019?

Question

While creating on-premise SQL Server 2019 VM, we have the practice of creating data file and log file on separate volumes(physical drives), I believe equivalent here is EBS storage.

How do I put  Data file and log file on separate volume to avoid contention?

Answer

Hi,

AWS RDS for SQL Server Standard 2019 is a fully managed service. You do not have to take care of data / log placement anymore. It becomes an AWS responsibility. It is handled by the service for you. That is the power of managed services.

From the doc: https://aws.amazon.com/rds/sqlserver/

```
Fully managed
Amazon RDS for SQL Server is fully managed by Amazon Relational Database Service (RDS). You no longer 
need to worry about database management tasks, such as hardware provisioning, software patching, setup, 
configuration, or backups.

Single click high availability
With a single click, you can enable the Multi-AZ option, replicating data synchronously 
across different availability zones. In case the primary node crashes, your database will 
automatically failover to the secondary and we will automatically re-build the secondary.
```

Best,
Didier

How to put Data file and log file on separate EBS volume to avoid contention in AWS RDS for SQL Server Standard 2019?

Relevant content