DNN Forums

Ask questions about your website to get help learning DNN and help resolve issues.

CPU Load

You are not authorized to post a reply.

New Around Here

    Hi nukers, 
    I'm trying to make some changes to my DNN to increase the speedness of the site, since it has become very slow for a few months. It happens that if a super user or admin is logged in, the cpu reaches 80/90% blocking the site. With a trace on the db I saw that during login and browsing this sp: GetTab is called many times within a minute (about 5000). In the code there is no logic of this kind called the GetTab, do you have any idea what this could be due to? Or what method of dnn's dlls can do this?

    Edit: I don't know if these db calls could be related to the problem. Other information I can give are: the login is custom but it hasn't been changed since the problem occurred. If I create a user with visibility permissions on everything but not super user or admin, his navigation will be much faster.

    If you have any ideas of what the problem might be or need more info just ask.
    Thank you very much for helping


    Senior Member

      First, can you please help us by providing more information?  What version of DNN are you running?  If it's an older version, are you able to upgrade first?  There are always updates to various features, including those that help improve performance.  

      For example, we're seeing some performance improvements just between three subsequent releases, from 09.10.02 to 09.11.00 to 09.11.01.  Each got a bit faster from what we can tell, and that's just the most recent releases. 

      These days, the default performance settings of DNN can be mostly good,  Beyond that, you may be in the need of various maintenance tasks...  

      1. Uninstall any extensions that are no longer being used (backup first!).  
      2. Turn off any Scheduled Jobs in DNN you don't need.  
      3. Empty your Recycle Bin in DNN.  
      4. Put your DNN website behind a CDN and WAF.  CloudFlare starts as free and there is not need to use their paid plans for many folks.  This will also protect you from attackers.
      5. If the SQL Server is on the same server as your DNN website, try to split them apart to distribute the load.  
      6. Implement a maintenance plan in SQL Server to reindex at least once a month (all depending on your traffic and other factors).  Other maintenance tasks might be necessary.  
      7. Figure out how large your database is, pull a backup, and then delete the data you don't need anymore.  For example, you might be able to delete all of the data older than 3-6 months from the EventLog, SiteLog, and ScheduleHistory tables.  Then, shrink the database and files. 
      8. Begin checking your IIS (and other) logs to ensure the traffic you're serving is indeed traffic that should be served.  For example, do you need to block any bots or other automated scanners/tools so you're only serving real humans?  
      9. Perform an integrity check on your website.  Ensure that there are no viruses or toolkits, and use the Security Analyzer to be sure nothing else DNN is aware of is wrong.  
      10. Increase the server resources of your web/database server.  
      11. Upgrade the OS/version of SQL Server Windows.  
      12. Upgrade your server/hosting plan.  

      That's just a general brain dump... There's more that could be looked into.  

      New Around Here

        Hi Will,
        Thanks for your replay. We are using version 9.9.1 and in two weeks we will upgrade to version 9.11.1 in the test environment. I have already done most of the tinghs in your list. As i said, we doesen't get the problem with the regular users, but with the super user the site become very slow and sometimes we doesen't get a response. There's no log for this problem in iss / dnn log or db.

        Senior Member

          Superusers will always have a slightly slower page load.  Ideally, it should be a negligible difference, but it depends on the website and how it's put together.  Some modules do a TON more for Superusers than others.  So, be aware of that as well.  

          Senior Member

            Oh, and not everyone needs to be an Admin or Superuser. Ideally, both should be highly limited in the number of use accounts, and use role-based permissions instead. :) This will help a lot.

            New Around Here

              Hi Will,
              Thanks for your replay. There is a way to give to a normal user the access to the admin bar?
              As you suggest i would like to take out the super and admin role to certain user to speed up the login, but they need access to the configuration bar to handle the configuration for the site pages. Is there a way to do that? Like give to a custom role the access to the persona bar with only content tab displayed?
              Thanks again

                You can give a Role edit rights on a page.
                Users in that role will then see a (limited) Persona bar to manage the page.
                But there is not one central setting for that, it's per page

                You are not authorized to post a reply.

                These Forums are dedicated to the discussion of DNN Platform.

                For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

                1. If you have (suspected) security issues, please DO NOT post them in the forums but instead follow the official DNN security policy
                2. No Advertising. This includes the promotion of commercial and non-commercial products or services which are not directly related to DNN.
                3. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
                4. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
                5. No Flaming or Trolling.
                6. No Profanity, Racism, or Prejudice.
                7. Site Moderators have the final word on approving / removing a thread or post or comment.
                8. English language posting only, please.

                Would you like to help us?

                Awesome! Simply post in the forums using the link below and we'll get you started.

                Get Involved