Is it possible to move the MSSEARCH.EXE service off our production server to a 2nd (SQL) server so we can distribute the CPU and I/O of the incremental populations that are going on for the full text indexes? We are seeing high CPU usage and I/O from the loads we are doing throughout the day. Thanks!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Full text indexing / MSSEARCH - different server?
- Thread starter vnad
- Start date
mrdenny
Programmer
- May 27, 2002
- 11,595
Interesting idea.
I can't think of anyway to do this without moving the entire table with the text object to a second server.
There isn't much you can do about the CPU (the mssearch shouldn't be taking all that much CPU), but you can move the full text index as well as the text column it self to a different drive or drives to reduce IO on your main drive and speed things up.
Denny
MCSA (2003) / MCDBA (SQL 2000)
--Anything is possible. All it takes is a little research. (Me)
![[noevil]](/data/assets/smilies/noevil.gif "[noevil] [noevil]")
Donate to Katrina relief
I can't think of anyway to do this without moving the entire table with the text object to a second server.
There isn't much you can do about the CPU (the mssearch shouldn't be taking all that much CPU), but you can move the full text index as well as the text column it self to a different drive or drives to reduce IO on your main drive and speed things up.
Denny
MCSA (2003) / MCDBA (SQL 2000)
--Anything is possible. All it takes is a little research. (Me)
Donate to Katrina relief
- Thread starter
- #3
Thanks for the quick reply.
I was looking into a CPU issue when I noticed how much CPU the incremental populations were taking for resources. It jumps it to about 80-90 percent cpu when running and only 15-20 percent cpu when it is idle.
Those are good ideas as I was thinking similar things. I might also change the priority of the service with sp_fulltext_service.
Do incremental populations usually take a lot of resources to run? Thanks!
I was looking into a CPU issue when I noticed how much CPU the incremental populations were taking for resources. It jumps it to about 80-90 percent cpu when running and only 15-20 percent cpu when it is idle.
Those are good ideas as I was thinking similar things. I might also change the priority of the service with sp_fulltext_service.
Do incremental populations usually take a lot of resources to run? Thanks!
mrdenny
Programmer
- May 27, 2002
- 11,595
Not normally. At a previous company we had a very large full text index (it was on the messages table for a very popular forum site with millions of users) at the incremential didn't take very much CPU power at all, but it did run for hours. We ran the incremential every 3 hours, and it took just under 3 hours to run.
You can try rebuilding the catalog and doing a full population. The catalog may have become corrupt, or majorly fragmented (depending on how busy your table is).
Denny
MCSA (2003) / MCDBA (SQL 2000)
--Anything is possible. All it takes is a little research. (Me)
Donate to Katrina relief
You can try rebuilding the catalog and doing a full population. The catalog may have become corrupt, or majorly fragmented (depending on how busy your table is).
Denny
MCSA (2003) / MCDBA (SQL 2000)
--Anything is possible. All it takes is a little research. (Me)
Donate to Katrina relief
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question