Updating 5M rows & populate fulltext at the same time...problem!
Posted on 2007-10-10
Hi All, I have several statements that do the update to different fields on a table that stores 5M rows of data. When the first statement done, before the second statement starts, a increamental fulltext population on the same table started. And I found there is a locked error.
Msg 1204, Level 19, State 1, Server SERVER_NAME, Line 1
The SQL Server cannot obtain a LOCK resource at this time. Rerun your statement when there are fewer active users or ask the system administrator to check the SQL Server lock and memory configuration.
I have some questions on this:
1) Does it really a increamental fulltext population will 'lock' the table during the population process?
2) Is there any other possibilities that could cause that error? (there was no other processes running at the same time)
3) For a table with 5M rows of data, if only less than 1500 rows data changed (either new or updated), how long could it take for the increamental fulltext population to complete? That is a quad-cpu server.
Thanks in advance!