New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...SQL Timeout errorsSQL Timeout errors
Previous
 
Next
New Post
1/7/2012 6:41 AM
 

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

 
New Post
1/7/2012 10:41 AM
 
Nathan,
Intermittent connections suggest network issue. What sort of configuration do you have? One machine with both IIS and SQL or two (one web head and one SQL box)?


Steven Webster
Manager, Community Platform
F5 Networks, DevCentral
 
New Post
1/7/2012 1:03 PM
 
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%
 
New Post
1/8/2012 5:08 AM
 
please check for big tables with many entries, eventually you might need to truncate some of the log tables (sitelog, eventlog)

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
1/8/2012 7:17 AM
 
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
 
Previous
 
Next
HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...SQL Timeout errorsSQL Timeout errors


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.