DB locking up for a short interval

[SMBrewer]

We have purchased an off-the-shelf software system that uses SQL Server Standard Edition as the backend. Everything ran smooth for a couple of months until recently, when about 2 times a day the db will appear to be locked up for about 20 minutes (when issue a simple sql statement on db it appears to be locked up, then about 20 minutes later it returns the result). However, the other databases attached to the server can still be accessed while this one appears to be frozen.
We have noticed that one of the database files has grown substantially just before problems occurred (1 GB to 1.8GB)and the log file(.ldf) for the database doubled in size just before the problems occurred (to about 300 MB). My gut tells me it may have something to do with the log file, but I am really clueless about this.

Does anyone else have any suggestions?

Thanks.

Steve

 

[JtheRipper]

Hi,

Your logfile might be "full" and growing dynamically. Try to truncate your logfile (see BOL for syntax), or truncate your logfile every time after you make your backups. Also, have a look at locks to see if there are no locks when you are running your sql statement.