|
|
Rank: Umbracoholic
Joined: 9/8/2006
Posts: 1,410
Location: KY, USA
|
Slightly off topic... Certainly there are recursive calls to the database with GetMedia(), and that's an issue in an of itself. It should make a single call if possible. GetMedia() can make things slow in a hurry. Here's some background on that issue. http://forum.umbraco.org/yaf_postst2974_XSLT-libraryGetMedia-extremly-slow.aspxcheers, doug.
MVP 2007-2009 - Official Umbraco Trainer for North America - Percipient Studios
|
|
Rank: Aficionado
Joined: 7/23/2006
Posts: 171
|
Thanks for that pointer Doug - I didn't know that and this did something to the performance issue.
But the restarting stille takes places.
I started on development on a new site and kept an eye on this problem because it don't happen on a clean install of Umbraco.
I found out that when I installed my contact forms whit a lot of Ajax implementet - This couses the problem for me.
I used an older version of the Ajax Control Toolkit - I updated my source with the latest release and this seems to fix the problem.
So a possible solution / cause to the bug could be updating the Ajax control toolkit.
thats all / Søren
Søren Linaa
Level 1 & 2 Certified Professional
|
|
Rank: Devotee
Joined: 1/10/2008
Posts: 61
Location: London
|
well, are we sure it's off topic ? I'm not talking about GetMedia itself, but about the ExecuteXmlReader function in the SqlServerHelper class which is used quite heavily throughout the code. My test with the "using" statement did made the job with keeping the connections to the DB to a decent standard, but opened new issues (publishing got wrong). I downloaded the very last changeset (32260), apply my 2 changes and every seems to work now. ExecuteXmlReader doesn't create multi DB connections and content is published as expected in a webfarm environnement. Maybe Ruben you can help us on this; I read on Codeplex there are been some issues with ExecuteXmlReader recently, any downside to have a "using" statement there ? cheers, seb
http://www.be-k.net
|
|
Rank: Newbie
Joined: 11/15/2007
Posts: 2
|
Is there any news of a solution for this problem?
We have currently 2 websites running Umbraco on our dedicated win2003 with SQL Express 2005 and having the exact same problem. We can't see anything obvious in the event logs, there's no errors in the sql logs and our processor and memory usage are low across the board, BUT intermittantly both websites grind to almost a standstill!
They become almost totally un-responsive for a period of time before running as normal again. Until we can find out what the issue is we can't risk using this Umbraco for another client.
|
|
Rank: Newbie
Joined: 2/21/2008
Posts: 2
|
cpalm wrote:It could be a connection pooling problem (website is using to many connections).
Adding this to you connectionstring might help
Min Pool Size=5;Max Pool Size=500;Connect Timeout=10;
Performance monitors are great to find memory leaks or database pooling problems.
On the webserver you should add a counter for
Process -> virtual bytes -> select app pool
Process -> private bytes -> select app pool
On the databaseserver you should add a counter for
SQL Server General Statistics Object -> User Connections I've been having occassional performance problems and adding that to the umbracoDbDSN connection string in the web config seems to make a big difference
|
|
|
Guest |