Hi,
Our forum is not working. Users can log in, but they get logged off after a few seconds. They can re-login, but they get logged off again.
Earlier this week, we were getting "Out of memory exception" and "unable to validate data" errors. Now the errors are gone, but the session is getting lost.
The hosting company says it uses too much resources. It has 70,000 posts, and 1000 users. Total of 200 MB of SQL space is used.
What can be done to rectify the problem?
If we thin out the posts table (removing older posts), will it fix the problem. The only thing that is running on the CS is the forums module. There is nothing really to disable.
Please help, this is very urgent,
Thank you!
Probably the biggest usage of table space is the search barrel table. You can consider truncating this table. The downside of this is that users will no longer be able to search the site. You may consider that posts older than 90 days are not worth being indexed and being searchable. If this is the case let me know and I will sort out the SQL so you can reindex the posts within this date range.
Alternatively consider moving to a host that provides a larger SQL database.
Dave
These are the same symptoms I have been having -- out of memory errors and unexpected logouts -- and my host has just told me CS is hogging too much CPU and memory -- except that the problems were happening in my other sites hosted in the same account, not on my CS site.
I don't see how reducing the size of your database is going to do much to fix your problem, if the problem is eating up the processor and memory. Your db isn't that big anyway. I can't see how reducing the db is going to help significantly, because you are still going to have the same number of users on the site vying for resources. I'm just shooting in the dark here, having the same exact issues myself.
well, i have talked to our host and they told us that something has to be done to minimize the RAM and CPU usage.
Could you give me some ideas what can be stripped off the forum?
I already got rid of th esearch barrel. Anything else I can do? Thanks!
If you have already cleared the seach barrel and not reindexed it then I am not sure there is a lot more you can easily do. Sooner or later a successful site hosted on limited resources will outgrow those resources.
Maybe consider upgrading to a hosting package offering more resources.
Have you run a query such as the one shown below ?, let us know the results.
CREATE TABLE TableSizes
(table_name SYSNAME,row_count int,reserved_size varchar(10),data_size varchar(10),index_size varchar(10),unused_size varchar(10))INSERT TableSizesEXEC sp_MSforeachtable 'sp_spaceused ''?'''SELECT * FROM TableSizes where row_count > 0 ORDER BY table_name DROP TABLE TableSizes
here are the results
aspnet_Applications 1 24 KB 8 KB 16 KB 0 KBaspnet_Membership 1062 328 KB 296 KB 16 KB 16 KBaspnet_Profile 738 1048 KB 936 KB 16 KB 96 KBaspnet_Roles 13 24 KB 8 KB 16 KB 0 KBaspnet_SchemaVersions 4 24 KB 8 KB 16 KB 0 KBaspnet_Users 1062 136 KB 96 KB 16 KB 24 KBaspnet_UsersInRoles 2283 200 KB 168 KB 16 KB 16 KBcs_ApplicationConfigurationSettings 6 96 KB 40 KB 8 KB 48 KBcs_ApplicationType 13 24 KB 8 KB 16 KB 0 KBcs_BannedAddresses 1 24 KB 8 KB 16 KB 0 KBcs_BannedNetworks 1 24 KB 8 KB 16 KB 0 KBcs_Censorship 10 24 KB 8 KB 16 KB 0 KBcs_DisallowedNames 2 24 KB 8 KB 16 KB 0 KBcs_EventDescriptions 14 24 KB 8 KB 16 KB 0 KBcs_EventLog 5829 1752 KB 1560 KB 16 KB 176 KBcs_Exceptions 33 136 KB 120 KB 8 KB 8 KBcs_FavoritePosts 13 24 KB 8 KB 16 KB 0 KBcs_FavoriteSections 6 24 KB 8 KB 16 KB 0 KBcs_FavoriteUsers 24 24 KB 8 KB 16 KB 0 KBcs_FeedState 6 104 KB 32 KB 16 KB 56 KBcs_Groups 16 24 KB 8 KB 16 KB 0 KBcs_Images 142 432 KB 368 KB 16 KB 48 KBcs_ModerationAction 21 24 KB 8 KB 16 KB 0 KBcs_ModerationAudit 9627 2696 KB 2656 KB 16 KB 24 KBcs_PostEditNotes 5448 1352 KB 1288 KB 16 KB 48 KBcs_Posts 69580 217736 KB 215824 KB 72 KB 1840 KBcs_PrivateMessages 1093 48 KB 32 KB 16 KB 0 KBcs_ProductPermissions 26 24 KB 8 KB 16 KB 0 KBcs_SchemaVersion 43 24 KB 8 KB 16 KB 0 KBcs_SectionPermissions 13 24 KB 8 KB 16 KB 0 KBcs_Sections 83 216 KB 120 KB 16 KB 80 KBcs_SiteMappings 1 24 KB 8 KB 16 KB 0 KBcs_Sites 1 24 KB 8 KB 16 KB 0 KBcs_SiteSettings 1 104 KB 40 KB 16 KB 48 KBcs_Smilies 104 32 KB 16 KB 16 KB 0 KBcs_statistics_Site 14 24 KB 8 KB 16 KB 0 KBcs_statistics_User 100 16 KB 8 KB 8 KB 0 KBcs_ThreadRating 125 16 KB 8 KB 8 KB 0 KBcs_Threads 8305 1160 KB 1112 KB 16 KB 32 KBcs_ThreadsRead 41715 1544 KB 1528 KB 16 KB 0 KBcs_TrackedSections 4 24 KB 8 KB 16 KB 0 KBcs_TrackedThreads 1019 48 KB 32 KB 16 KB 0 KBcs_UserAvatar 142 24 KB 8 KB 16 KB 0 KBcs_UserProfile 1062 536 KB 368 KB 16 KB 152 KBcs_Users 1062 64 KB 48 KB 16 KB 0 KBcs_Votes 611 40 KB 24 KB 16 KB 0 KBcs_VoteSummary 210 24 KB 8 KB 16 KB 0 KBtbl_Ads 155 64 KB 56 KB 8 KB 0 KBtbl_AdTypes 22 16 KB 8 KB 8 KB 0 KBtbl_Categories 23 16 KB 8 KB 8 KB 0 KBtbl_Cities 386 176 KB 136 KB 8 KB 32 KBtbl_CityHotspots 607 32 KB 24 KB 8 KB 0 KBtbl_Companies 1990 728 KB 608 KB 16 KB 104 KBtbl_CompaniesSubcategories 2957 136 KB 72 KB 16 KB 48 KBtbl_CompaniesUsers 2001 72 KB 56 KB 16 KB 0 KBtbl_CompanyPackages 5 16 KB 8 KB 8 KB 0 KBtbl_CompanySpecialTypes 3 16 KB 8 KB 8 KB 0 KBtbl_Events 573 200 KB 176 KB 16 KB 8 KBtbl_EventTypes 10 16 KB 8 KB 8 KB 0 KBtbl_ForumCategories 18 16 KB 8 KB 8 KB 0 KBtbl_ForumPosts 407 200 KB 192 KB 8 KB 0 KBtbl_ForumTopics 75 16 KB 8 KB 8 KB 0 KBtbl_GalleryPictures 833 40 KB 24 KB 16 KB 0 KBtbl_GameCategories 9 16 KB 8 KB 8 KB 0 KBtbl_Games 38 16 KB 8 KB 8 KB 0 KBtbl_GameTypes 4 16 KB 8 KB 8 KB 0 KBtbl_InfoCategories 23 96 KB 80 KB 8 KB 8 KBtbl_InfoPages 620 4248 KB 4232 KB 16 KB 0 KBtbl_InfoSubCategories 70 96 KB 48 KB 8 KB 40 KBtbl_JobCategories 24 16 KB 8 KB 8 KB 0 KBtbl_Jobs 8 16 KB 8 KB 8 KB 0 KBtbl_Movies 793 2688 KB 2640 KB 8 KB 40 KBtbl_OurServices 3 16 KB 8 KB 8 KB 0 KBtbl_PhotoGallery 81 24 KB 8 KB 16 KB 0 KBtbl_Pictures 730 72 KB 56 KB 16 KB 0 KBtbl_PollQuestions 120 24 KB 8 KB 16 KB 0 KBtbl_Polls