DBAs massively over-provision Oracle to protect themselves: Microsoft
- Reference: 1646636353
- News link: https://www.theregister.co.uk/2022/03/07/oracle_cloud_migration_microsoft_advice/
- Source link:
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/
Re: Biggest cost in any Oracle migration
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
Oracle are gouging you, can we do it instead.
github?
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?
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...
How ironic
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?
> just click it and upsize the instance
Is it that easy to downsize it again, I wonder?
Biggest cost in any Oracle migration
License audit