Hi Vels, 

My DNN is running on IIS 6.0  so am afraid I can't help you with IIS 5.0 settings, as IIS 6.0 differs somewhat from its previous version.

Am also not using cache, so sorry again...

But let´s talk about SQL 2000 server indexing! And really hoping you are using SQL 2000 Standard edition. So anyways here goes!
On your SQL Server:  

1. Open SQL Server Enterprise manager.
2. Open the tree all the way to folder "Management"
   • You'll get something like : Microsoft SQL servers\ SQL server group \ (local) (Windows NT )\ Management
3. Right Click on the Node Database Maintenance Plans
   • Select "New Database Maintenance plan"
   • A wizard will open to guide you to set up maintenance jobs for SQL server!
4. On one of the pages, called "Update Data Optimization information", of the wizard, you can set the option "Reorganize data and index pages" to yes
5. Finish the wizard!

And voila you have just set your SQL server to index periodically! Set it at a time when your activity is low to not affect regular performance.

I have also checked online for a tutorial. It should get you started...Check it here http://www.databasejournal.com/features/mssql/article.php/3530486

Ok good luck!

 

 

 

 

---

Regards,

Jerry Tjon
IT Consultant
Amsterdam,
the Netherlands

I am by the way using SQL Server 2005 Express edition on a Server 2003 Web edition :-)

I will try to find the maintanance plans in the 2005.

Hi vels , try this in the database

1) Verify if Cahetime is <>0
select * from tabmodules where cachetime<>0

then
update it to 0 ( no cache)

2) update tabmodules set cachetime=0 where cachetime<>0


It's works for me in 3.2.0 version of DNN
Don't forgot make a backup of the table ( or database) before.

Excuse my english. Good Luck!

www_dot_creadigital_dot_es