Request a topic or
Contact an Arke consultant
404-812-3123

DNN Performance Troubleshooting

Arke Systems Blog

Useful technical and business information straight from Arke.

Home Archive Contact Subscribe Sign in

About the author

Author Name is someone.

Send mail

Recent posts

IE, hover, and transparent PNGsComments: 0Rating: 0 / 0
Hiding and Changing Left Navigation Items in CRM 4.0 Entity ScreensComments: 12Rating: 5 / 1
Server 2008 Enterprise on Virtual PC 2007Comments: 1Rating: 0 / 0
Reporting Services issues with CRM on Windows Server 2008Comments: 0Rating: 0 / 0
Upgrading to Subversion 1.5.* on a Debian BoxComments: 0Rating: 0 / 0
Resetting the Mac MiniComments: 0Rating: 0 / 0
WSS 3 Tool Version 1.2 for Visual Studio 2008 ReleasedComments: 0Rating: 0 / 0
Troubleshooting IIS Authentication Problems - 401.1 HTTP ErrorComments: 0Rating: 5 / 1
Troubleshooting CRM 4 IssuesComments: 1Rating: 0 / 0
DotNetNuke Endless RedirectsComments: 2Rating: 5 / 2

Recent comments

Hiding and Changing Left Navigation Items in CRM 4.0 Entity Screens (12)
Wayne Walton wrote: Jeremy, thanks for the kind words! Marc, good l… [More]
Hiding and Changing Left Navigation Items in CRM 4.0 Entity Screens (12)
Marc wrote: Thank you Wayne. I had gotten that far, but am st… [More]
Installing Debian and Subversion on Hyper-V (EARLY DRAFT) (7)
Busby SEO Test wrote: It really is a useful post [More]
LinqDataSource with uniqueidentifier Primary Key (5)
Busby SEO Test wrote: This is really educative [More]
Creating a Horizontal Tabbed Menu with the Menu Control (9)
Belajar SEO wrote: although i still confuse with this code, but i'll … [More]
Creating a Horizontal Tabbed Menu with the Menu Control (9)
Babi Ngepet wrote: nice post, thank you for sharing :) [More]
LinqDataSource with uniqueidentifier Primary Key (5)
Busby SEO Test Pinay wrote: Nice and great blog. [More]
Installing Debian and Subversion on Hyper-V (EARLY DRAFT) (7)
cheap electric guitars wrote: Now I know how to install Debian on Hyper-V. [More]
Extending LINQ to SQL (6)
guitars blog wrote: Can I see this properties from datasource designer… [More]
Creating a Horizontal Tabbed Menu with the Menu Control (9)
Busby SEO Test indo wrote: So clearly code for create horizontal tab menu..th… [More]

Archive

2008

Authors

Blogroll

Download OPML file OPML

OPML

Disclaimer

The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

© Copyright 2009

DNN Performance Troubleshooting

I was troubleshooting a client's DNN site today because the response time was horrible. Their site was relatively small and every page load was taking up to 30 seconds. By logging in to the production server, I could see that the CPU would spike to 100% on the sqlsrvr.exe process during the entire page load so that gave me a starting point. Then I dug in to SQL Profiler to identify the problematic query. The resolution was to delete everything from the ScheduleHistory table. I purged the data and the website immediately became fast again. If you notice SELECT queries on the ScheduleHistory table taking a long time, this may be the solution to your problem.

Currently rated 1.0 by 1 people

Currently 1/5 Stars.
1
2
3
4
5

Tags: dnn, sql, performance, profiler

Posted by eric stoll on Thursday, January 03, 2008 6:13 PM

E-mail | Kick it! | DZone it! | del.icio.us

Permalink | Comments (1) | Post RSS RSS comment feed

RSS comment feed

Related posts

Troubleshooting CRM 4 IssuesTroubleshooting IIS Authentication Problems - 401.1 HTTP ErrorDotNetNuke Endless Redirects

Comments

DotNetKicks.com

Thursday, January 03, 2008 6:18 PM

Trackback from DotNetKicks.com

DNN Performance Troubleshooting

Add comment

Name*
E-mail* (Will show your Gravatar icon)
Website
Country Country flag

Comment* [b][/b] - [i][/i] - [u][/u]- [quote][/quote]

Notify me when new comments are added

Live preview

Wednesday, January 07, 2009 12:29 AM