Azure synapse : How to check transaction log size usage ?
I have few questions for Azure synapse transaction :.
- How to check the current transaction log size used by Azure synapse db ?
- How to check the transaction log size used by each query ?
- How to truncate the transaction log ? or shrink ?
hello @sakuraime ,
Thanks for the ask and using the forum .
I am not aware how can we check the logs used by each query , but for others you can go through the below articles .
Hi.. seems in Azure synapse there is no option to check the transaction log size and also the backup of transaction log .
so how do we know if the Azure synapse database is using the transaction log and near reaching the limit ?
We did reached out to the internal team and at t ths time we are not getting much traction on this issue from the internal team and so I suggest if you have a support plan you may file a support ticket, else could you please send an email
to AzCommunity@microsoft.com with the below details,
so that we can create a one-time-free support ticket for you to work closely on this matter.
Subject:Attention :Himanshu / Martin
Please let me know once you have done the same
@sakuraime Following up to know if you have shared your details as per @HimanshuSinha-msft response.
Sign in to comment