i am using dnn 5.6.2 and sql2008 .we have a huge dataentry per day in a database through the website.


Till last week website speed was good and everthing was working in a normal way.

Last week onwards website speed was very slow.it is taking too much time to load the pages and sometimes we are getting timeout error from sql as follows.

SQL Exception
Error Details
File
Error Index #: 0
Source: .Net SqlClient Data Provider
Class: 11
Number: -2
Procedure:
Message: 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.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Services.Log.EventLog.DBLoggingProvider.Data.SqlDataProvider.AddLog(String LogGUID, String LogTypeKey, Int32 LogUserID, String LogUserName, Int32 LogPortalID, String LogPortalName, DateTime LogCreateDate, String LogServerName, String LogProperties, Int32 LogConfigID) at DotNetNuke.Services.Log.EventLog.DBLoggingProvider.DBLoggingProvider.WriteLog(LogQueueItem objLogQueueItem)




we have huge data entry per day in sql 2008 database.I wanted to know whether it is because of huge data in database?The db size is unlimited na?when i try to connect sql 2008 from server, i cannot able to connect it.There also i am getting the error like as follows.


Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding



please i need to solve this issue quickly.give me all the solutions to solve this immediately.

You must turn off all exception in Event viewer (in admin page).

Can you provide more details about the "huge data entry."

As you have seen from the exception, something is going on in your database. You probably will want to do some database maintenance. Start by looking at the sizes of table in the database. I the Event Log table is large, you migt want to "truncate" the table to reduce the data. IowaComputerGurus.com has a free module that will do basic database maintenance on a scehdule.

It may also be the the large data entries are generating large log files. If you backup your database with appropriate options set, that will reduce the size of the log file.

dear joe,
actually we have a GPS vehicle tracking system.Using a socket application,nearly 150 vehicle data is getting each 2 minute interval and pushing to Sql DB.

how can i do this?

dear joe,
we installed two website(both are dnn) in one server .
whether it will cause any problem

is it required to keep one website in another server?
i am getting error like as follows


SQL Exception
Error Details
File
Error Index #: 0
Source: .Net SqlClient Data Provider
Class: 11
Number: -2
Procedure:
Message: 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.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Services.Log.EventLog.DBLoggingProvider.Data.SqlDataProvider.AddLog(String LogGUID, String LogTypeKey, Int32 LogUserID, String LogUserName, Int32 LogPortalID, String LogPortalName, DateTime LogCreateDate, String LogServerName, String LogProperties, Int32 LogConfigID) at DotNetNuke.Services.Log.EventLog.DBLoggingProvider.DBLoggingProvider.WriteLog(LogQueueItem objLogQueueItem)

There should not be a problem installing multiple DotNetNuke installations on a single server. Of course, that depends on the capabilities of the server.

I have a test webserver that is actually a virtual machine hosted on a dual-processor system with 2.5 ghz processors. My virtual web server has 768 mb of memory installed, and that is sufficient for the web server.

Your error message indicates a problem connecting to the SQL Server, so I'm guess that is the problem. I'd put the SQL Server on a separate machine and give it enough ram to work. In my test environment, a virtual machine with 1024 mb of ram works well. For a more heavily used machine, I'd probably assign 4 Gb.

Separating the web and SQL servers seems to be the standard way of doing things.

dear joe ,my server details i attached here with.

I think it is having the specifications what u specified in the reply.



Sql server 2008 management studio i am using.see the details below



Microsoft SQL Server Management Studio 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
Microsoft Analysis Services Client Tools 2007.0100.1600.022 ((SQL_PreRelease).080709-1414 )
Microsoft Data Access Components (MDAC) 2000.086.3959.00 (srv03_sp2_rtm.070216-1710)
Microsoft MSXML 2.6 3.0 6.0
Microsoft Internet Explorer 8.0.6001.18702
Microsoft .NET Framework 2.0.50727.3615
Operating System 5.2.3790



one of the table in my database contains more than 10,00,000 records now.

whether it is causing any problem?