Hi,

I got to the point where I really need help.

I have messed with performance problems for months now, trying caching in all aspects, ping services, keep alives, iis isolation modes, webfarming etc etc etc. Got all errors fixed there was in the event log and still my CPU goes balistic everytime a page loads ( 100% for 5 to 15 seconds ).

In the end I ran SQL profiler on the SQL 2005 Express that DNN reads from. The big performance eater here is this call GetTabPermissionsByPortal that for some reason is called alot of times for each click on the site.

Any recommandations?

Regards

Vels

Well actually the site is not that big. 88 pages and no users yet since it is not released to the public but just going thru internal test.

It ofcourse helps to set chache mode to moderate, but that sometimes has a nasty effect on the forum when making a new thread. For some reason that does not always handle caching very nicely.

I guess there is nothing to do but perhaps discharge the forum until a new performance improved version gets released.

I by the way noticed that aspnet_wp eats alot of cpu along with the sqlserver. The server is a 2 x 3GHz Pentium with 3GB RAM so its pretty annoying to see a server that should be powerfull enough to run this go to its knees.

Thank you for your reply.

Regards

Vels

Thanks Jerry,

Everything is patched to newest updates and SP's inclusive til SQL Server. But if you could tell me how you perform the indexing of the SQL server I would apreciate it since my knowledge on that front aint on expert level.

My IIS is now running IIS 5 isolation mode since running in a application pool consumed huge amounts of memory. No matter what I tweaked and tuned from various articles and tutorials in the app pool the problem kept on being there. The server slowly consumed more and more memory ( up to over 2,5 GB ). Ofcourse I could resolve that by setting memory limits in the app pools - however that was not the sollution I was going for,

It should be said that the performance problem is absolutely worst when I dont use cache in the host options. My reason to disable the cache is that the standard DNN Forum sends out like 10 mails if a issue is updated and sometimes users cannot submit new issues if cache is enabled. I messed with the cachetime of the module that standard is set to -1 and I tried setting it so 0 (zero) with no luck though.

Thanks for your answer, I will be looking forward to trying the indexing.

Regards

Vels