* Posts by Dbakevlar

2 publicly visible posts • joined 7 Mar 2022

DBAs massively over-provision Oracle to protect themselves: Microsoft

Dbakevlar

I’m the White Paper Author

The last comment is what I’ve been hearing from many, fellow Oracle DBAs for a couple years now and honestly- just because you don’t know how to do something doesn’t mean that it can’t be done or done well. Every cloud has it’s own tips and tricks to success and Azure is no different. I was an ACE Director, I worked for Oracle and I’m still an Oak Table member and the biggest frustration for me, is that with an Enterprise level cloud, (as with any cloud) there are so many ways to end up making mistakes with IaaS, which is where most high IO workloads will end up.

I’m in agreement with some of the comments here- GitHub is just to get this into the hands of the public as they requested it, published first on the Microsoft Data Architecture Blog, but it will be published to Microsoft Documentation very soon. The goal of this paper was:

1. With the massive quantity of Oracle databases coming to Azure, what is the guidance to migrate successfully and get similar performance to on-premises?

2. I’m told I’ll pay twice as much as I do now. How can I pay less if I need to stay on Oracle, (about 70% of the databases we deal with must stay on Oracle, at least for the foreseeable future.)

3. There’s a lot more out there in storage options for high IO than what most are aware of. What are the tips and tricks to get the performance you need? What should you avoid?

4. If Oracle won’t give Azure a PaaS solution, how can I simplify the management of my databases in Azure?

There’s more on the way, but this paper is a good start and helps support the 5000 customers we already have running Oracle in Azure.

Dbakevlar

Yes, It Is

In Azure, for our recommended architecture, we have a DataGuard Standby, we switchover, then downsize the primary, then switch back over to do so with no outage. If the customer has an environment with no secondary, then they will need to take about a 5 minute outage to downsize the VM.