Wait operation has timed out

I"m running SQL Server (2012) on a Hyper-V circumstances. It has actually plenty of resources and also 25% reserved of the full resources, the VHD is inserted on an extremely fast SSD drive for quick response times.

You watching: Wait operation has timed out

Eincredibly currently and also then once the applications that usage the SQL Server haven"t been accessed for a while they obtain the error "The wait procedure timed out". When reloading or retrying to accessibility the database it appears to have actually been "waken up" and is as fast as ever before.

See more: Iphone Battery Percentage Not Changing, Iphone8 Plus Battery Percentage Stuck

Is there any type of method to encertain that this soft sleep mode does not take place on this kind of environment?

Added

Exception Details: System.ComponentModel.Win32Exception: The wait procedure timed out


*

Try to execute this command:

exec sp_updatestats

It, extremely, resolved the trouble.

See more: How To Open Two Onenote Windows, Opening Another Onenote Window

The code over its the error before the command has been executed.

System.Data.SqlClient.SqlConnection.OnError(SqlException exemption, Boolean breakConnection, Action`1 wrapCloseInAction) +1742110 System.File.SqlClient.SqlInternalConnection.OnError(SqlException exemption, Boolean breakConnection, Action`1 wrapCloseInAction) +5279619 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +242 System.File.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +1434 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +61 System.Data.SqlClient.SqlDataReader.get_MetaData() +90 System.File.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +365 System.Documents.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite) +1355 System.Data.SqlClient.SqlCommand also.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String approach, TaskCompletionSource`1 completion, Int32 timeout, Task& job, Boolean asyncWrite) +175 System.File.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +53 System.Documents.SqlClient.SqlCommand.ExecuteReader(CommandBehavior actions, String method) +134 System.File.SqlClient.SqlCommand also.ExecuteDbDataReader(CommandBehavior behavior) +41 System.File.Common.DbCommand also.System.Documents.IDbCommand also.ExecuteReader(CommandBehavior behavior) +10 System.Documents.Common.DbDataAdapter.FillInternal(DataSet datacollection, DataTable<> datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand also command also, CommandBehavior behavior) +140 System.File.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand also command also, CommandBehavior behavior) +316 System.File.Typical.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +86 System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1482 System.Internet.UI.DataSourceView.Select(DataSourceSelectArguments debates, DataSourceViewSelectCallearlier callback) +21 System.Internet.UI.WebControls.DataBoundControl.PerformSelect() +138 System.Internet.UI.WebControls.BaseDataBoundControl.DataBind() +30 System.Internet.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +79 System.Net.UI.WebControls.BaseDataBoundControl.OnPreRender(EventArgs e) +22 System.Internet.UI.Control.PreRenderRecursiveInternal() +83 System.Net.UI.Control.PreRenderRecursiveInternal() +155 System.Internet.UI.Control.PreRenderRecursiveInternal() +155 System.Net.UI.Control.PreRenderRecursiveInternal() +155 System.Web.UI.Control.PreRenderRecursiveInternal() +155 System.Internet.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +974