O tempo limite de conexão do SQL Server 2012 expirou

3

Estou executando o MS-SQL Server no Windows Server 2012. De vez em quando recebo esta Exceção:

Server Exception : System.Data.SqlClient.SqlException (0x80131904): Connection Timeout Expired. The timeout period elapsed during the post-login phase. The connection could have timed out while waiting for server to complete the login process and respond; Or it could have timed out while attempting to create multiple active connections. The duration spent while attempting to connect to this server was - [Pre-Login] initialization=6; handshake=9410; [Login] initialization=0; authentication=1; [Post-Login] complete=5627; ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out at

Quando isso acontece, eu recebo centenas deles em poucos minutos e depois de um tempo ele se recupera. Não encontrei nada útil na Web. Eu apreciaria qualquer ajuda.

Obrigado

    
por Orr 20.12.2013 / 23:45

0 respostas