Hi All,

For those of you who are encountering a slow or buggy DNN and who already messed around with cache settings and HTTP compression and what not, but still encounter errors, like 3005 ones occassionally... Problably the error lies at the SQL server side of things.

So without further ado!

By default the SQL server application is allocated a minimum amount of memory that per user for query execution. The default is 1024 kilobytes (KB). You can set amount of memory to a different value.

So I did, and am running our corporate intranet on 32Mb for the last 2 weeks and guess what, no errors, and overall DNN is running smoother!
So if you have access to your SQL server just change the settings and test it out.

Follow the following steps,

• 1. Open SQL Server Enterprise Manager 
• 2. open SQL Server Properties (Memory Tab)

Change the value which stands for Minimum query memory to a higher value.

Click ok

restart DNN and IIS

And bye bye slow DNN loading, hanging, errors etc...

Just trying to give back to the DNN community...

Greetings,

Jerry Tjon

ICT Consultant

Amsterdam