News: 1646636353

  ARM Give a man a fire and he's warm for a day, but set fire to him and he's warm for the rest of his life (Terry Pratchett, Jingo)

DBAs massively over-provision Oracle to protect themselves: Microsoft

(2022/03/07)


Microsoft thinks it has cracked the code for cost-effective Oracle-to-cloud migrations.

In a [1]white paper released over the weekend, Microsoft argues that there are savings to be had because on-prem Oracle implementations usually over-provision hardware to leave overhead for growth.

Canny database administrators make matters worse, the paper argues, for the following reasons:

Knowing how budgets work, DBAs also expect that there is a considerable chance when the database comes up for a hardware refresh, it will not receive the funds in the budget, forcing the team to run for longer on the original hardware. As such, DBAs tend to pad the original numbers to prepare for this.

But in the cloud – including Azure, natch – users can instead scale only when needed. Microsoft also reckons that "around 85 per cent of Oracle workloads assessed will require a fraction of the vCPU allocated to the on-premises systems."

Which is not to say that moving Oracle to Azure – or any other cloud – will be a walk in the park. Indeed, the new white paper runs to 34 pages of explanation, analysis, and process.

[2]

On its fourth page, Microsoft points out that "Oracle does not appear to make it easy to migrate anywhere but Oracle Cloud" and notes that the first obstacle Big Red places in the path of would-be movers is a punitive licensing scheme that counts "two vCPUs as equivalent to one Oracle Processor license if multithreading of processor cores is enabled, and one vCPU as equivalent to one Oracle Processor license if multi-threading of processor cores is not enabled."

[3]

[4]

But as the paper unfurls, Microsoft suggests its memory-optimized D, E and M series instance types will get the job done – along with plenty of other Azure services.

[5]Oracle creates new form of free Solaris

[6]Oracle, SAP suspend business in Russia amid invasion

[7]Desperately seeking SaaS: English council to replace Oracle R12

Microsoft's even been decent enough to add a few caveats about items like Oracle's recovery manager – a popular Big Red backup tool – often stressing networks and CPUs, and the complexity of applications built around Oracle's database meaning a certain degree of difficulty is unavoidable. The Beast of Redmond has also admitted that Azure's vanilla solid state disks can't cut it – you'll need both the Premium SSD service at a bare minimum, plus Premium SSD with Ultra disk support for redo logs, and probably Azure NetApp Files once you scale.

Cheap, this is not.

One thing the paper omits is whether all the work it describes will see an Azure-based Oracle rig beat the price that Oracle can offer in its own cloud.

[8]

But by the time you've migrated, and tried to assess the costs avoided, would anyone be able to tell? ®

Get our [9]Tech Resources



[1] https://github.com/Dbakevlar/OracleOnAzure/blob/master/Oracle%20on%20Azure%20IaaS%20Recommended%20Practices%20for%20Success.pdf

[2] https://pubads.g.doubleclick.net/gampad/jump?co=1&iu=/6978/reg_software/databases&sz=300x50%7C300x100%7C300x250%7C300x251%7C300x252%7C300x600%7C300x601&tile=2&c=2YiXl3Jkj8kBRSuxL4MCaaQAAAFg&t=ct%3Dns%26unitnum%3D2%26raptor%3Dcondor%26pos%3Dtop%26test%3D0

[3] https://pubads.g.doubleclick.net/gampad/jump?co=1&iu=/6978/reg_software/databases&sz=300x50%7C300x100%7C300x250%7C300x251%7C300x252%7C300x600%7C300x601&tile=4&c=44YiXl3Jkj8kBRSuxL4MCaaQAAAFg&t=ct%3Dns%26unitnum%3D4%26raptor%3Dfalcon%26pos%3Dmid%26test%3D0

[4] https://pubads.g.doubleclick.net/gampad/jump?co=1&iu=/6978/reg_software/databases&sz=300x50%7C300x100%7C300x250%7C300x251%7C300x252%7C300x600%7C300x601&tile=3&c=33YiXl3Jkj8kBRSuxL4MCaaQAAAFg&t=ct%3Dns%26unitnum%3D3%26raptor%3Deagle%26pos%3Dmid%26test%3D0

[5] https://www.theregister.com/2022/03/04/solaris_common_build_environments_free/

[6] https://www.theregister.com/2022/03/02/oracle_and_sap_suspend_business/

[7] https://www.theregister.com/2022/03/01/hull_oracle_r12_replacement/

[8] https://pubads.g.doubleclick.net/gampad/jump?co=1&iu=/6978/reg_software/databases&sz=300x50%7C300x100%7C300x250%7C300x251%7C300x252%7C300x600%7C300x601&tile=4&c=44YiXl3Jkj8kBRSuxL4MCaaQAAAFg&t=ct%3Dns%26unitnum%3D4%26raptor%3Dfalcon%26pos%3Dmid%26test%3D0

[9] https://whitepapers.theregister.com/



Biggest cost in any Oracle migration

trevorde

License audit

Re: Biggest cost in any Oracle migration

Cederic

Easily avoided - by migrating to Oracle Cloud.

Of course, if you want to use Azure or AWS services and capabilities you'll need the data in their cloud too. Better to migrate to non-Oracle databases and just quietly switch off the on-prem before telling Oracle anything.

Gouge away

Lunatic Looking For Asylum

Oracle are gouging you, can we do it instead.

github?

Cederic

Am I just weird for finding it disconcerting that MS are publishing white papers on Github? Let alone a Github page that has nothing else in it.

Being the suspicious type I did track down the relevant page on a microsoft.com subdomain and it links to the same github repository, so it's legit, just.. well, I don't like it :(

(Thank you El Reg for posting the link though)

Re: github?

LDS

That's where the cool people are... if you don't publish a link under some obscure GitHub nick, and just publish under a company link you're no one.

Microsoft points out ridiculous licence setups...

SickNick

How ironic

RichardBarrell

Isn't it the same, though? While the button is there on a SQL Server instance in Azure to just click it and upsize the instance, does the DBA actually have permission to click it if they haven't secured budget in advance?

nijam

> just click it and upsize the instance

Is it that easy to downsize it again, I wonder?

Why not have an old-fashioned Christmas for your family this year? Just
picture the scene in your living room on Christmas morning as your children
open their old-fashioned presents.

Your 11-year-old son: "What the heck is this?"

You: "A spinning top! You spin it around, and then eventually it falls
down. What fun! Ha, ha!"

Son: "Is this a joke? Jason Thompson's parents got him a computer with
two disk drives and 128 kilobytes of random-access memory, and I get this
cretin TOP?"

Your 8-year-old daughter: "You think that's bad? Look at this."

You: "It's figgy pudding! What a treat!"

Daughter: "It looks like goat barf."
-- Dave Barry, "Simple, Homespun Gifts"