SQL Search timeout when applying a search filter
We are currently experiencing an issue where the search will time out if we apply a Record type filter or in the case of Audits an Event type filter
If we leave all types/events tagged there is no issue
DB stats are updated each night and we have just ran an update stats just in case but the issue continues.
Search timeout is set to 3 minutes
Currently running 220.127.116.110
Re: SQL Search timeout when applying a search filter
How many History type objects do you have?
I have seen some CM datasets with 100s of millions of rows of History objects, and usually organisations don't provision their CM SQL server to be able to handle searching over a table that large...
You may see some improvement for that specific filter by adding an index to the oaEvent column on TSONLINEAU