We have been having problems with our site running slowly for about a week....  there were a lot of General exceptions (timeout on queries.) in the event log file to do with Schedule.

The server was on 5.4 then I upgraded to 5.6 to ensure latest version.

I truncated the various log files including 

truncate table SearchItemWordPosition
DELETE SearchItemWord
DELETE SearchWord
DELETE SearchItem

Since then I still have a lot of of General Exceptions -

AssemblyVersion: 5.6.1
PortalID: -1
PortalName: 
UserID: -1
UserName: 
ActiveTabID: -1
ActiveTabName: 
RawURL: 
AbsoluteURL: 
AbsoluteURLReferrer: 
UserAgent: 
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: a205f43d-bc93-455d-8d74-8c04c44c480e
InnerException: Violation of UNIQUE KEY constraint 'IX_SearchItemWord'. Cannot insert duplicate key in object 'dbo.SearchItemWord'. The statement has been terminated.
FileName: 
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlConnection.
StackTrace: 
Message: System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_SearchItemWord'. Cannot insert duplicate key in object 'dbo.SearchItemWord'. The statement has been terminated.at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)at System.Data.SqlClient.SqlInternalConnection. (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.ExecuteScalar()at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues)at DotNetNuke.Data.SqlDataProvider.AddSearchItemWord(Int32 SearchItemId, Int32 SearchWordsID, Int32 Occurrences)at DotNetNuke.Services.Search.SearchDataStore.AddIndexWords(Int32 indexId, SearchItemInfo searchItem, String language)at DotNetNuke.Services.Search.SearchDataStore.StoreSearchItems(SearchItemInfoCollection SearchItems)
Source:


ALSO

AssemblyVersion: 5.6.1
PortalID: -1
PortalName: 
UserID: -1
UserName: 
ActiveTabID: -1
ActiveTabName: 
RawURL: 
AbsoluteURL: 
AbsoluteURLReferrer: 
UserAgent: 
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 43cf1ec4-9bb6-4e0d-9904-0937b3988828
InnerException: Transaction (Process ID 56) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
FileName: 
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlConnection.
StackTrace: 
Message: System.Data.SqlClient.SqlException: Transaction (Process ID 56) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)at System.Data.SqlClient.SqlInternalConnection. (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.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.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)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.Data.SqlDataProvider.AddSearchItemWordPosition(Int32 SearchItemWordID, String ContentPositions)at DotNetNuke.Services.Search.SearchDataStore.AddIndexWords(Int32 indexId, SearchItemInfo searchItem, String language)at DotNetNuke.Services.Search.SearchDataStore.StoreSearchItems(SearchItemInfoCollection SearchItems)
Source: 

Any help please?

Hi Sebastian,

Current table sizes are below

SearchItemWordPosition 256900 
SearchItemWord 171757 
SearchWord 17100 
ModuleSettings 11388 
SearchItem 6573 

First number shows the rows...Searchitemwordposition is double what it was before I ran your recommended cleanup script on the post below

http://www.dotnetnuke.com/Resources/F... 

delete SearchItemWordPosition where SearchItemWordId in (select SearchItemWordId from SearchItemWord where SearchItemID in (select SearchItemId from SearchItem))  
delete SearchWord where SearchWordsId in (select SearchWordsId from SearchItemWord where SearchItemID in (select SearchItemId from SearchItem))  
delete SearchItemWord where SearchItemId in (select SearchItemId from SearchItem) delete SearchItem

Any thoughts on how to fix these tables?

Many thanks,

Sean

Followed your instructions but before doing so I I temporarily disabled the new version of AVG that I install recently....and this had a dramatic effect on performance...pages became much more responsive especially the Login page which was slow and even inaccessible up till now. When I reactivated AVG the problems returned.....Also note that DNN4 sites running on the same machine do not have any performance problems or accessiblity of the Login page... Any thoughts on this?