Azure的SQL数据库操作超时 [英] Azure SQL Database Operation Timeout

问题描述

我有一个共享的托管网站生产完美的作品。它的用户，因此目前我没有问题。

I have a shared hosting site "production" that works perfectly. It has users and thus far I have no issues.

我决定创建一个测试环境。我创建了另一个天青应用程序，并复制了code从我的生产现场这个测试网站。今天这个发生。它没有用户。我创建了一个数据库，并答应每月支付五块钱。因此，这不是一个免费帐户。我上传了我的种子数据，其中一部分是40K的行压缩code的。这都很好没有问题。

I decided to created a test environment. I created another Azure app and copied the code from my "production" site to this test site. This happen today. It has no users. I created a DB and I agreed to pay five bucks a month. So this is not a free account. I uploaded my seed data which part of it was 40K rows of zip code. That went fine without issues.

然而，当我使用的网站，我一直让超时错误。我可以向你保证，这是因为使用不是。我增加了超时从30到90的连接字符串中，但没有有所作为。还有就是生产和测试之间没有code差异。

However, when I use the site, I consistently get timeout error. I can assure you that this is NOT because of usage. I increased the timeout from 30 to 90 in the connection string but that didn't make a difference. There is no code difference between the production and test.

我看了很多帖子这个，但没有帮助。下面是一些样本：

I have read many post about this but none helped. Here are some samples:

<一个href=\"http://stackoverflow.com/questions/34880198/the-wait-operation-timed-out-but-only-from-net-client\">post1 <一href=\"http://stackoverflow.com/questions/26756596/the-wait-operation-timed-out-in-sql-server\">post2 <一href=\"http://stackoverflow.com/questions/31345154/system-componentmodel-win32exception-the-wait-operation-timed-out\">post3 post4 <一个href=\"http://stackoverflow.com/questions/27291338/the-wait-operation-timed-out-win32exception-0x80004005-the-wait-operation-tim\">post5 <一href=\"http://stackoverflow.com/questions/25094681/sqlclient-sqlexception-the-wait-operation-timed-out\">post6

任何想法？

> [Win32Exception (0x80004005): The wait operation timed out]
> 
> [SqlException (0x80131904): Timeout expired.  The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.  This failure occurred while attempting to connect to the
> routing destination. The duration spent while attempting to connect to
> the original server was - [Pre-Login] initialization=27; handshake=25;
> [Login] initialization=0; authentication=0; [Post-Login] complete=3; 
> ]    System.Data.SqlClient.SqlConnection.OnError(SqlException
> exception, Boolean breakConnection, Action1 wrapCloseInAction)
> +2418094    System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> exception, Boolean breakConnection, Action1 wrapCloseInAction)
> +5694436    System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
> stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +285   
> System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior,
> SqlCommand cmdHandler, SqlDataReader dataStream,
> BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject
> stateObj, Boolean& dataReady) +3731   
> System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +58   
> System.Data.SqlClient.SqlDataReader.get_MetaData() +89   
> System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,
> RunBehavior runBehavior, String resetOptionsString) +379   
> System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
> cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean
> async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader
> ds, Boolean describeParameterEncryptionRequest) +2064   
> System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
> cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String
> method, TaskCompletionSource`1 completion, Int32 timeout, Task& task,
> Boolean asyncWrite) +375   
> System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
> cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String
> method) +53   
> System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
> behavior, String method) +240   
> System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior
> behavior) +41   
> System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
> +12    System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand
> entityCommand, CommandBehavior behavior) +435

推荐答案

这是DTU问题。我有5个DTU（S0）我现在有20 DTU（S1）。如果我有我的物理右它像一个蒸汽机和BTU。马力事宜。

It was the DTU issue. I had 5 DTU (S0) now I have 20 DTU (S1). If I have my physics right it's like a steam engine and BTU. Horsepower matters.

这篇关于Azure的SQL数据库操作超时的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！