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 2005 Forums
 SQL Server Administration (2005)
 Full-text searching not caching

Author  Topic 

coolerbob
Aged Yak Warrior

841 Posts

Posted - 2008-12-18 : 08:34:56
Hello boys and girls,

I got me a biiiig problem. Full-text searching has gone badly wrong. I've read every article and checked every setting. Basically indexing is fine. But searching is dog-slow. It doesn't seem to cache anything to memory anymore. It's got plenty of memory but it's not using it. It only caches for a very short period of time.
That's further proven by the fact that my average disk queue length has jumped from 1.4 to 11!!
Does anyone know how I can get full-text search to start behaving again?
If not, I'll get on to Microsoft and report back here.
   

- Advertisement -