Forum Discussion

Olivier-IT's avatar
Olivier-IT
MCT
Nov 18, 2022

Hello TimGormanTech 
Thank you for your detailed answer, it’s very helpful.

I tried to work around the problem by doing a script. sh pre and post with only a date return of the snapshot execution. (VMSnapshotPluginConfig.json)

I have the values I’m interested in.

The idea was to see if the time displayed in the Azure portal (8:36) was the "freeze" time of the Oracle database. It seems that no, the time gap for the snapshot is 13 seconds on average.


I take this opportunity to test Azure Resource Graph Explorer and KQL requests in general to list all the VMs that have an Oracle database.
Or that would allow me to return the status "Application Consistent"

 

For database PaaS services, no worries, ARG has the right section.
But because the Oracle database is embedded in my vm, it's another Compute query, I think.

 

 

I thought I should look for "Snapshot" and make the right request, but I’m running out of ideas..
And I’m just getting started in my KQL learning


If you have an idea, I am listening 🙂

TimGormanTech's avatar
TimGormanTech
Copper Contributor
Nov 18, 2022
You're way ahead of me in KQL and Kusto. I'm just trying to make the flood of Oracle workloads moving into Azure more successful, and that is taking up every second of my workday.

I will say that Oracle databases do not figure into any ARM metadata. As far as Azure is concerned, the Oracle database is just an anonymous application within the VM. I'm sure the best you can do is monitor a VM and the storage attached to it.

Resources