MSSQL Server 2005 and read-only mode

Question

SQL Server

By chance, I have to administer a windows server. It has MSSQL Server 2005 for the database. The problem is that periodically the database, when trying to update or add to the content database, the connection breaks due to a timeout. At the same time, reading occurs in the normal mode, there are enough resources. After a while, the problem disappears on its own. Unfortunately, there is practically no experience with winservers, and the problem needs to be solved. Therefore, I turn to the habra community with the question of what could be the reason. At the same time advise any system of monitoring for iis of the server.

Answer 1

yeah, found:
Autogrow of file '*_log' in database '***' was cancelled by user or timed out after 30422 milliseconds. Use ALTER DATABASE to set a smaller FILEGROWTH value for this file or to explicitly set a new file size.

Answer 2

Locks are possible at the first attempt of Insert or Update. Also, critical things are visible in ERRORLOG (can be found in ManagementStudio or "C:\Program Files\Microsoft SQL Server\MSSQLyour_version.MSSQLSERVER\MSSQL\Log") if something happens to the database, it will definitely be visible there.