Scaling Down RDS Running SQL Server Standard Edition
The above-mentioned database is running a db.m4.4xlarge instance (16vCPU, 64GB RAM) .
But from the monitoring data of last 6 months, it looks heavily underutilized
Is this alright or any other suggestion or how to pick?
Moreover, I just modify the instance with the whichever size I pick and AWS will move the database data's inside it, right?
- 최신
- 최다 투표
- 가장 많은 댓글
Yes you can just modify the instance type and it will transition the db's as such.. (requries downtime)
The next size down is half (2xlarge). You will not be able to reduce by 1/4.
Yes, SQL Server is supported on m6i, i have deloyed on this type already.
You didnt provide a screen shot for yor memory, so that would need reviewing also.
However, I would look carefully at your IOPS and review your Storage configuration if your using Provisioned IOPS and your stroage type may also help changing to GP3 if you havent already. Also check and if you have a long disk queue also?
관련 콘텐츠
AWS 공식업데이트됨 2년 전
Thank you for answering. I'm new to this domain so I didn't know what details to provide exactly. Why can't I reduce it by 1/4? I have provided the screenshot of memory, IOPS, throughput, disk queue, and storage. Yes, I haven't updated to GP3, that's also on my list.
Please advise.
Also, it would be helpful to know if you have any article guide to understand how to use above-mentioned metrics to understand the right db size.
You can reduce by 3/4 but not by 1/4. You are at a 4xlarge.. You can go to a 2xlarge which is 1/2 You can go to a xlarge which is 3/4 which is may be what you mean 1/4 of what you have but its a reduction of 3/4 Your disk queue seems high.. Your storage auto scailing has maxed out btw.. Have you checked the free space?
Im not sure if you will run out of RAM if you drop the instance size! I know traditional SQL Server can take x% of memory and allocate it to the process. Need to check if same with SQL on RDS
Whats the EBSIOBalance ?