Trying to understand the I/O performance of our current Oracle DB in performance lab and compare it with our GCP Oracle’s I/O

[kenny]

We’re trying to make sure the GCP’s I/O performance is at least as good as our lab’s so when we find issues it won’t be from the GCP’s I/O. 

Wanted to know how do we achieve this, can someone kindly help me with this.

[kenny]

We’re trying to make sure the GCP’s I/O performance is at least as good as our lab’s so when we find issues it won’t be from the GCP’s I/O. 

Any help/pointers would be greatly appreciated.

 

[Diogo Almeida]

To my understanding you have an Oracle database set up on a VM within the Google Cloud Platform. I would recommend you consider installing Stackdriver Monitoring agent which gathers metrics from the VM instances and third party applications and sends that information to Monitoring. Read more here.

It seems that the metric you are looking for is the `io_time`. The default Stackdriver monitoring monitors Disk I/O (amongst other metrics), but not disk usage. Therefore, you may consider the `compute` metrics for disk usage metrics.

You could then use the Google API Explorer to try and generate an API call to retrieve the information you require.

Once you have this information, there is some useful information here and here which may be helpful in constructing the API call in Google API explorer. If you choose this method, Stackdriver monitoring only records metrics at intervals, so if you want real time data it may not be suitable.