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.
| Author |
Topic |
|
ddamico
Yak Posting Veteran
76 Posts |
 Posted - 2009-02-02 : 13:25:37
|
| I have a full-text catalog that is being inrementally updated once a week using sp_fulltext_table N'[dbo].[A_Search]]', N'start_incremental'. Of course we use a timestamp column to manage to optimize the build process.The build process has been running almost 2 years and probably taking no more than a minute or two to complete. The last two Sundays I awoke to the process sitting there blocked by another process and sleeping for upwards of 7 hours. The blocking process is the full text search from our website. which is nothing more then a several selects with NO transaction blocks.Consequently, we use a websitepulse that calls the search to help ensure the site is up (thus the search full text search). Now this process is always active and has not caused an issue previously.I did notice the SQL Server was pegged at 100%. After stopping/restarting MSSearch and manually firing the fulltext build things seem to have went back to normal. I reviewed the logs and event viewere and haven't found anything to tell me what the issue was. I am hoping someone has some infinite knowledge and could point me in the right direction or explain what might be happening as I am not sure where to look beyond this.SQL Server 2000 SP4 (Window Server 2003 SP2) |
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2009-02-02 : 16:14:55
|
| I would look at the webserver logs from the time 7 hours before you noticed the error.Search these logs for "select" It is possible someone is attempting to sql inject you.There are a massive number of posts and a blog dedicated to filtering input if that happens to be the case. |
 |
|
|
|
|
|
Full-text Issues