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.
4,696 questions
Azure synapse : How to check transaction log size usage ?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 40%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
sakuraime
2,321
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
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
HimanshuSinha-msft 19,386 Reputation points Microsoft Employee2020-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 -
sakuraime 2,321 Reputation points
2020-12-08T01:47:21.083+00:00 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 ?
-
HimanshuSinha-msft 19,386 Reputation points Microsoft Employee
2020-12-23T19:35:35.69+00:00 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 -
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 44%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Saurabh Sharma 23,791 Reputation points Microsoft Employee2020-12-28T18:54:32.437+00:00 @sakuraime Following up to know if you have shared your details as per @HimanshuSinha-msft response.
Sign in to comment