SQL Server Performance

Full Text Search is slow only for certain words

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by Narine, Oct 7, 2008.

  1. Narine New Member

    Hi all,
    We have a Full Text Search setup on one of the tables in the SQL Server 2005 database.
    It works fine for most of the cases, returns results in a matter of a second. But every once in a while, it times out in our application when searching for certain words. Does anyone know why some words take longer to search for than others?
    For instance, searching for a string "Mike" takes 4 times as long than searching for "Jack".
    Any ideas?
    Regards
    Narine
  2. MohammedU New Member

Share This Page