We are using DNN 4.9.1 for our intranet and are unfortunately finding it to be running slowly and not performing as we hoped. The site is hosted on a virtual server with dual 3GHz Xeons and 2GB of ram running Windows Server 2003 (SP2).

We are using a tableless, CSS based skin, with 2 header images (of about 5KB each) and about 6 background images all under 1KB.

Currently the site is made up of approximately 350 pages each with a minimum of 6 modules on them.

We have tried the suggestions on http://www.mitchelsellers.com/blogs/articletype/articleview/articleid/283.aspx and are using a KeepAlive program to ensure the app is kept in the memory.

With a single user browsing the site pages take about 5 seconds to load and takes up about 30% of the server’s CPU. Running a stress test of 100 users caused the site to grind to a halt as 100% of the CPU would be used, however memory usage would remain constant. Any ideas why?

Our front page alone is executing 203 stored procedures (returning 13000 rows) – is this normal? Why are so many stored procedures being executed?

What can we do to speed up our DNN installation?

Thanks in advance.

Hi Cathal,

On the front page we are running a css side menu module that replaces Solpartmenu, we are running the OnyakTech MyLinks module for favourites, 2 XMOD forms, 2 newsfeed modules, 2 ContentManager modules and several Links modules. The site also uses AD Authentication for managing windows logins which some times seems to take an age to authenticate. In our report from our DBA, it seems to be executing GetHostSettings 56 times! surely, that is not right, what are we doing wrong here? It also seems to me that executing over 200 stored procedures on a page load is ridiculous.

Most of the other pages on the system have a ContentManager module, 2 xmod forms and a module we have developed in house to retrieve lists from SharePoint. these pages are faster that the home page, but still very slow under load.

The system is due to go live in May and we are under pressure to deliver. we really need you and the rest of the DNN core members to give us some support so that we can fix these problems and deliver a working system.

Thanks in advance.