Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Tom Underhill 13 posts 87 karma points
    Dec 24, 2013 @ 10:39
    Tom Underhill
    0

    Umbraco 6.1.6 database performance

    I'm having some issues with a slow performing 6.1.6 site. The bottleneck seems to be SQL server. Sounds a bit similar to this thread: http://our.umbraco.org/forum/ourumb-dev-forum/bugs/45034-Performance-issues-database-locks-since-612

    Lots of locks and timeouts when more than one editor is using the system, and the logs are full of:

    2013-12-24 09:37:46,291 [9] INFO  Umbraco.Core.Persistence.UmbracoDatabase - [Thread 70]    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

       at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

       at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)

       at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)

       at System.Data.SqlClient.SqlDataReader.Read()

       at Umbraco.Core.Persistence.Database.<Query>d__1c`1.MoveNext()

     

    Anyone got any suggestions?

Please Sign in or register to post replies

Write your reply to:

Draft