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

0

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?

wilson
已提问 10 个月前315 查看次数
1 回答
0

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

profile pictureAWS
专家
已回答 10 个月前
  • Both of my Log file and Data file were on D:, When doing capacity planning, I want to put data file on faster SSD than SSD I use for log file for better price-performance.

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则