English 中文(简体)
页: 1 解雇
原标题:SQL Azure query termination

我记得,有人读到,Call公司将终止长期询问。 在数据库被终止之前,是否有时间限制查询时间? 在我工作的地方,我对每次大约5分钟的大型表格进行了复杂的询问。

最佳回答

将在1分钟以内终止作为IDLE的网络查询,并在负荷平衡器上进行(从外部到网络服务器)。

还将解决你缓慢运行的询问,但只有在他们从服务器机组的其他租户提取资源时,他们才有你的数据库。 我认为,在出现这种旋转性时,没有任何公布的统计数字。

问题回答

MSDN 图书馆和技术网维基撰写了“Lomit”。

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.





相关问题
Windows Azure WorkerRole response

I am working on an Azure demo to run Powershell in a worker role. In my web role I add the name of the Powershell script which is to be run to a CloudQueue object. I can print the script output to ...

Windows Azure WebRole stuck in a deployment loop

I ve been struggling with this one for a couple of days now. My current Windows Azure WebRole is stuck in a loop where the status keeps changing between Initializing, Busy, Stopping and Stopped. It ...

Getting a token for Windows Azure

We are looking at Windows Azure, but getting a token appears to be hard now, at least that s what I m seeing in web searches. Anyone tried it or know how to accelerate that process? Any idea how long ...

Developing Azure .Net 4.0 Applications

Presently .Net 4.0 is not supported on Azure. This thread indicates that you will not be able to use .Net 4.0 with VS 2010 until it is supported in the cloud. http://social.msdn.microsoft.com I d ...

.NET 4.0 on Windows Azure?

My google-fu is failing me on this one. As a possible solution to Unit Testing .NET 3.5 projects using MStest in VS2010 (but I ve put this in a seperate question because it s kind of unrelated): Is ...

热门标签