January 15, 2007 at 11:02 am
We are experiencing query time outs caused by processes being blocked by other processes. When I look at syslockinfo, I can see the blocking spid with the rsc_type field = 3. This is a file lock. Does any one know what can cause a file lock in SQL Server?
Thanks in advance.
January 15, 2007 at 1:54 pm
It could be autogrow but not sure...
What was inputbuffer of that SPID when it was locking the FILE?
MohammedU
Microsoft SQL Server MVP
January 15, 2007 at 2:08 pm
That's the strange part. The DBCC INPUTBUFFER showed that the SPID was not stuck executing one query. The SPID would submit one query and then another, etc. It appeared that the SPID's user was working away, blissfully unaware that they were blocking other users of the application. I was thinking autogrow also, but I can't find any information regarding what might cause a file lock.
Thank you for your reply.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply