Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 fulltext performance issue after upgrade sql 2008

Author  Topic 

soulbico
Starting Member

1 Post

Posted - 2011-12-05 : 16:30:06
hi
i had set up the fulltext on my sql server 2005. now i upgrade that database by moving to another server which is sql server 2008.
i noticed that since the upgrade, the fulltext is taking so long to respond.
i rebuild it and reindex but still the same issue .
can someone tell me ifthere is a potential issue after upgrading from sql 2005 to Sql 2008?

Kristen
Test

22859 Posts

Posted - 2011-12-09 : 03:10:23
You sure its the FULLTEXT that's the problem? Did you rebuild indexes and update statistics after the upgrade? if not that might be the problem.

See: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=138230

Go to Top of Page
   

- Advertisement -