By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Random RDS SQL Server Questions

0

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/)

Topics
DatabaseMigration & ModernizationAnalytics
Tags
Microsoft SQL ServerAmazon Relational Database Service
Language
English
AWS
Tom_L
asked 6 years ago349 views
1 Answer
0
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.

AWS
EXPERT
Richard Waymire - AWS
answered 6 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content