Getting Constant SQL Exception TimeOut issue
We have a DNN 5.6.1 Install that has been running on a server with no issues in the previous years.... this year we're suddenly getting the following errors at specific times of the day thus bringing the site down. We routinely clear the event log, however we still get this periodic SQL Exception timeout error.
Here is the SQL error...
-------------------------------------------
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)
--------------------------------------------
DNN - Event viewer basically confirms that there is a SQL connection that has been lost. And the Server Event Viewer shows that a worker process spikes the server at 100% thus eventually causing the website to loose sql connections.
Question: Is this a server issue or memory issue? This particular Install has had "NO" problems until this year. Or is there something i can do on the DNN side to stop this Index #:0 etc. error?
We have other DNN versions all of which have started doing the same thing on the server... some sites more than others... but they eventually display the SQL Exception server timeout issue. All of which happen at different times.
Just curious what i could try or set inside DNN so users will stop getting the SQL Error screen. I would also like to substitute a screen so the user never sees a SQL Exception error displayed.
Please advise.
Thanks