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?

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.

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인