text search in csa mc events not possible

jan.nielsen · ‎03-13-2009

Hi There,

I have a csamc 6.0 using an external ms sql 2005 server. We have been using the text filtering function for awhile now, but suddenly it is just getting the csamc to its knees when trying to search for ex. a specific executable file in the log, what could be causing this ? the DB admin says he has no performance problems on the server, and we have not changed anything on the csamc or the DB server, csamc reports that indexing is enabled on the server.

jan.nielsen · ‎03-13-2009

We actually solved it, we got the DB admin to do what he called an optimize on the full text serch, which got it down from 100MB to 73 MB, maybe there is a limit in csa of how much full text data it can search in ?