Hi
We recently installed DNN 4.5.3 on a dedciated dual core machine (4GB memory), IIS6 on SQL Server 2005. The DNN installation has been configured to run 3 portals consisting of approximarely 500 page in total. Each page contains one or two Text/HTML modules. We also installed a 3rd party search module (Xepient Solutions Open SearchEngine v2). The search engine is scheduled to run once a day.
During the inital page capturing phase the performance on DNN was good. However, once we started reaching approximately 300 pages performance degraded siginificantly. The performance degrade was more noticable on the portal with the most pages. The degrade is not network related as the the same performance issues are visible on the server.
The total database size is still low (16MB). We have also cleared the event log and disabled caching.
From what we can tell the performance problems are database related. During page loads the SQL Server process spikes for several seconds. We have run a SQL Server trace during the page load and have picked up that the GetTabPermissionsByPortal stored procedure is called many times during a normal page load. Unfortunately, I have no idea whether this is normal.
Has any one experienced similiar performance problems with 4.5.3 (we had the same problem with 4.5.1)? Should the GetTabPermissionsByPortal be called so frequently during a page load?
I would appreciate any help with this problem. We are about to start looking at the DNN source code which I am trying to avoid.
Richard