We are consistently receiving the following error when logging into the CMS. From someone else's suggestion, we have been truncating the umbracoLog table to fix the error, however logging is off, the table is empty and the truncate takes around 4 minutes to run, so something else must be wrong. 

I believe it is the insert into umbracoUserLogins that is actually hanging.

Any ideas? 

Timeout
expired.  The timeout period elapsed prior to completion of the operation
or the server is not responding.

Description: An
unhandled exception occurred during the execution of the current web request.
Please review the stack trace for more information about the error and where it
originated in the code. 



Exception Details: System.Data.SqlClient.SqlException:
Timeout expired.  The timeout period elapsed prior to completion of the
operation or the server is not responding.



Source Error: 


 

  

  
An
  unhandled exception was generated during the execution of the current web
  request. Information regarding the origin and location of the exception can
  be identified using the exception stack trace below.
  
 




Stack Trace: 


 

  

  
 
  
[SqlException
  (0x80131904): Timeout expired.  The timeout period elapsed prior to
  completion of the operation or the server is not responding.]
  
  
  System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean
  breakConnection) +2030802
  
  
  System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception,
  Boolean breakConnection) +5009584
  
  
  System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +234
  
  
  System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand
  cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
  bulkCopyHandler, TdsParserStateObject stateObj) +2275
  
  System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader
  ds, RunBehavior runBehavior, String resetOptionsString) +215
  
  
  System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
  cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
  +987
  
  
  System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
  cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
  DbAsyncResult result) +162
  
  
  System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult
  result, String methodName, Boolean sendToPipe) +178
  
  
  System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +137
  
  
  Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection
  connection, CommandType commandType, String commandText, SqlParameter[]
  commandParameters) +56
  
  
  Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String
  connectionString, CommandType commandType, String commandText, SqlParameter[]
  commandParameters) +83
  
  
  umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteNonQuery(String
  commandText, SqlParameter[] parameters) +21
  
  
  umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText,
  IParameter[] parameters) +85
  
 
  
[SqlHelperException:
  Umbraco Exception (DataLayer): SQL helper exception in ExecuteNonQuery]
  
  
  umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText,
  IParameter[] parameters) +140
  
  
  umbraco.BasePages.BasePage.doLogin(User u) +347
  
  
  umbraco.cms.presentation.login.Button1_Click(Object sender, EventArgs e) +421
  
  
  System.Web.UI.WebControls.Button.OnClick(EventArgs e) +118
  
  
  System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
  +112
  
  
  System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String
  eventArgument) +10
  
  
  System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl,
  String eventArgument) +13
  
  
  System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
  
  
  System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint,
  Boolean includeStagesAfterAsyncPoint) +5563