This is exactly the case. Just the expanding without loading the pages. Caching within the Windows Services is a point. But I found out something else. When the system is slow, loading users in server manager is very slow, too. Repeating the action, it is fast. But it is not chaed on cms side. The SQLs are fired a second time. As the DB caches were hot then, the response was many faster and the cms performed in a good way. So all in all I can prove, that a faster DB results in a faster CMS. Let's see what the meeting with the database admin will bring.
Am Dienstag, 27. August 2013 14:21:50 UTC+2 schrieb Richard Hauer (5 Limes): > > 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] <javascript:> > > 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] <javascript:>. > To post to this group, send email to [email protected]<javascript:> > . > 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.
