Question : I am trying to debug a web app that uses a database and I need a little help. […]
Tag: query-timeout
How to inquire about current value of MAX_EXECUTION_TIME
Question : I understand that I can set the value of the global MAX_EXECUTION_TIME by running (from mysql client): SET […]
Why “SET LOCAL statement_timeout” does not work as expected with PostgreSQL functions?
Question : My understanding is that PostgreSQL functions are executed similar to a transaction. However, when I tried to “SET […]
MySQL: can deadlocks occur for a query not in a transaction
Question : As title says. If a transaction is locking table X, during which another nono-transactional query tries to insert […]
Is there a way to determine the command timeout for an executing spid
Question : Is there a DMV or other mechanism available that returns the command timeout for an executing session_id? Answer […]
Possibility to implement time to execute / TempDB usage restrictions on some role groups in SQL Server?
Question : I have a SQL Environment of which I am sysadmin. This Environment includes the Company data warehouse. I […]
SQL Server Timeout only on production
Question : I have an API endpoint that runs a query. For some reason, when I hit the production endpoint […]
SQL Server stored procedures fast in SQL but slow when called by ASP.NET
Question : I am using ASP.NET with MVC3 with a SQL server database. From time to time, one of our […]
Mysql – Set timeout for Alter table & Update scripts
Question : On MySQL 5.7. I would like to prevent all alter table scripts update scripts that are taking longer […]
Unclear oracle problem with getting response of query
Question : The problem is very unclear, I have an application server, that constructs queries and sends it to Oracle […]