Why is my RDS SQL Server upgrade taking so long?

0
1
Asked By TechieNinja99 On

I started an upgrade for our production SQL Server RDS instance to version 15.0.4435, and it's been running for over 3 hours now. We have multi-AZ enabled for redundancy. Interestingly, when I did the same upgrade on our staging and QA environments, it only took about 20-30 minutes. I'm really curious about what might be slowing down this upgrade. Does anyone know if this duration is typical?

2 Answers

Answered By HelpfulHacker88 On

Make sure to check the MySQL error logs via events from your RDS instance; they could give you some insight into what's causing the delay. Sometimes the logs will show warnings or errors that might help you pinpoint the issue.

TechieNinja99 -

It was actually SQL Server, not MySQL. But yes, it did finish at some point overnight.

Answered By DatabaseDude42 On

One thing to consider is the amount of data in your production database compared to your staging environment. If the prod DB is significantly larger, it could explain the longer upgrade time. Have you checked that?

TechieNinja99 -

Staging and prod should be pretty close to the same. It did eventually finish at some point overnight.

Related Questions

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.