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:
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.
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.
Sorry forgot to add... Umbraco version 2.1!
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.
is working on a reply...