Thursday, August 22, 2019

[google-cloud-sql-discuss] Re: 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

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.

On Thursday, August 22, 2019 at 12:14:28 PM UTC-4, kenny wrote:
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.

 

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/1c67816a-f7be-4753-9a67-23339e73ac8d%40googlegroups.com.

No comments:

Post a Comment