If it’s just the nav tree in smart edit, I presume you mean the expand/collapse actions and not the navigation actions (as nag actions would likely be related to the content being loaded and not the tree itself). If that’s the case I would look at caching in the various Windows Services and disk queues on the SQL box. You've indicated that CPU and RAM on the db is “normal”, but what about the disks?? Disk I/O performance will cripple a web site as I/o heavy as RedDot.
Sent from Windows Mail From: Boris Crismancich Sent: Tuesday, 27 August 2013 7:18 PM To: [email protected] Hi Richard, CMS performance is overall slow. But clicking the navigation manager Tree in SmartEdit wich is part of the CMS, not part of the Project, is slow. So this in not connected to external references. Cheers, Boris Am Montag, 26. August 2013 23:54:21 UTC+2 schrieb Richard Hauer (5 Limes): Check in-page JavaScript in Smartedit. Things like Facebook and ShareThis are sometimes very slow to load (1-4s) and will block the render thread of the browser. Or is it just in ST that there is a problem? From: Boris Crismancich Sent: 26/08/2013 21:29 To: [email protected] Subject: How to check and prove a slow CMS DB Hi, any private detectives here? There's a CMS 11 server cluster with external, dedicated MS SQL Server where the Navigation Manager tree on the left hand side in SmartEdit is very very slow. As far as I know, the only things that happen here, are select statements and a bit CPU time. CPU and RAM don't show any load above 20%. Navi Manager Processes look bored while the browser is waiting. Even when using the local browser directly on the server. Now the tricky questions: - I may not install a local database to rule out network issues. - I do not have direct access to the DB server, but I may send queries and ask for traces. - As always, the dbas say that the number of DB connections is not limited. I agree that "guilty until proven innocent" is not a nice game to play with database admins. So how would I be able to find and prove the bottleneck? For relevant information that leads to the arrest of the bottleneck, I am prepared to send a package with german beer. Any ideas? Cheers, Boris -- You received this message because you are subscribed to the Google Groups "RedDot CMS Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/reddot-cms-users. For more options, visit https://groups.google.com/groups/opt_out. -- You received this message because you are subscribed to the Google Groups "RedDot CMS Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/reddot-cms-users. For more options, visit https://groups.google.com/groups/opt_out. -- You received this message because you are subscribed to the Google Groups "RedDot CMS Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/reddot-cms-users. For more options, visit https://groups.google.com/groups/opt_out.
