Search results
8 mar 2024 · This article describes how to configure the remote query timeout server configuration option in SQL Server by using SQL Server Management Studio or Transact-SQL. The remote query timeout option specifies how long, in seconds, a remote operation can take before SQL Server times out.
14 maj 2021 · SQL Serve has a remote query timeout value that refers to its queries issued on over linked servers, not to queries issued by clients to it. I believe the query timeout is a client property, not a server property.
3 lip 2023 · If the query doesn't return any data within the configured time-out value (typically 30 seconds), the application cancels the query and generates one of these error messages: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
14 paź 2016 · Learn the difference between connection timeout and query timeout in SQL Server, and how to adjust them through code or connection string. See how upgrading .NET version can affect the error messages and performance of your queries.
27 gru 2013 · SQL Server will wait indefinitely before returning to the user. More than likely there was a client side timeout property set. For example you can set a timeout property for the ADO command object .
23 mar 2023 · If you use an application to connect to SQL Server, increase the relevant connection-timeout parameter values and check whether the connection eventually succeeds. For example, if you use System.Data.SqlClient , set the SqlConnection.ConnectionTimeout property to 30 or a higher value.
26 lip 2022 · The remote query timeout setting in SQL Server determines the duration that a query will wait for a response from a remote server before timing out. In this article, we will explore the function of remote query timeouts, how to configure them, the potential impacts of these configurations on performance, and best practices for managing timeouts ...
