"Mike Kansky" <MikeKansky@discussions.microsoft.com> wrote in message
news:60169C43-9233-4021-88C2-9C200A4E0462@microsoft.com...
>I have a table with Full Text index on it, the table has at the most 300
> records.
> The database is on the live server and gets hit a lot.
>
> Every morning when i come to work the table is inaccessible, meaning any
> query that i issue to this table runs indefinitely, Select, update, Insert
> all just hang.
>
> The only way for me to fix this is manually End The Full Text Sql Windows
> Task, in task manager. As soon as i end the task it restarts immediately
> and
> everything is working fine after.
>
> Is there a patch for Sql 2005 to fix this, did anyone experience something
> like that?
>

"Mike Kansky" <MikeKansky@discussions.microsoft.com> wrote in message
news:0953B0F8-5E75-482A-A273-DFA94BEAEA73@microsoft.com...
> Thank you Hilary.
> I checked and i have the change tracking set to Auto.
> I cannot find where i can change the resource usage for FT.
> Can you help please?
>
> It is Sql 2005.
>
>
> "Hilary Cotter" wrote:
>
>> Full-text indexing will cause some locking as it needs to create some
>> level
>> of consistency with what is in the catalogs and what is in the database.
>> Are
>> you using change tracking? If not you really should. You also might want
>> to
>> set your resource usage to something smaller.
>>
>> One more point, it is possible that other non-optimal procs or ad hoq sql
>> statements are themselves not tuned and are causing overall performance
>> problems manifesting itself in FTI locking.
>>
>>
>>
>> --
>> Hilary 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
>>
>>
>>
>> "Mike Kansky" <MikeKansky@discussions.microsoft.com> wrote in message
>> news:60169C43-9233-4021-88C2-9C200A4E0462@microsoft.com...
>> >I have a table with Full Text index on it, the table has at the most 300
>> > records.
>> > The database is on the live server and gets hit a lot.
>> >
>> > Every morning when i come to work the table is inaccessible, meaning
>> > any
>> > query that i issue to this table runs indefinitely, Select, update,
>> > Insert
>> > all just hang.
>> >
>> > The only way for me to fix this is manually End The Full Text Sql
>> > Windows
>> > Task, in task manager. As soon as i end the task it restarts
>> > immediately
>> > and
>> > everything is working fine after.
>> >
>> > Is there a patch for Sql 2005 to fix this, did anyone experience
>> > something
>> > like that?
>> >
>>
>>
>>