 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Full-Text Search / June 2006full-text population monitor
Hi, I know that we can know the population status with using cscript gthrlog.vbs <file name> but do you have any monitor script or job summary status about this..? We need to proactive know about our population status.. what is your practice to monitor on this? --soonyu You can't really do this in SQL 2000. In SQL 2005 you can use the MSFTESQL:Indexer Plugin Documents Filtered and you can check a specific catalog.  SignatureHilary Cotter Director of Text Mining and Database Strategy RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or opinions. Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com > Hi, > I know that we can know the population status with using [quoted text clipped - 6 lines] > > --soonyu read from article, Change Tracking is a population method can update the Catalog immediately, or be scheduled (Update Index). My question is, will these affected out base table performance? If the base table change quite frequeny, change tracking will update catalog with same frequent as well. Any opinion? --soonyu > Hi, > I know that we can know the population status with using [quoted text clipped - 6 lines] > > --soonyu Yes, change tracking is near real time. SignatureHilary Cotter Director of Text Mining and Database Strategy RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or opinions. Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com > read from article, Change Tracking is a population method can update the > Catalog immediately, or be scheduled (Update Index). [quoted text clipped - 16 lines] >> >> --soonyu |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.