Azure SQL Database Operation Timeout
<p>I have a shared hosting site "production" that works perfectly.  It has users and thus far I have no issues.</p>

<p>I decided to created a test environment.  I created another <code>Azure</code> 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.</p>

<p>However, when I use the site, I consistently get <code>timeout error</code>.  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.  </p>

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

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

<p>Any ideas?</p>

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

<p><a href="https://i.stack.imgur.com/gz0la.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/gz0la.png" alt="Usage Graph"></a></p>