I am developing a new DNN site for a client and keep getting SQL timeout errors which I just cannot find the cause.

They are very random and I think something is going on in the background that is making this happen but I just cannot find it.

The site is still in development and I am the only person using it so I am very worried that when the site goes live it is going it get worse very quickly.

I need to find someone who has experience with DNN and SQL specifically who could help me track down the problem.

I know this is might be considered off topic but I dont know where else to turn.

If you think you might be able to help then please PM me with your contact details.

I am will to pay a little for help as I am really stuck.

Thanks in advance.

Nathan

Hi Steve, it is a PowerDNN hosted account. So it appears to be one box using SQL express (or whatever MS call it these days). From what I have seen I am not convinced it is network related because when I see the site stop if I try and connect to the SQL server remotely it times out for the same period as the DNN site does. I have pasted below a list of index fragmentation of any that are over 40% but I am not that hot on MS SQL so not sure if there might be something relevant in what it is saying that might be contributing to the problem. Thanks.

TableName TableIndexName avg_fragmentation_in_percent
TabPermission PK_TabPermission 36%
DynamicForms_QuestionRole DynamicRegistrationQuestionRoleID 25%
DynamicForms_QuestionRole RoleID 20%
DynamicForms_QuestionRole InActive 20%
aspnet_Membership PK__aspnet_Membershi__1D66518C 38%
UserProfile IX_UserProfile 43%
UserProfile IX_UserProfile_UserID_PropertyDefinitionID 43%
UserProfile ProfileID 43%
Diseases PK__diseases__3214EC27613302A2 2%
UserRoles PK_UserRoles 29%
UserRoles IX_UserRoles_1 40%
UserRoles IX_UserRoles 40%
Users IX_Users 40%
Users Username 40%
aspnet_Users aspnet_Users_Index2 29%
Assemblies PK_PackageAssemblies 30%
PhytobProductList PK__PhytobPr__3214EC2738260017 40%
iwebs_BE_Emails PK_iwebs_BE_Emails 38%
BritishAmericanWords British 22%
BritishAmericanWords American 22%
TabModules IX_TabModules_UniqueId 40%
TabModules IX_TabModules 29%
TabModules TabID 40%
TabModules ModuleID 40%
TabModules UniqueId 30%
TabModules ModuleID2 40%

Sebastian, thanks for your reply. The sitelog is set to 0 and the event log is truncated every night using the IOWA module (cant remember is name). I also have the backup I do every night shrink the database the way you recommend by taking the recovery mode into simple etc. Is their any way I can run a profiler over the SQL server or a module/plug in I can add to DNN/ASP.net that records SQL times so that I can see which table etc the issue might be related to. I have read (remember I am not super hot on MS SQL as mySQL is more my thing) that their is a Profiler for MS SQL but not sure where I can download this and if it can be used remotely with PowerDNN as I do have access to the MS SQL db etc.

Do you think the list of index fragmentation looks an issue (as I know it would be in mySQL) or am I looking at the wrong thing.

Thanks again.

Nathan