what is the default transaction timeout for SQL Server on Linux and how can you adjust it?

Question

what is the default transaction timeout for SQL Server on Linux and how can you adjust it?

Rod-4091 20

Hi,

I can see on this page how to enable XA :-
https://learn.microsoft.com/en-us/sql/connect/jdbc/understanding-xa-transactions?view=sql-server-ver16

However I am curious about how to manage transaction timeouts with SQL Server on Linux. On Windows you can set the XA timeout by configuring MS DTC and the timeout (which defaults to 60 seconds) via component services. Is there a default XA timeout with SQL Server on Linux and if so what is it and can it be increased please?

Thanks

Rod

MikeyQiaoMSFT-0444 3,300 Reputation points

2024-08-23T03:30:33.6066667+00:00

Hi，Rod-4091，We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Accepted answer

1 additional answer

Your answer

MikeyQiaoMSFT-0444 3,300 Reputation points

2024-08-23T03:30:33.6066667+00:00

Hi，Rod-4091，We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Answer 1

MikeyQiaoMSFT-0444 3,300

Hi，Rod-4091

SQL Server does not directly provide control over transaction timeouts. Transaction timeouts are generally considered at the application level. The MS DTC you mentioned is also invoked through .NET System.Transactions.Configuration.

MachineSettingsSection.MaxTimeout Property

How to configure the Microsoft Distributed Transaction Coordinator (MSDTC) on Linux

Here are some additional links for implementing a transaction timeout mechanism.

SqlCommand.CommandTimeout Property
Understanding timeout properties in the JDBC driver

TransactionManager.DefaultTimeout Property

Regards

Mikey Qiao

If you're satisfied with the answer, don't forget to "Accept it," as this will help others who have similar questions to yours.

Rod-4091 20 Reputation points

2025-04-02T04:20:05.8366667+00:00
Hi Mikey,

thanks for taking the time to answer and sorry for the ridiculously long delay in my reply (not been using this account!). My reason for asking was in relation to an application which has some long running transactions involving JMS and JDBC. For Oracle you have a distributed_lock_timeout which defaults to 60 seconds, so a transaction in an application server that is allowed to run for longer than 60 seconds might result in this error:-

ORA-02049: timeout: distributed transaction waiting for lock

based on what I have read there is no equivalent 'short' timeout in SQL Server on either Windows or Linux (although still tempted to test this properly when I have time!). Provided that I control the XA timeout in my application and set to a reasonable value, then it sounds like I don't need to worry about SQL Server terminating the connection prematurely by increasing any timeout on the database side.

Hopefully this question is resolved now anyway - thanks again!

Rod

Answer 2

Zahid Butt 961

Hi,

Please go through below links , may be helpful:

https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-configure-mssql-conf?view=sql-server-ver16#usage-tips

https://learn.microsoft.com/en-us/sql/connect/jdbc/setting-the-connection-properties?view=sql-server-ver16#remarks

Rod-4091 20 Reputation points

2025-04-02T04:21:48.61+00:00

Hi Zahid,

thanks for sharing the links.

Rod

Share via

what is the default transaction timeout for SQL Server on Linux and how can you adjust it?

1 additional answer

Your answer