August 7, 2018 at 9:53 am
Hi, Is there a need for Index rebuilding for the AWS RDS SQL server -2016 version, considering RDS SQL server is self healing and fully managed by Amazon?
and If I ever want to do index maintenance on AWS RDS SQL instance, is it possible at all?
August 8, 2018 at 6:42 am
AWS RDS is self healing in the sense that they fix health problems that would take your database offline.
It is not self TUNING.
If you want it to go faster, then tuning steps are still left up to you - even including setting things like Cost Threshold and MAXDOP.
August 13, 2018 at 9:14 am
Ok, Thank you!
August 13, 2018 at 9:17 am
Agnii - Tuesday, August 7, 2018 9:53 AMHi, Is there a need for Index rebuilding for the AWS RDS SQL server -2016 version, considering RDS SQL server is self healing and fully managed by Amazon?and If I ever want to do index maintenance on AWS RDS SQL instance, is it possible at all?
You may want to consider proper fill factor settings etc., preventive configurations are always better than reactive maintenance!
😎
August 19, 2018 at 8:01 am
Nope - do your normal due diligence with tuning and statistics.
I have a few MSSQL RDS's under my scope and learned that the hard way. One of our databases had a 1 billion+ row table with 65% fragmentation due to that oversight. Yikes.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply