Rank: Member
Joined: 7/13/2008
Posts: 15
Location: thuis
|
I succesfully set up a second board on the same database. I made a separate web application on my IIS server. url is http://forumfr.thisisbasketball.bewhen we are on the forum with 2 people everything goes dead slow. I mean: This page was generated in 25,316 seconds. the other forum runs from http://forums.thisisbasketball.beAny idea how to improve performance?
|
Rank: Member
Joined: 7/13/2008
Posts: 15
Location: thuis
|
this is a frequent error: Code:System.Data.SqlClient.SqlException: Time-out is verlopen. De time-outperiode is verstreken voordat de bewerking werd voltooid of de server reageert niet.
bij System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
bij System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
bij System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
bij System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
bij System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
bij System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
bij System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
bij System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
bij System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
bij YAF.Classes.Data.DBAccess.ExecuteNonQuery(SqlCommand cmd, Boolean transaction)
bij YAF.Classes.Data.DB.message_deleteRecursively(Object messageID, Boolean isModeratorChanged, String deleteReason, Int32 isDeleteAction, Boolean DeleteLinked, Boolean isLinked, Boolean eraseMessages)
bij YAF.Classes.Data.DB.message_delete(Object messageID, Boolean isModeratorChanged, String deleteReason, Int32 isDeleteAction, Boolean DeleteLinked, Boolean eraseMessage)
bij YAF.Pages.deletemessage.ToogleDeleteStatus_Click(Object sender, EventArgs e)
bij System.Web.UI.WebControls.Button.OnClick(EventArgs e)
bij System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
bij System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
bij System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
bij System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
bij System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
|
Rank: YAF Head Dude
Joined: 10/10/2004
Posts: 2,963
Location: Honolulu, HI
|
You need to improve your Database performance. It's not being maintained properly. This usually means: Running reindexing. Running log truncation. etc. Unfortunately, way beyond the scope of YAF support -- SQL Server Administration is a huge subject on its own. "When you are grateful, fear disappears and abundance appears”." 
|
| Users browsing this topic |