Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

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
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...DNN 3.x on SQL 2005 Express?DNN 3.x on SQL 2005 Express?
Previous
 
Next
New Post
5/9/2007 1:06 PM
 
Niki Iordanov

Joined: 9/1/2005
Posts: 2

We're running a web site on DNN 3.2.2 and MSDE 2000. As the load on the site increased significantly we're currently running into performance problems which I'm pretty sure are related to the MSDE concurrency limitation. There are lots of MSDE warnings in the log like "Concurrent queries exceeded by 60 etc. Limited to 8" or something similar.

My question is if we'll get any performance advantage if we upgrade to SQL 2005 Express. By looking at the MS site it doesn't have the concurrency limitations.

Is anyone running DNN 3.x on SQL Express 2005 and what are the general impressions?

Thank you very much in advance,

Niki
 
New Post
5/9/2007 5:44 PM
 
Timo Breumelhof


Timo Breumelhof's Avatar

www.40fingers.net
Joined: 2/9/2006
Posts: 4430

I have asked thi s question before and some people say you shouldn't use the express version and some say it's no problem.

It is much less limited then the MSDE 2000 version so I'm convinced you should be able to get a better performance.

AFAIK there is no real guideline available.

Would you be prepared to share what load (hist) gives you performance issues with MSDE and on what hardware it's running?

I'm trying to collect some data on this subject.
 
New Post
5/10/2007 9:47 AM
 
Niki Iordanov

Joined: 9/1/2005
Posts: 2

We're running the site on a Pentium D 2.8Ghz, 2GB RAM, 2x200GB Seagate SATA mirror. Win 2K Server OS. ASP.NET 1.1

Currently we have 30K registered users and about 50-150 active (session) users.

We're getting the following Application log like every 5 minutes or something:

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

Niki
 
 Page 1 of 1
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...DNN 3.x on SQL 2005 Express?DNN 3.x on SQL 2005 Express?


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