Auto Grow Issues

Hi There

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.
Stanton_RouxAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
add new filegroups/data files to your database, with a size similar to the existing data files, and with a fixes grow size (do not use percent filegrowth).

0
 
MageDribbleCommented:
Is there a max size that is being placed on the file?
0
 
Stanton_RouxAuthor Commented:


Currently my LDF file is 8 gb and MDF File is 12 gb

There is no max file size set and I have set the growth on both of them to 100 percent.

The space allocated for my MDF File is 1245 mb
the space allocated to my LDF file is 8015 mb



0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
is there any space left on the disk?
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
do you perform regular backups on the database/transaction logs?
is the database in full or simple recovery mode?
0
 
Stanton_RouxAuthor Commented:
There is plenty of space left on the disk.
I preform a complete backup everyday.

and the database is in full recovery mode
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.