Good afternoon, and thank you for responding to my ticket, I managed after two days of research to find the solution to this problem. After installing this module, so far I do not crash again.

http://www.iowacomputergurus.com/products/dotnetnuke-extensions/scheduled-sql-jobs

It seems that the problem resides in the database and that each change that is made in DNN creates about 4000 to 3000 lines in the logs, after having created a store procedur (SP) to solve the problem, what happened there was need to create SP run every 30 min, for the DNN not go down and the ISS of Arvixe not have the APP Pool down.

Here follows the SP I created:

Store Procedure

USE [YourDataBase]
GO
/****** Object:  StoredProcedure [dbo].[sp_cleanSearch]    Script Date: 21-12-2012 16:28:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[sp_cleanSearch]
AS
truncate table SearchItemWordPosition;
DELETE SearchItemWord;
DELETE SearchWord;
DELETE SearchItem;

So? What to do do and Solve the problem...

STEP 1 - Install the module (link above)

STEP 2 - Create the module on DNN and go there!

STEP 3 -  Create new jobs as follow.

ScheduledSqlJobs

Existing Jobs

The following jobs are currently in the system.

Add New Job!

Job Title	Job Script	Schedule	Next Run	Last Run
Clean Event Log	ICG_SJ_CleanEventLog	1 Hours	12/27/2012 4:35:19 AM	12/27/2012 3:35:19 AM	Edit	Delete	History	Run Now
Clean Site Log	ICG_SJ_CleanSiteLog	1 Hours	12/27/2012 4:35:19 AM	12/27/2012 3:35:19 AM	Edit	Delete	History	Run Now
Truncate SiteLog	ICG_SJ_TruncateSiteLog	1 Hours	12/27/2012 4:35:19 AM	12/27/2012 3:35:19 AM	Edit	Delete	History	Run Now
Shrink Database	ICG_SJ_ShrinkDatabase	5 Hours	12/27/2012 6:38:47 AM	12/27/2012 1:38:47 AM	Edit	Delete	History	Run Now

Scheduled SQL Jobs is a free module provided by IowaComputerGurus Inc. (Donations Appreciated)

(this is the copy&paste of my jobs created)

I hope to help everyone this solved my problem.

Best Regards to all team of DNN and Arvixe.

Happy New Year.