Hi All,

We are getting timeout expception when multiple users start publishing content. We are using 5.1 Version.

Please find the stack trace below:

[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) +404
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +412
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1363
   System.Data.SqlClient.SqlDataReader.SetMetaData(_SqlMetaDataSet metaData, Boolean moreInfo) +309
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1123
   System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +59
   System.Data.SqlClient.SqlDataReader.get_MetaData() +118
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +6387889
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +6389458
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +538
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +28
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +256
   System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +19
   System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() +23
   NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd) +845
   NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverTypes, Boolean callable, RowSelection selection, ISessionImplementor session) +580
   NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +275
   NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +205
   NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +195

[GenericADOException: could not execute query
[ SELECT this_.NodeVersionId as y0_ FROM dbo.NodeVersionStatusHistory this_ inner join dbo.NodeVersion outerversi1_ on this_.NodeVersionId=outerversi1_.Id WHERE this_.Date in (SELECT max(this_0_.Date) as y0_ FROM dbo.NodeVersionStatusHistory this_0_ inner join dbo.NodeVersion innerversi1_ on this_0_.NodeVersionId=innerversi1_.Id WHERE innerversi1_.NodeId = outerversi1_.NodeId) ORDER BY this_.Date desc ]
[SQL: SELECT this_.NodeVersionId as y0_ FROM dbo.NodeVersionStatusHistory this_ inner join dbo.NodeVersion outerversi1_ on this_.NodeVersionId=outerversi1_.Id WHERE this_.Date in (SELECT max(this_0_.Date) as y0_ FROM dbo.NodeVersionStatusHistory this_0_ inner join dbo.NodeVersion innerversi1_ on this_0_.NodeVersionId=innerversi1_.Id WHERE innerversi1_.NodeId = outerversi1_.NodeId) ORDER BY this_.Date desc]]
   NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +637
   NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) +23
   NHibernate.Loader.Criteria.CriteriaLoader.List(ISessionImplementor session) +60
   NHibernate.Impl.SessionImpl.List(CriteriaImpl criteria, IList results) +1025
   NHibernate.Impl.CriteriaImpl.List(IList results) +63
   NHibernate.Impl.CriteriaImpl.List() +57
   Umbraco.Framework.Persistence.NHibernate.NhSessionHelper.GenerateVersionedQuery(Guid[] nodeIds, RevisionStatusType revisionStatus, Boolean limitToLatestRevision, IEnumerable`1 sortClauses) +10245
   Umbraco.Framework.Persistence.NHibernate.EntityRepository.PerformExecuteMany(QueryDescription query, ObjectBinder objectBinder) +373
   Umbraco.Hive.ProviderSupport.<>c__DisplayClass7`1.<ExecuteMany>b__1() +93
   Umbraco.Framework.Caching.<>c__DisplayClass1`1.<GetOrCreate>b__0() +27
   Umbraco.Framework.Caching.AbstractCacheProvider.GetOrCreate(String key, Func`1 callback) +861
   Umbraco.Hive.ProviderSupport.AbstractReadonlyEntityRepository.ExecuteMany(QueryDescription query, ObjectBinder objectBinder) +369
   Umbraco.Hive.Linq.QueryableDataSourceWrapper.ExecuteMany(QueryDescription query, ObjectBinder objectBinder) +312
   Remotion.Linq.Clauses.StreamedData.StreamedSequenceInfo.ExecuteCollectionQueryModel(QueryModel queryModel, IQueryExecutor executor) +115
   Remotion.Linq.Clauses.StreamedData.StreamedSequenceInfo.ExecuteQueryModel(QueryModel queryModel, IQueryExecutor executor) +204
   Remotion.Linq.QueryProviderBase.System.Linq.IQueryProvider.Execute(Expression expression) +46
   Remotion.Linq.QueryableBase`1.GetEnumerator() +83
   System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) +382
   System.Linq.Enumerable.ToList(IEnumerable`1 source) +80
   Umbraco.Cms.Web.Security.<>c__DisplayClass19.<GetUmbracoUser>b__15() +1023
   Umbraco.Framework.<>c__DisplayClass1`1.<GetOrCreateTyped>b__0() +15
   Umbraco.Framework.<>c__DisplayClass1.<GetOrCreate>b__0(String k) +15
   Umbraco.Framework.HttpRequestScopedCache.DoAddOrChange(String key, Func`2 factory) +170
   Umbraco.Framework.ScopedCacheExtensions.GetOrCreateTyped(AbstractScopedCache cache, String key, Func`1 callback) +170
   Umbraco.Cms.Web.Security.AbstractUmbracoMembershipProvider.GetUmbracoUser(String username, Boolean userIsOnline) +345
   Umbraco.Cms.Web.Security.AbstractUmbracoMembershipProvider.GetUser(String username, Boolean userIsOnline) +16
   Umbraco.Framework.Security.MembershipService`2.GetByUsername(String username, Boolean userIsOnline) +32
   Umbraco.Framework.Security.MembershipService`2.GetById(HiveId id, Boolean userIsOnline) +125
   Umbraco.Framework.Security.<>c__DisplayClass3a.<GetUserGroupIdsForUser>b__39() +1434
   Umbraco.Framework.<>c__DisplayClass1`1.<GetOrCreateTyped>b__0() +15
   Umbraco.Framework.<>c__DisplayClass1.<GetOrCreate>b__0(String k) +15
   Umbraco.Framework.HttpRequestScopedCache.DoAddOrChange(String key, Func`2 factory) +170
   Umbraco.Framework.ScopedCacheExtensions.GetOrCreateTyped(AbstractScopedCache cache, String key, Func`1 callback) +170
   Umbraco.Framework.Security.PermissionsService.GetEffectivePermissions(HiveId userId, HiveId entityId, Guid[] permissionIds) +437
   Umbraco.Cms.Web.Mvc.ActionFilters.UmbracoAuthorizeAttribute.CheckPermissions(HiveId entityId, HiveId userId) +580
   Umbraco.Cms.Web.Mvc.ActionFilters.UmbracoAuthorizeAttribute.AuthorizePermissions(HttpContextBase httpContext, HiveId entityId) +1315
   Umbraco.Cms.Web.Mvc.ActionFilters.UmbracoAuthorizeAttribute.OnAuthorization(AuthorizationContext filterContext) +543
   System.Web.Mvc.ControllerActionInvoker.InvokeAuthorizationFilters(ControllerContext controllerContext, IList`1 filters, ActionDescriptor actionDescriptor) +156
   System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName) +825600
   Umbraco.Cms.Web.Mvc.ActionInvokers.ControllerExtenderActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName) +361
   System.Web.Mvc.Controller.ExecuteCore() +159
   System.Web.Mvc.ControllerBase.Execute(RequestContext requestContext) +335
   System.Web.Mvc.<>c__DisplayClassb.<BeginProcessRequest>b__5() +62
   System.Web.Mvc.Async.<>c__DisplayClass1.<MakeVoidDelegate>b__0() +20
   System.Web.Mvc.<>c__DisplayClasse.<EndProcessRequest>b__d() +54
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +469
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +375

Pleaseee help us out. This is stopping us to go live.