Sql server table may be requested but not updated

Question

I have a table that has always been updated before, but then I can no longer update any of the columns in the table. I can still query the whole table, and the results will return very quickly, but the moment I try to update a column in the table, the update request just nods and does nothing.

I tried to use

select req_transactionUOW
from master..syslockinfo
where req_spid = -2

to see if any lost operation was blocking but not returning any results.

I can’t find signs of blocking my table, but I just can’t update it. any clues as to how to fix the table or whatever state it is in?

Answer 1

" ", ? , .net 30 . SQL- ( -).

, - : ?

, , , , , MDF LDF, IO, ... .. SQL ?

, , .

Answer 2

, , .

, , . ? .

Answer 3

:

SELECT  COUNT(*)
FROM    mytable WITH (UPDLOCK, READPAST)

, ,

SELECT  COUNT(*)
FROM    mytable

, , , .

Answer 4

, , , sp_lock. . DB_NAME OBJECT_NAME, , dbid ObjId.

Answer 5

? , , , .

Answer 6

? ( , ), , ( )/, , . , SQL Server , / .

DBCC : DBCC SQLPERF(LOGSPACE) , ( ) . ( ) 100%, .

.