Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [query-timeout]

47 questions
14
votes
2 answers

Why "SET LOCAL statement_timeout" does not work as expected with PostgreSQL functions?

My understanding is that PostgreSQL functions are executed similar to a transaction. However, when I tried to "SET LOCAL statement_timeout" within a function, it did not work. Here's how it works within a transaction: BEGIN; SET LOCAL…
Sadeq Dousti
  • 243
  • 1
  • 2
  • 6
13
votes
3 answers

Tracking Down Application Timeout Errors in SQL Server

SQL Server 2008 SP3 How do I track down these timeout errors ? The errors are displayed on an intranet dashboard used specifically for error reporting in IIS. My suspicion is that there is a default timeout of 30 seconds in the web application and…
user4659
13
votes
2 answers

SQL Server - How many type of timeouts can happen, and how?

When working with SQL Server, there can be multiple application host accessing it, and each application can have one or multiple connections. Each connection can potentially have multiple transactions (please correct me if I am wrong). Each…
dsum
  • 739
  • 4
  • 9
  • 20
11
votes
2 answers

Client times out, while MySQL query remains running?

We experienced an issue in which a read-only query, run through MySQL workbench, timed out from a user's UI perspective and remained running on the server (and apparently consuming more and more resources) until we had an outage. Questions Is there…
asthasr
  • 243
  • 1
  • 2
  • 8
8
votes
2 answers

How to set statement timeout per user?

I have multiple users in Postgres. I would like to set up different statement timeouts for different users. Eg: Guest 5 minutes and Admin 10 minutes. Is it possible in Postgres 11.11?
Dharanidhar Reddy
  • 193
  • 1
  • 1
  • 7
6
votes
1 answer

SQL Timeout to Principle Server Error

I am seeing a timeout to the Pricincipel SQL server (2008 R2) The exact error I am seeing is this: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. This failure occured while …
SetiSeeker
  • 161
  • 1
  • 4
5
votes
1 answer

How to inquire about current value of MAX_EXECUTION_TIME

I understand that I can set the value of the global MAX_EXECUTION_TIME by running (from mysql client): SET GLOBAL MAX_EXECUTION_TIME But how do I just inquire its value? GET instead of SET does not seem to accomplish that.
datsb
  • 195
  • 1
  • 2
  • 6
4
votes
1 answer

SQL Server stored procedures fast in SQL but slow when called by ASP.NET

I am using ASP.NET with MVC3 with a SQL server database. From time to time, one of our stored procedures become incredibly slow when called by the web platform, but stay as fast when called directly in SSMS. The solution to this problem is to write…
Éric Guillemette
  • 41
  • 1
  • 2
4
votes
1 answer

Database under heavier load -- all SQL queries start timing out after a period of hours/days

I make a web application which has experienced heavy growth in the past week and it appears my database is seizing up because of it. You can see that everything seemed to be OK until about 3AM this morning and then all of my requests started timing…
Sean Anderson
  • 141
  • 1
  • 5
4
votes
2 answers

Linked server returned message "Query timeout expired."

We have two separate SQL Servers. On one server we have a data warehouse (DWH), on the other we have sales information database. Now on the DWH server there is an ETL job that collects the information from the sales server. The job runs daily after…
Leon
  • 143
  • 1
  • 1
  • 5
4
votes
1 answer

How to put an execution time limit for MySQL Temporary table creation

We can use SET MAX_EXECUTION_TIME=10; statement to stop the execution of a SELECT statement, if it took more than 10 milliseconds to execute the query. But the same wont work for other statements like CREATE TEMPORARY TABLE and INSERT…
Sarath S Nair
  • 163
  • 2
  • 5
4
votes
2 answers

Timeout expired SqlException for complex Procedure

I use SQL Server 2008 R2 and ASP.NET 4.5. Sometimes, I get this error when I executed a complex procedure: System.Data.SqlClient.SqlException Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not…
Kiquenet
  • 155
  • 1
  • 8
4
votes
2 answers

Which timeout(s) are causing my linked server query to time out?

We have two databases on linked SQL Servers that are partially synchronized. Occasionally, one side goes down for an upgrade, then the other goes down for an upgrade, and then we re-synchronize. Upgrades can take upwards of two days.…
Rainbolt
  • 820
  • 1
  • 11
  • 19
3
votes
2 answers

SQL Profiler Shows Update (EventClass) with No Errors, But Data in Table is Not Changed

I am trying to debug a web app that uses a database and I need a little help. The problem is that part of the code throws a timeout error. I started using SQL Server Profiler to check the communication between the app and the database. (I am not…
Ben
  • 163
  • 8
3
votes
0 answers

Execution Plan changes between good and bad query plans (Azure SQL Server)

I've done my best to follow Why is my query suddenly slower than it was yesterday? The ShowPlanXML parses fine with SQL Sentry Plan Explorer but not via brentozar.com/pastetheplan (not sure why) so I have pasted text files to my github instead…
Vince
  • 175
  • 3
1
2 3 4