azure - SQL Azure 查询终止

Question

我记得在某处读到过 SQL Azure 将终止长时间运行的查询。查询在终止之前可以对数据库运行多长时间是否有时间限制？在我工作的地方，我对大型表运行复杂的查询，每个查询大约需要 5 分钟。

Answer 1

SQL Azure 连接限制由 MSDN Library 和 technet wiki 编写。

http://msdn.microsoft.com/en-us/library/ee336245.aspx#cc http://social.technet.microsoft.com/wiki/contents/articles/sql-azure-connection-management.aspx

例如，

SQL Azure kills all transactions after they run for 24 hours. If you lose a connection due to this reason, you will receive error code 40549.

和

Large transactions, transactions executed in large batches, or large sorts might consume a significant tempdb space. When a session uses more than 5 GB of tempdb space (= 655,360 pages), the session is terminated.