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.

I still have these issues, even after moving to PowerDNN and getting a better server. I have spoken with few db experts and they all say something is wrong with the forum.  Yesterday, my db size jumped from 200mb to 900mb. I have shrunk the db and did the other truncate things but no change.

Do you see anything abnormal in the table below? Please let me know.

Thanks.

tableName	numberofRows	reservedSize	dataSize	indexSize	unusedSize
Skins	490	200 KB	128 KB	16 KB	56 KB
UrlLog	474	32 KB	16 KB	16 KB	0 KB
sysdiagrams	0	0 KB	0 KB	0 KB	0 KB
SiteLog	0	0 KB	0 KB	0 KB	0 KB
activesocial_Groups_MemberTypes	2	16 KB	8 KB	8 KB	0 KB
DynamicRegistration_FormLocalization	0	0 KB	0 KB	0 KB	0 KB
activesocial_Properties	0	0 KB	0 KB	0 KB	0 KB
HtmlTextLog	43	16 KB	8 KB	8 KB	0 KB
ifty_Site404Log	0	0 KB	0 KB	0 KB	0 KB
activesocial_Gallery_Album	18	16 KB	8 KB	8 KB	0 KB
activesocial_Log	922531	37384 KB	37264 KB	80 KB	40 KB
TabPermission	315	136 KB	24 KB	112 KB	0 KB
activeforums_Topics_Ratings	12	16 KB	8 KB	8 KB	0 KB
HtmlTextUsers	0	0 KB	0 KB	0 KB	0 KB
DynamicRegistration_QuestionLocalization	0	0 KB	0 KB	0 KB	0 KB
UserPortals	4540	344 KB	152 KB	160 KB	32 KB
DnnForge_NewsArticles_Article	1042	2832 KB	2688 KB	16 KB	128 KB
ModuleControls	257	192 KB	64 KB	72 KB	56 KB
activeforums_Topics_Tags	0	0 KB	0 KB	0 KB	0 KB
DynamicRegistration_Wizard	33	16 KB	8 KB	8 KB	0 KB
FolderPermission	5386	1136 KB	328 KB	576 KB	232 KB
activeforums_Topics_Tracking	56280	3792 KB	2288 KB	1392 KB	112 KB
Modules	169	368 KB	288 KB	40 KB	40 KB
ContentItems_Tags	0	0 KB	0 KB	0 KB	0 KB
activeforums_Content_Attachments	47	48 KB	40 KB	8 KB	0 KB
Version	39	32 KB	8 KB	24 KB	0 KB
DNNStuff_Aggregator_Tab	6	32 KB	24 KB	8 KB	0 KB
Languages	1	32 KB	8 KB	24 KB	0 KB
Taxonomy_ScopeTypes	2	16 KB	8 KB	8 KB	0 KB
activeforums_UserProfiles	4064	1464 KB	512 KB	936 KB	16 KB
activeforums_Topics_Related	0	0 KB	0 KB	0 KB	0 KB
DnnForge_NewsArticles_File	0	0 KB	0 KB	0 KB	0 KB
LanguagePacks	1	32 KB	8 KB	24 KB	0 KB
Taxonomy_VocabularyTypes	2	16 KB	8 KB	8 KB	0 KB
Classification	0	0 KB	0 KB	0 KB	0 KB
UsersOnline	5	16 KB	8 KB	8 KB	0 KB
activeforums_URL	0	0 KB	0 KB	0 KB	0 KB
Taxonomy_Vocabularies	1	16 KB	8 KB	8 KB	0 KB
UVG_Category	6	16 KB	8 KB	8 KB	0 KB
SearchItem	0	0 KB	0 KB	0 KB	0 KB
UVG_Comment	0	0 KB	0 KB	0 KB	0 KB
PortalLanguages	2	32 KB	8 KB	24 KB	0 KB
UVG_Rating	0	0 KB	0 KB	0 KB	0 KB
SearchIndexer	1	16 KB	8 KB	8 KB	0 KB
activeforums_Properties	1	16 KB	8 KB	8 KB	0 KB
UVG_Video	4	16 KB	8 KB	8 KB	0 KB
activesocial_Categories	5	16 KB	8 KB	8 KB	0 KB
PortalLocalization	2	16 KB	8 KB	8 KB	0 KB
UVG_VideoCategory	0	0 KB	0 KB	0 KB	0 KB
ModuleDefinitions	81	88 KB	32 KB	56 KB	0 KB
Taxonomy_Terms	0	0 KB	0 KB	0 KB	0 KB
Files	3713	1640 KB	984 KB	448 KB	208 KB
activesocial_ItemCategories	2	32 KB	8 KB	24 KB	0 KB
DynamicRegistration_QuestionEventHiddenFields	0	0 KB	0 KB	0 KB	0 KB
grmRepositoryObjectCategories	1033	136 KB	80 KB	8 KB	48 KB
DnnForge_NewsArticles_EmailTemplate	0	0 KB	0 KB	0 KB	0 KB
DNNStuff_Aggregator_Module	10	16 KB	8 KB	8 KB	0 KB
grmRepositoryObjectValues	0	0 KB	0 KB	0 KB	0 KB
AnonymousUsers	252	136 KB	88 KB	8 KB	40 KB
ProfilePropertyDefinition	93	136 KB	40 KB	48 KB	48 KB
DynamicRegistration_Question	30	56 KB	40 KB	16 KB	0 KB
forgotUserName_Message	2	32 KB	24 KB	8 KB	0 KB
EventLog	64	608 KB	520 KB	8 KB	80 KB
EventLogConfig	103	24 KB	16 KB	8 KB	0 KB
EventLogTypes	129	40 KB	32 KB	8 KB	0 KB
EventQueue	19	56 KB	48 KB	8 KB	0 KB
PortalDesktopModules	124	32 KB	8 KB	24 KB	0 KB
activeforums_Attachments	53	504 KB	496 KB	8 KB	0 KB
Tabs	138	192 KB	80 KB	64 KB	48 KB
WebServers	5	16 KB	8 KB	8 KB	0 KB
UserRoles	11136	1184 KB	768 KB	320 KB	96 KB
activeforums_AuditLog	0	0 KB	0 KB	0 KB	0 KB
ModulePermission	239	112 KB	16 KB	96 KB	0 KB
Links	120	152 KB	56 KB	40 KB	56 KB
ScheduleItemSettings	0	0 KB	0 KB	0 KB	0 KB
DynamicRegistration_QuestionOption	0	0 KB	0 KB	0 KB	0 KB
activeforums_Content	38058	109328 KB	106768 KB	2088 KB	472 KB
DNNStuff_Aggregator_Target	0	0 KB	0 KB	0 KB	0 KB
Vendors	0	0 KB	0 KB	0 KB	0 KB
SearchItemWord	0	0 KB	0 KB	0 KB	0 KB
Packages	184	3520 KB	3296 KB	56 KB	168 KB
DynamicRegistration_DynamicEventPaymentStatus	0	0 KB	0 KB	0 KB	0 KB
DynamicRegistration_QuestionResponse	37533	3400 KB	3296 KB	32 KB	72 KB
Ventrian_PropertyAgent_ShortList	0	0 KB	0 KB	0 KB	0 KB
ModuleSettings	1554	272 KB	224 KB	16 KB	32 KB
SkinControls	54	16 KB	8 KB	8 KB	0 KB
activeforums_Filters	240	80 KB	24 KB	16 KB	40 KB
DnnForge_NewsArticles_Category	106	32 KB	24 KB	8 KB	0 KB
activeforums_Forums	66	32 KB	16 KB	16 KB	0 KB
DnnForge_NewsArticles_Handout	0	0 KB	0 KB	0 KB	0 KB
DnnForge_NewsArticles_Comment	0	0 KB	0 KB	0 KB	0 KB
activesocial_Messages	5865	2072 KB	1920 KB	16 KB	136 KB
DnnForge_NewsArticles_HandoutArticle	0	0 KB	0 KB	0 KB	0 KB
UrlTracking	380	136 KB	56 KB	80 KB	0 KB
activesocial_Groups_Subscriptions	28	64 KB	40 KB	24 KB	0 KB
Affiliates	0	0 KB	0 KB	0 KB	0 KB
Urls	195	96 KB	32 KB	64 KB	0 KB
DynamicRegistration_PayPalUserID	0	0 KB	0 KB	0 KB	0 KB
activesocial_Journal_Access	0	0 KB	0 KB	0 KB	0 KB
activesocial_Journal_Security	22543	1552 KB	640 KB	720 KB	192 KB
aspnet_Applications	1	64 KB	8 KB	56 KB	0 KB
activesocial_Groups	15	48 KB	32 KB	16 KB	0 KB
activesocial_GroupTypes	5	16 KB	8 KB	8 KB	0 KB
activesocial_User_Blacklist	0	0 KB	0 KB	0 KB	0 KB
Banners	0	0 KB	0 KB	0 KB	0 KB
Messaging_Messages	65	80 KB	64 KB	16 KB	0 KB
activesocial_User_Signature	1	16 KB	8 KB	8 KB	0 KB
activeforums_Forums_Tracking	8429	664 KB	384 KB	248 KB	32 KB
DNNStuff_Aggregator_CustomProperties	18	32 KB	24 KB	8 KB	0 KB
DynamicRegistration_Events	14	48 KB	40 KB	8 KB	0 KB
Profile	3604	992 KB	784 KB	96 KB	112 KB
grmRepositoryCategories	284	48 KB	16 KB	32 KB	0 KB
aspnet_Users	4543	1568 KB	624 KB	744 KB	200 KB
grmRepositoryComments	143	120 KB	88 KB	32 KB	0 KB
grmRepositoryObjects	600	568 KB	496 KB	48 KB	24 KB
DNNStuff_Aggregator_Script	2	16 KB	8 KB	8 KB	0 KB
aspnet_Paths	0	0 KB	0 KB	0 KB	0 KB
activesocial_Groups_Members	6342	584 KB	392 KB	8 KB	184 KB
activeforums_ForumTopics	6023	1320 KB	376 KB	680 KB	264 KB
SearchCommonWords	369	32 KB	16 KB	16 KB	0 KB
activesocial_Groups_Forums	20	16 KB	8 KB	8 KB	0 KB
activeforums_Groups	7	16 KB	8 KB	8 KB	0 KB
activesocial_User_Events	1	16 KB	8 KB	8 KB	0 KB
Ventrian_PropertyAgent_Statistic	46033	1288 KB	1056 KB	8 KB	224 KB
aspnet_SchemaVersions	6	16 KB	8 KB	8 KB	0 KB
activesocial_Feeds	1	16 KB	8 KB	8 KB	0 KB
ActiveForums_MC_Log	0	0 KB	0 KB	0 KB	0 KB
activesocial_User_Events_Files	1	16 KB	8 KB	8 KB	0 KB
ActiveForums_MC	2	16 KB	8 KB	8 KB	0 KB
PortalAlias	12	32 KB	8 KB	24 KB	0 KB
aspnet_PersonalizationAllUsers	0	0 KB	0 KB	0 KB	0 KB
Lists	396	80 KB	56 KB	16 KB	8 KB
DnnForge_NewsArticles_CustomField	1	16 KB	8 KB	8 KB	0 KB
ActiveForums_PostGUID	488	32 KB	16 KB	16 KB	0 KB
activesocial_Comments	19	32 KB	16 KB	16 KB	0 KB
activeforums_Poll	302	136 KB	64 KB	16 KB	56 KB
activesocial_User_Events_Guests	14	16 KB	8 KB	8 KB	0 KB
DnnForge_NewsArticles_CustomValue	0	0 KB	0 KB	0 KB	0 KB
activeforums_Poll_Options	1206	272 KB	240 KB	16 KB	16 KB
aspnet_PersonalizationPerUser	0	0 KB	0 KB	0 KB	0 KB
activeforums_Poll_Results	31	16 KB	8 KB	8 KB	0 KB
MetaData	15	16 KB	8 KB	8 KB	0 KB
Folders	1078	328 KB	144 KB	136 KB	48 KB
TabModuleSettings	631	80 KB	56 KB	16 KB	8 KB
ContentItems_MetaData	0	0 KB	0 KB	0 KB	0 KB
aspnet_Membership	4543	2456 KB	1824 KB	488 KB	144 KB
UVG_Tag	6	16 KB	8 KB	8 KB	0 KB
ScheduleHistory	81	184 KB	120 KB	64 KB	0 KB
activesocial_JournalUserSettings	0	0 KB	0 KB	0 KB	0 KB
activeforums_Ranks	25	16 KB	8 KB	8 KB	0 KB
activesocial_Files_Related	0	0 KB	0 KB	0 KB	0 KB
UVG_VideoTag	6	16 KB	8 KB	8 KB	0 KB
activesocial_Filters	0	0 KB	0 KB	0 KB	0 KB
activeforums_Replies	32018	2432 KB	1056 KB	1160 KB	216 KB
UserProfile	23482	3984 KB	2616 KB	872 KB	496 KB
DnnForge_NewsArticles_Page	1042	2576 KB	2488 KB	16 KB	72 KB
activesocial_JournalGroupSettings	0	0 KB	0 KB	0 KB	0 KB
VendorClassification	0	0 KB	0 KB	0 KB	0 KB
modulesettings_backup	247	32 KB	24 KB	8 KB	0 KB
Authentication	4	16 KB	8 KB	8 KB	0 KB
HtmlText	52	792 KB	696 KB	8 KB	88 KB
activeforums_Security	211	96 KB	56 KB	40 KB	0 KB
activesocial_JournalTypeFilters	50	32 KB	8 KB	24 KB	0 KB
DnnForge_NewsArticles_Tag	0	0 KB	0 KB	0 KB	0 KB
activesocial_Friends	1285	72 KB	56 KB	16 KB	0 KB
DnnForge_NewsArticles_ArticleTag	0	0 KB	0 KB	0 KB	0 KB
UserAuthentication	3	32 KB	8 KB	24 KB	0 KB
DnnForge_NewsArticles_Rating	1	16 KB	8 KB	8 KB	0 KB
UVG_Screenshot	0	0 KB	0 KB	0 KB	0 KB
SearchItemWordPosition	0	0 KB	0 KB	0 KB	0 KB
aspnet_WebEvent_Events	0	0 KB	0 KB	0 KB	0 KB
DynamicRegistration_BlackList	4	16 KB	8 KB	8 KB	0 KB
Dashboard_Controls	6	16 KB	8 KB	8 KB	0 KB
activeforums_Permissions	53	80 KB	24 KB	16 KB	40 KB
activesocial_Settings	108	24 KB	16 KB	8 KB	0 KB
activesocial_Messages_User	11724	712 KB	648 KB	16 KB	48 KB
SystemMessages	0	0 KB	0 KB	0 KB	0 KB
DynamicRegistration_QuestionRole	1038	136 KB	104 KB	16 KB	16 KB
UVG_Series	0	0 KB	0 KB	0 KB	0 KB
activesocial_Journal	10596	72512 KB	36712 KB	34184 KB	1616 KB
MCISS_Cache	0	0 KB	0 KB	0 KB	0 KB
DnnForge_NewsArticles_ArticleCategories	855	32 KB	16 KB	16 KB	0 KB
aspnet_Profile	0	0 KB	0 KB	0 KB	0 KB
MCISS_MenuUpdate	84	56 KB	48 KB	8 KB	0 KB
UVG_Commercial	0	0 KB	0 KB	0 KB	0 KB
activesocial_JournalComments	18	40 KB	32 KB	8 KB	0 KB
activesocial_User	3754	1168 KB	720 KB	104 KB	344 KB
DynamicRegistration_PayPalPreviousPayPalTXNID	0	0 KB	0 KB	0 KB	0 KB
Ventrian_PropertyAgent_Rating	269	32 KB	16 KB	16 KB	0 KB
UVG_CommercialImpression	0	0 KB	0 KB	0 KB	0 KB
SearchWord	0	0 KB	0 KB	0 KB	0 KB
HostSettings	158	32 KB	16 KB	16 KB	0 KB
Ventrian_PropertyAgent_Comment	10	232 KB	152 KB	8 KB	72 KB
Portals	2	32 KB	8 KB	24 KB	0 KB
Permission	8	32 KB	8 KB	24 KB	0 KB
DynamicRegistration_ExtendedSettings	2	32 KB	24 KB	8 KB	0 KB
DesktopModulePermission	152	48 KB	16 KB	32 KB	0 KB
aspnet_Roles	0	0 KB	0 KB	0 KB	0 KB
Ventrian_PropertyAgent_CustomField	38	56 KB	48 KB	8 KB	0 KB
Ventrian_PropertyAgent_Photo	59	32 KB	8 KB	24 KB	0 KB
activeforums_Settings	2335	528 KB	160 KB	184 KB	184 KB
Ventrian_PropertyAgent_Property	103	48 KB	16 KB	32 KB	0 KB
activeforums_Subscriptions	2070	136 KB	88 KB	16 KB	32 KB
Ventrian_PropertyAgent_PropertyType	245	120 KB	104 KB	16 KB	0 KB
DnnForge_NewsArticles_Feed	41	32 KB	16 KB	16 KB	0 KB
aspnet_UsersInRoles	0	0 KB	0 KB	0 KB	0 KB
Ventrian_PropertyAgent_PropertyValue	835	352 KB	248 KB	48 KB	56 KB
Ventrian_PropertyAgent_Template	3	16 KB	8 KB	8 KB	0 KB
DnnForge_NewsArticles_FeedCategory	37	16 KB	8 KB	8 KB	0 KB
Ventrian_PropertyAgent_TemplatePortal	0	0 KB	0 KB	0 KB	0 KB
CISS_ContentItem	0	0 KB	0 KB	0 KB	0 KB
Assemblies	77	16 KB	8 KB	8 KB	0 KB
activeforums_Tags	12	16 KB	8 KB	8 KB	0 KB
DesktopModules	73	112 KB	32 KB	48 KB	32 KB
ifty_TabModuleCreation	3	16 KB	8 KB	8 KB	0 KB
Ventrian_PropertyAgent_ReviewField	0	0 KB	0 KB	0 KB	0 KB
activeforums_Templates	101	616 KB	584 KB	16 KB	16 KB
ifty_TabRedirect	0	0 KB	0 KB	0 KB	0 KB
Users	4541	1248 KB	904 KB	264 KB	80 KB
Tmp_Events	0	0 KB	0 KB	0 KB	0 KB
Ventrian_PropertyAgent_ReviewValue	0	0 KB	0 KB	0 KB	0 KB
DynamicRegistration_DynamicQuestionEvent	0	0 KB	0 KB	0 KB	0 KB
PackageTypes	11	16 KB	8 KB	8 KB	0 KB
activesocial_Files	134	112 KB	72 KB	16 KB	24 KB
grmRepositoryAttributeValues	0	0 KB	0 KB	0 KB	0 KB
Ventrian_PropertyAgent_Review	0	0 KB	0 KB	0 KB	0 KB
grmRepositoryAttributes	0	0 KB	0 KB	0 KB	0 KB
PortalSettings	84	32 KB	16 KB	16 KB	0 KB
activeforums_Topics	6038	560 KB	352 KB	160 KB	48 KB
Roles	66	96 KB	40 KB	56 KB	0 KB
activeforums_Queue	0	32 KB	24 KB	8 KB	0 KB
activesocial_JournalTypes	23	72 KB	56 KB	16 KB	0 KB
ifty_UserProfileAction	0	0 KB	0 KB	0 KB	0 KB
Ventrian_PropertyAgent_Broker	1	16 KB	8 KB	8 KB	0 KB
ContentTypes	2	16 KB	8 KB	8 KB	0 KB
Workflow	2	32 KB	8 KB	24 KB	0 KB
RoleGroups	2	48 KB	8 KB	40 KB	0 KB
DnnForge_NewsArticles_Image	0	0 KB	0 KB	0 KB	0 KB
ContentItems	349	88 KB	40 KB	16 KB	32 KB
WorkflowStates	3	32 KB	8 KB	24 KB	0 KB
SkinPackages	45	16 KB	8 KB	8 KB	0 KB
Schedule	13	16 KB	8 KB	8 KB	0 KB
TabSettings	396	64 KB	56 KB	8 KB	0 KB
TabModules	517	864 KB	696 KB	80 KB	88 KB

How were they able to come to this conclusion?


Active Forums is using about 100mb in the database. Nothing looks out of the ordinary. I'm guessing your transaction log is making the database appear larger than it really is. If database size is causing you a problem then you should get one of your db experts to help you configure your database so it is properly backed up and the transaction log cleared on a daily basis. Power DNN should actually be able to do this for you as well.

I honestly do not know how they come to that conclusion.  I will talk to PowerDNN about the transaction log.

Thanks for the quick response.