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

HomeHomeUsing DNN Platf...Using DNN Platf...Performance and...Performance and...SQL Queries very slow in Edit ModeSQL Queries very slow in Edit Mode
Previous
 
Next
New Post
12/9/2016 12:57 PM
 

Our environment has two production DNN servers, each one running around 75 Portals. One of these servers works great. However, since upgrading to DNN 8.0.3 the second server is painfully slow when in edit mode. I've used the DNN Glimpse module to look for the source of the problem, and it looks like on the slow server calls to the stored procedures GetModule, GetSharedModulesWithPortal, and GetSharedModulesByPortal all take over 500 ms each. As a result pages with 4 or 5 modules end up taking over 10 seconds to load. On the fast server calls to the same stored procedures take 2ms or less.

I've tried running the same queries by hand in SQL server management studio and they only take a few milliseconds, so I'm baffled as to why they would take so long when called by DNN. 

I've double-checked the performance and optimization settings and they're all the same between the two servers (I've tried with both memory and file caching providers with no change). Any help would be appreciated. 

 
New Post
12/9/2016 1:36 PM
 
I might take a look at the views vw_Modules and vw_TabModules on the server that is having issues and compare it to one that is not.

It looks like all those procs will use those views so I would suspect the problem may potentially be there.

I'd also look to make sure the logs are not overgrown and that the working drive that is doing the hosting has sufficient free space.
 
New Post
12/10/2016 7:24 AM
 
there have been issue with these stored procedures in DNN 8 due to some "optimization".
I suggest trying my TurboDNN Scripts, but please start with a database backup and read instructions carefully.

Cheers from Germany,
Sebastian Leupold (Microsoft MVP)

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Performance and...Performance and...SQL Queries very slow in Edit ModeSQL Queries very slow in Edit Mode


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.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out