Occasionly having Problems with my Sharepoint Server 2003 and SQL 2000. Frequently I'm having problems with high CPU load that reduces the access to the "My Sites"- areas. It's obvious that it's mostly mssearch.exe causing the trouble (but sometimes I see a high sqlserv.exe as well).
I'm running SPS 2003 with SP2 and SQL2000 with SP4. I have applied all patches according to microsoft articles.
Should I rebuild indexes ?
Other solutions ?