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
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...SQL Server 2000 performance issueSQL Server 2000 performance issue
Previous
 
Next
New Post
8/20/2007 7:00 AM
 
Latino2

Joined: 4/15/2007
Posts: 8

I have a dedicated server running 3 DNN sites.
The problem is that from 2 days ago evevry request i make to the site (like login, navigate no another tab, anything) jumps the SQL Server process to 100%.
It's a sudden problem, everything was working fine 2 days ago and I changed nothing either to the sites or the server itself.
Any ideias?
Thanks in advance!
 
New Post
8/20/2007 7:23 AM
 
Chris Smith


www.nddllc.com
Joined: 1/25/2003
Posts: 681

How about a little more info...I'll assume from the way you phrased your statement that both IIS and SQL are on the same server..right?

Are the 3 DNN sites running on the same DB? Or are they stand-alones? How much traffic does these sites get? How many 'pages' in each site? How large are the database(s) [mdf, ldf]? When was the last time a full back-up was done on the DB's (including the transaction log)? How much free space is available on the server hard-drive(s)?

Have you run SQL Profiler yet? This may give you some insight as to where/if there may be bottlenecks.

 
 
New Post
8/20/2007 8:00 AM
 
Latino2

Joined: 4/15/2007
Posts: 8

Sorry about the little info. I'll try to be more specific.
You're correct, both IIS ans SQL Server 2000 are on the same server. 2 of the sites are running on the same DB and they have around 30 pages each. The other one is under development and has only 1 page and a standalone DB. The sites are very recent and they have few traffic, at the time i started getting this error i was the only one online. The server's HDD has around 60Gb free.

Haven't run SQL profiler yet as i'm an newbie to SQLServer and not sure the results would be much helpful, to me at least. but i'll give it a go a see what comes up.
 
New Post
8/20/2007 9:39 AM
 
Exiton


www.dotnetnukeru.com
Joined: 7/15/2003
Posts: 183

Latino2 wrote

It's a sudden problem, everything was working fine 2 days ago and I changed nothing either to the sites or the server itself.

Try rolling the databese 2 days back.
 
 Page 1 of 1
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...SQL Server 2000 performance issueSQL Server 2000 performance issue


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