Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
2,850 questions
Azure synapse : How to check transaction log size usage ?
sakuraime
2,286
Reputation points
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 ?
{count} votes
-
HimanshuSinha-msft 18,366 Reputation points Microsoft Employee
2020-12-07T23:52:59.61+00:00 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 .
https://learn.microsoft.com/en-us/sql/relational-databases/sql-server-transaction-log-architecture-and-management-guide?view=sql-server-ver15
https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/transaction-log-backups-sql-server?view=sql-server-ver15
https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/back-up-a-transaction-log-sql-server?view=sql-server-ver15
https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-db-log-space-usage-transact-sql?view=sql-server-ver15Thanks
Himanshu
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 ?
Hello ,
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.
Thread URL:
Subscription ID:
Subject:Attention :Himanshu / Martin
Please let me know once you have done the same
Thanks
Himanshu
@sakuraime Following up to know if you have shared your details as per @HimanshuSinha-msft response.
Sign in to comment