My SQL Server 2003 machine has been taking very long to preform transactions and i am getting locked objects.
I back up the server daily.This is also a production server.
I checked the Logs and I saw I keep getting this error
Autogrow of file 'My_DATABASE' in database 'MY_DATABASE' cancelled or timed out after 30641 ms. Use ALTER DATABASE to set a smaller FILEGROWTH or to set a new size.
I have noticed that the SPID used is the same that is locking my Objects.
Does anybody have any suggestions how I can fix this problem.