Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

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

HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Too many concurrent MSDE connectionsToo many concurrent MSDE connections
Previous
 
Next
New Post
7/5/2006 4:20 AM
 

I'm having some problem with my DNN 3.1.0 installation.

The windows logfiles mentions quite a large number of connection problems:

"This SQL Server has been optimized for 8 concurrent queries. This limit has been exceeded by 3 queries and performance may be adversely affected."

Since I'm using the msde database only for my DNN installation, something goes wrong between DNN and MSDE.

How do i fix these kind of problems?

 
New Post
7/5/2006 8:21 AM
 

this is a limitation of MSDE - it only handles a certain number of queries, and then queues the rest. There is no way around this with MSDE. However,you can use the free sql express database instead, as it has this restriction removed (instead it only allows you to utilise 1GB of ram). Alternatively, you can purchase sql2000 or sql 2005

Cathal


Buy the new Professional DNN7: Open Source .NET CMS Platform book Amazon US
 
New Post
7/5/2006 10:29 AM
 

I know it is a limitation of MSDE, but my sites aren't that busy. With less than < 500 visitors a day you shouldn't receive such a large numbers of errors. There aren't 8 concurrent users on my sites to generate that much queries....

 

 
New Post
7/5/2006 12:55 PM
 

What I've done with other applications is set limits to the connection pool and the time they are held. This can be changed by adding some values to the connection string. In your scenario, the app could be pooling the connections and keeps going until the pool reaches the .NET default of 100 connections (but of course stops), and/or tries to grab another connection because another hasn't been told it should be released.

The times are in seconds.

Max Pool Size=30;Connect Timeout=90;Connection Lifetime=30;

Messing with these settings to control pooling isn't exactly standard, and many will tell you not to do this. You will be destroying your connections and not taking full advantage of pooling. But this can solve a problem with too many connections and not being released soon enough.

 
New Post
7/5/2006 3:28 PM
 

it's not 8 concurrent users, it's 8 concurrent operations. A single stored procedure may contain multiple operations, they normally happen so quickly, theres little chance of them being queued, but if a number of people are visiting a site concurrently it's not hard to trigger this warning - though that's all it is, a warning. I'd recommend you migrate to sql express as I mentioned before, as it does not have his limit (known as the "governor")

Cathal


Buy the new Professional DNN7: Open Source .NET CMS Platform book Amazon US
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Too many concurrent MSDE connectionsToo many concurrent MSDE connections


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