October 21, 2003 at 11:23 am
I have run into a problem with one of my applications. Queries from the web servers start to time out when accessing the SQL Server 7 database. The last time that this has happened there was a exclusive FIL lock that was holding everything. The sp_who showed that there were no blocks but things were still hanging. The sp_locks showed the exclusive FIL lock. I killed the SPID and everything freed up. What type of functions\queries in SQL Server would obtain a FIL lock? This is happening about every two to three weeks and I would love to have a resolution before it happens again.
Paul Bourg
October 21, 2003 at 1:01 pm
We had a similar problem when one of our applications was written with a long query and the results were being displayed in a grid. In our case, the problem was the BDE engine in Delphi would only read as much as needed to fill the grid, but would keep the query open.
We changed the query to be NOLOCK and the problem was resolved.
Guarddata-
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply