I am having a similair issue and after the update to sysfulltextcatalog still get the error message. ANy suggestions?

Thanks for the information

I added the covering key same results. Besides the disk queue length is stuck at between 4 and 12. Until then....waiting on hardware. Thanks for your help.

Looks like the index size grew.

1. clustered, unique

name                                       rows        reserved           data               index_size       unused            

--------------------------------------- ----------- ------------------ ------------------ ------------------ -----------

PS_KK_ACTIVITY_LOG                        12556668    10376000 KB        4018136 KB         6357624 KB         240 KB

2. clustered, non-unique

name                                      ...

StmtText                                                                                                                                                                

------------------------------------------------------------------------------------------------------------------------------------------------------------------------

SELECT DISTINCT H.BUSINESS_UNIT ,A.LEDGER_GROUP FROM PS_KK_ACTIVITY_LOG A ,

 PS_KK_SOURCE_HDR H WHERE H.KK_TRAN_ID = A.KK_TRAN_ID AND H.KK_TRAN_DT

 = A.KK_TRAN_DT

(1 row(s) affected)

StmtText                                                                                                                                                                                              

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

  |--Hash Match(Aggregate, HASH

Well I re-ran a DBCC REINDEXDB on the two tables. Got the time down to 1 minute 15 seconds. Looking at perfmon I am CPU and DISK bound (queue lengths...

Here are the indexes. I have run out of ideas to fix.

PS_KK_ACTIVITY_LOG:

nonclustered located on PRIMARY - KK_TRAN_ID, KK_TRAN_DT, KK_TRAN_LN

nonclustered located on PRIMARY - KK_TRAN_ID, KK_TRAN_DT, LEDGER

nonclustered located on PRIMARY -...