Sql Server 2008 Full Text Seach performance issues

view full story

http://serverfault.com – We have the following setup for an web application: Server Intel Xeon E5606 @2.13GHz (2 processors - quad core) 24GB RAM Software SO: Windows Server 2008 R2 Standard (SP1) x64 Microsoft SQL Server 2008 R2 Database environment description: The SQL server is hosting 1 database that is accessible from our applications: DB1 - production database (around 1.5 million records) The application has around 1.5 million pagevies per day. Problems encountered: FTS Index rebuilding - Each time the index is being rebuilt, the CPU rises to 100% - this I think it is normal, but the problem is (HowTos)