Random RDS SQL Server Questions

Question

A customer is in the midst of RDS adoption and they have lots of questions.  Here are the latest few:

1. Our product uses some custom error messages from sys.messages. Based on our installation results it appears as though this is not allowed on RDS. Can you confirm that it is not allowed and if so, is there any possibility that we could get an exception for our product?

2. As part of our regular maintenance on our DBs we require that our two most heavily used DBs be re-indexed and shrunk on a regular basis.  Does RDS automatically perform these actions for us?

3. What is the uptime SLA for Single AZ instances? (Multi-AZ is published as 99.95% https://aws.amazon.com/rds/sla/)

Accepted Answer

1. Yes, you need sysadmin or serveradmin to run sp_addmessage.  Might be able to file a support ticket and have the messages added, you'd want to check with RDS DB Engineering to confirm.  Also, keep in mind that in a mirror setup you'd have to do this on the mirror partner as well.

2. No, you must do your own checkb, reindex, etc. on your user databases.

3. RDS SQL Server at this time doesn't have a formal SLA, I'm not aware of any uptime published.

Random RDS SQL Server Questions

관련 콘텐츠