Performance Tuning a SQL Server Database in Amazon RDS

• udaynov17

  SSC Eights!

  Points: 892

  More actions

  June 13, 2020 at 2:20 pm

  #3762833

  Hi Team,

  Thanks in advance for simplifying the the people tasks by your valuable suggestions.

  I am being assigned a new task where in I have to analyze a SQL Server DB in Amazon RDS. I am struck with below issues.

  1. How to performance tune the Database. Can I just a take a backup and then restore it on a stand-alone SQL Server Instance and check with queries to address issues(Missing Indexes, Unused Indexes, Slow running queries and so on ......)
  2. The other option I think is to go through the Performance Insights in Amazon RDS. If so, I see that there are limitations with respect to OS metrics and many others.
  3. I see that system stored procedures in Stand alone SQL Server differs from Amazon RDS SQL Server DB system stored procedures with 'rds' as prefix.

  If anyone is aware of performance tuning the SQL Server DB on Amazon RDS, Please could you share your scripts and suggestions on how I can proceed to accomplish task.

  Thanks once again to all the Team here.

   

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  June 14, 2020 at 3:10 pm

  #3762965

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• Jeff Moden

  SSC Guru

  Points: 1004593

  More actions

  June 14, 2020 at 8:09 pm

  #3762981

  I have to ask... were the databases previously on-premise?  If so, did they "work fine"?

   

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)