top of page

General

Public·51 members

Oracle 19 Performance in Azure

We're using installed Relius Admin, and moved to a new VM and installation of Oracle 19c hosted in Azure over Memorial Day. As anticipated, we experienced a little slowness overall compared to our previous on-prem 11g server, possibly due to the switch 19c, and it took a little time to realize the sizing of the VM that was needed. We found a VM size and disk performance tier that was best for us, and for the most part, that has worked well until mid October to early November. For about the past month, we have had a lot of trouble with jobs taking an incredibly long time to finish. For example, sponsor bal calc used to complete in a few hours, but now we're lucky if it finishes within a day. The metrics for the database VM itself look great. CPU usage averages below 30%, memory around 20%, and disk IO seems to be within range. We have involved an Oracle DBA to help with tuning the database, but really no ideas yet as to why jobs and processes within Relius have started taking so long to complete. I have been looking for changes, and the only thing I've been able to identify are monthly Windows security patches. Has anyone else experienced anything similar, or possibly have any wisdom to share?

40 Views
tom barrett
04 may 2024

I tested AZURE bandwidth through VPN to OCI and found it to be slower than our Verizon Fibre optic through ISP direct to OCI. There is an exclusive AZURE OCI VPN tunnel service ($$$) available which could allow Relius win10/multiuser to run from Azure cloud. This is the only multiuser Win10 license available that I am aware of.

It may be a nice way to shut down local hardware (workstations) if anyone is sick of running hardware. :)


Tbone

bottom of page