Learn DNN / DotNetNuke

You need to Register for free and Login to post a message in the forum.

Forum

Forums
Search Forum
Advanced SearchTopicsPosts

Forums > DotNetNuke® > DotNetNuke® Questions

Connections to SQL database are not closing

Last Post 11/26/2007 5:26 AM by Lee Sykes. 1 Replies.

Sort:

Check this box to subscribe to this topic.	Prev Next
You are not authorized to post a reply.

Author

Messages

e on

Nuke Ace
Posts:42

11/22/2007 3:11 PM
I am m running DNN v4.5.5 and I have one 3rd party module installed (Active Forums v3.7.4) My site is hosted in a shared hosting environment and since I upgraded to v4.5.5 I have had no issues on the site in terms of its resource consumption. However my hosting company recently informed me that that my DNN installation does not always close all the connections with the SQL database and - consequently - my SQL database started to hog 100% of the database server's CPU. When the hosting company brought the issue to my attention I established that: there was no increase (or surge) in my human traffic on the site in the period before the issue emereged (confirmed via my Google Analytics account) I checked then the serach engine robot traffic and there seemed to be some modest traffic so I, in order to eliminate excessive load on the database by search engine robots, I excluded the folder on my site containing the DNN app by updated my robots.txt file Despite these findings and steps that I took, the issue has persisted - the database connections continued to stay open and my SQL server DB hogged 100% of the CPU on the DB serever. The hosting company then took the step to cut the connection between my DNN app and the database pending me resolving the problem (i.e. my DNN app is temporarily dead). What usually causes this sort of issue? Can anyone provide some suggestions on how I can trouble-shoot it? Could it be scheduling tasks? Or logging of errors by the app in the DB? I am very short on ideas as to where I can begin. Thanks, eoghano

Lee Sykes
DNN Creative Staff

Nuke Master VI
Posts:4945

11/26/2007 5:26 AM
hello, This could possibly be caused by the Scheduler, it may be attempting to complete a task and is having problems completing it. Problems I have come across in the past are that the scheduler cannot index the site for the search module, or other elements are related to site logs. I would suggest you look at this tutorial: Site logs, Event logs and Scheduler The tutorial discusses some of those problems and solutions, you may want to begin by stopping the Scheduler altogether (make a note of your settings first) and see if this solves the problem.

Lee Sykes Site Administrator Subscribe to the website : DotNetNuke Video Tutorials : The Skinning Toolkit : DotNetNuke Podcasts Twitter: www.twitter.com/DNNCreative

You are not authorized to post a reply.

Forums > DotNetNuke® > DotNetNuke® Questions

Latest Forum Posts

Can you Run Xcode in Linux? by Aman Singh

Can you Run Xcode in Linux?

Can you Run Xcode in Linux? by Aman Singh

Can you Run Xcode in Linux?

Billed for subscription that was canceled by Ryan

I was just billed for a subscription that was canc eled / inactivetive how do I get a refund for th

Meta Title and Meta Description are not showing properly by DNN User

Hi, On my site the meta title and meta descriptions are not showing properly. It's showing the m

Search is not functioning properly by DNN User

Site: https://www.prv-engineering.co.uk/search If I search any item only the 1st option under sea

Search is not functioning properly by DNN User

Site: https://www.prv-engineering.co.uk/search If I search any item only the 1st option under sea

DNN Platform import site optio by Melanie Weaver

Is it possible to import site template in DNN Platform 8.0? We have internal Evoq Content 8.1 tha

Events Module for DNN V5? by Tugboat

Would anyone have a download link for the version 5.0.3 Events Module? Thanks!

"Ghost" TabID Number? by Tugboat

Hi! I have a portal instance with multiple child portals and on one of the child portals, there i

RE: DNN Load Testing by ayman sharkawy

Hi. Have you already implemented a site using the DNN . And how the performance of the site and its

Publish All Pages by NSUOK

I'm using DNN Evoq Content Basic 8.2.0. When I make the HTML Pro module display on all pages, I h

Simpler profile needed in 9.2.2 by Donald

We are upgrading a DNN 4.8.4 site to DNN 9.2.2. On 4.8.4, the top bar shows the user’s name. If yo

How to link from dnnmodal popup to web site page? by Donald

Hello all. I am using a dnnmodal.show popup. The popup works correctly, showing the content that I

RE: Document Collaboration by Nick Davern

That feature would be super beneficial for our needs as well! Does anyone have an update as to if th

RE: DNN 9.2, how to set default theme? by Andy Stephenson DNN Creative

you do that under "Manage/Themes". Note the highlight blue border around the default container and d

DNN 9.2, how to set default theme? by Donald

Please disregard, found Manage Themes I cannot find how to set a default portal theme in DNN 9.2

RE: Looking for DataSprings Dynamic Forms by Andy Stephenson DNN Creative

Your best chance would be to contact Chad Nash @ http://www.datasprings.com/

Looking for DataSprings Dynamic Forms by Jakir HM

Looking for DataSprings Dynamic Forms 3.4 for DNN 4.x 5.x for my site (https://themasters2018s.com/)

RE: Help with Cycle Image Carousel not displaying images by peter

I had the same problem with the Will Strohl Content Slider after upgrading to DNN 9.1 The above an

RE: Object reference not set to an instance of an object by Andy Stephenson DNN Creative

Check this one might be useful: http://www.dnnsoftware.com/answers/im-tryin-to-move-my-site-to-pr

Used
By

Testimonials

| The SoloCoder Podcast | Google | Privacy Statement | Terms Of Use