Score:0

How to make start/stop time of an AWD RDS MSSQL instance quicker?

fo flag

When I start/stop a simple AWS MSSQL RDS instance, it takes 5 minutes, even tho its nearly empty. How come ? Is there a way to make it faster ? Our on-premise MSSQL cluster apparently takes 10 seconds to start

Thanks

vn flag
You're able to get a cluster of Windows servers from powered-off to running MSSQL in ten seconds? Database clusters aren't intended to be stopped/started on a whim.
David Côté-Tremblay avatar
fo flag
The 10 seconds was stated in the meeting. And I agree with you, but at job I have a task to evaluate the feasibility of it.
vn flag
Sure, but you're evaluating it against incorrect information. You can't start an on-prem MSSQL cluster in 10 seconds, either. I would push back on that piece of information.
Tim avatar
gp flag
Tim
RDS is fairly slow to stop, start, etc, but that's not usually a problem because database servers are rarely restarted. I don't know if you can speed it up, but if you could it would probably be by having a larger instance or faster disk. I've used various sized of Oracle RDS databases, dozens of cores and heaps of RAM, they're still slow to restart.
I sit in a Tesla and translated this thread with Ai:

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.