Copied to clipboard

Flag this post as spam?

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


  • Iain Clucas 2 posts 22 karma points
    Jan 11, 2010 @ 17:44
    Iain Clucas
    0

    Umbraco CMS running slow

    Hi, I've been running an Umbraco website for our organisation for a few years on the following server spec:

    1 CPU 2700Mhz, RAM 2GB, Sql Server 2005, Windows Server 2003

    Recently our content editors have reported that the CMS has been running very slow. The server is almost constantly at 100% CPU usage.

    Using PERFMON I noticed that the master database table has an erratic transactions/sec and is very high.

    My Umbraco database transactions/sec is low and steady. I have used SQL Server Profiler to trace transactions and am noticing between 50/100 queries per second using the following EventClasses:

    Audit Login
    SQL:BatchStarting ***SQL query here***
    SQL:BatchCompleted ***SQL query here***
    Audit Logout
    RPC:Completed

    I assume it is this volume of queries that is making the server and CMS run slow. Has anyone come across this before?

    Any advice would be appreciated. Iain.

  • Iain Clucas 2 posts 22 karma points
    Jan 11, 2010 @ 17:53
    Iain Clucas
    0

    Sorry forgot to add... Umbraco version 2.1!

  • Mark Deweese 1 post 21 karma points
    Mar 10, 2011 @ 12:36
    Mark Deweese
    0

    I read in another forum when you see a bunch of Audit Login/Audit Logout that you might want to look at connection pooling.  There seems to be a lot of mystery around pooling and it might not be something you can easily change.

    We are also having trouble with a very slow CMS interface, but the website speed is acceptable.

    Did you ever find an answer?

    Regards.

Please Sign in or register to post replies

Write your reply to:

Draft