[google-cloud-sql-discuss] Space usage for Transaction Log file is near to 0%, Performance tests on GKE with CloudSQL show high wait times for transaction log iops .

Hi,

Seems that user does not have permission to monitor logs and or shrink the file size as its a managed service.

• Space usage for Transaction Log file is near to 0%, we need to shrink these to get better performance for both database instance & tempdb, don't seem to have required permissions ?

• How do we shrink transaction log files when required ? , how do we manage such operations, are there any alternate ways (or) do we have any other user in CloudSQL similar to sa ? to carry out such operations

PFA for reference and help advise with the necessary steps/actions.

--
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/b77ca282-7aa5-48a9-8f8f-a1e4a4596685%40googlegroups.com.