Friday, March 23, 2012

Lock in FTS

Hello,

There are some king of lock that stop my search process over a FTS table indOfertaCliente.

The Query:

SELECT TOP 1 * FROM indOfertacliente

Works fine...but

SELECT * FROM CONTAINSTABLE(dbo.indOfertaCliente, (*),'polar', LANGUAGE 3082, 1)

returns timeout. Also i receive timeout when i try to disable de FTS index over the table.

Which resource can be locked? Where can i see it?

Sql 2005. SP1

Tahnks in advance

When you run it does the statement show as blocked?

Have a look at sys.dm_exec_requests for rows with blocking_session_id not null.

No comments:

Post a Comment