First of all, I am truly sorry for posting this here, if it's a wrong forum. Second of all I do not think I need to open a support ticket for this one. But I do want some help and advice so I am posting it here.

Please see this thread:

http://www.dotnetnuke.com/Community...fault.aspx

and kindly tell me what I should do to avoid the 100% cpu usage.

Thank you for your time.

Have you tried disabling each of the scheduled tasks to see if the CPU usage drops?

If you have terminal server access to the machine I would recommend running performance monitor. See what is running and what is using the most CPU. A lot of times hosted plans install a standard "image" box and you might be running a whole lot of stuff you don't need.

Once you have eliminated "extra" applications (if you have access/permissions you can turn them off in services) then you can see which applications is taking the the remaining CPU utilization. Generally speaking the worker process and SQL Server take up the most on an DNN installation.

If SQL is pegged this could mean you have a loop or runaway process. This can be caused by anything and you might be troubleshooting SQL code to resolve.

Also - if you have access to perfmon check your memory utilization....is the server paging memory because you've run out of RAM?

Looking at your numbers it does not seem like you DNN install is large enough (84 tabs) to cause some of the larger DNN site problems I've seen with hundreds of portals and thousands of tabs on one DNN install....but that said we run one box with 280 portals and over 50,000 tabs...it's slower than it could be but it's stable.

I don't think I have access to monitor all those things. Plus I wouldn't know how to do it.

Here is my DNN Pro plan from 3essentials. It has the following specifications:

Disk: 40 GB
RAM: 1 GB
Transfer: 2000 GB
CPU - 100% 1 Core
IP Addresses - 2
Plesk - 10 Domains w/ PowerPak

I am still having the problems Now they want me to add 50% core ($50/month)

The VD 100 plan (according to the 3essentials website) does support RDP, which is what you'll need to log in and see what is going on. It's a Windows Server, so 99% of things are troubleshot the same way as you would on your local computer (provided you're running XP or a newer MS OS).

To see what processes are eating up your CPU time, use the Task Manager. If you want long-term statistics, use the Reliability and Performance Monitor, which is in your Administrative Tools menu. If you have trouble finding your way around the server, let me know and I'll do what I can to help.

That is more than enough resource for running a DNN site. You do have a lot's of module installed. One of them may have a memory leak. Buying more resource may be a waste of money. Sooner or later you need to find your problem.

What server OS do you have?
What version of DNN?
What is your traffic load?
Does your site go down time to time?
Is your SQL on the same box? Express or Full Version?

Log into your machine when your CPU goes to 100% go to task manager and see is taking the most resource for CPU and also Memory. It is hard to suggest anything without knowing all details.

oops sorry I see have posted more details on DNN website. Sorry did not see the details...

Your site is having email problems. Truncate the activeforums_queue table. This will prevent all those messages from being sent, but that could be your bottleneck.


Also, utilizing 100% cpu really depends on how much cpu they are actually providing. If you were telling me that your site was on a dedicated server with a 3.x ghz processor then I could see a problem. However, if you are on a shared hosting or VPS then pegging the processor is very subjective.

Also, considering the description of the plan he has specifically says he has 100% of that CPU reserved for his server, it is a bit strange of a complaint. If it is a Hyper-V system, then 100% of the CPU could mean a variety of different things.

Fozen - if you turn off the mail connector schedule does CPU util drop?

I am sorry for not responding sooner. Got busy. I am trying everything you guys have asked me to do.

Will - I tried the script but that did not help. There are still time outs and my website slows down a lot.



@ Dan: They told me I cannot login and see what's going on because it's a managed server?

Steven: I have disabled the MC, there are no time out errors related to MC but my website still slows down.

Also, I am very sorry that I did not mention this earlier but my plan (server) hosts 8 dotnetnuke installs.

The 3 essentials team wants me to add another 50% cpu or reduce the load on the server.

I also asked Mitchel Sellers to look at my database but he think my database does not have a problem. According to him it's the DNN problem and he suggested I talk to Will about the MC time out errors. He made some changes to the settings but that only worked for couple of days.

Everything is back to normal now i.e. 90-100% cpu usage and my websites takes 5 minutes to load.

Now this(although I doubt this is the reason for 100% cpu usage):
DotNetNuke.Services.Exceptions.ModuleLoadException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(String connectionString, String spName, Object[] parameterValues) at Active.Modules.Forums.SqlDataProvider.Search_Standard(Int32 PortalId, Int32 ModuleId, Int32 UserId, Int32 ForumId, Boolean IsSuper, Int32 RowIndex, Int32 MaxRows, String SearchString, Int32 MatchType, Int32 SearchField, Int32 Timespan, Int32 AuthorId, String Author, String Forums, String Tags) at Active.Modules.Forums.af_search_new.BindPosts(Int32 Column, String Sort) at Active.Modules.Forums.af_search_new.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---

Are your databases also hosted on this same server?

Frozen, long story short...you don't have enough hardware. You are on a virtual machine with 1 gb of ram running Windows Server, IIS, SQL Server, MailEnable and probably a few other utilities like antivirus, etc.

Everything is slow on your site, even with everything in the scheduler disabled. It took almost 6 minutes to load your host settings page. It took over 3 minutes for the mailconnector to simply connect to your mail server. That should never take more than 3 seconds when there are no messages to process. I doubt you have just one thing eating up the processor. I would bet that you have several apps begging for processor and memory. When that happens you end up with more hard disk I/O, which in a virtual server environment is usually a problem to begin with.

Before you consider more hardware, ask your hosting provider to check your databases and see if the "auto close" is set to True. If it is, ask them to switch it to false. You may even want to consider using another mail service and even your hosting provider's database server.

Thank you very much for checking it out. I really appreciate that.

I have emailed 3essentials.

Also, can your please explain more about this "You may even want to consider using another mail service and even your hosting provider's database server."

Like which email service? And, what do you mean by "even your hosting provider's database server?" Do you mean host my database somewhere else?

I am sorry about these simple questions but I don't know, honestly.

Thanks again.

Frozen,
You can split the web server (IIS) from the database server (SQL) as well as mail (SMTP) up onto three desperate hosting servers. For example:

SERVER 1 for IIS
SERVER 2 for SQL Server
SERVER 3 for mail.

In my case I do run IIS and SQL on the same server, but I also have a dual zeon processors with 6G of RAM. I also use a separate mail server (Smarter Mail behind a barracuda mail firewall) since SMTP on IIS is pretty lame. Eventually Ill move SQL onto another server but this works for now.



All of this is is dedicated. I co-locate these servers in our rack at a local data center. Generally speaking I get 1 - 3 second page generations.

Yeah, this was a pretty important item to mention. One install with those hardware specs is pushing the limits, 8 installs is just too much.

Offloading your SQL to a different server will ease some of the strain, but will introduce different problems with connectivity. Does your host provide a free SQL server (outside of your current server), or will they make you purchase a second plan for that? Apparently they are not following their posted plan details, so I cannot tell by their website.

Sorry dude.

I have these apps running on my server

- IIS
- MSSQL
- MySql
- Plesk Control panel
- All the default Windows System applications.

'Auto Close' was always set to False.

They are saying only two things are possible.
Error in the code or Low resources.

I am leaning towards low resources now because MC time out error is occurring in the other two websites too.

Thank you. I will see whether I can do this. It's getting pretty expensive since I am not making any money off these websites. I think I should start asking for donations from my members.