Auto Grow Issues

Posted on 2006-06-07
Last Modified: 2012-08-14
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.
Question by:Stanton_Roux
    LVL 142

    Accepted Solution

    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).

    LVL 5

    Expert Comment

    Is there a max size that is being placed on the file?

    Author Comment


    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

    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    is there any space left on the disk?
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    do you perform regular backups on the database/transaction logs?
    is the database in full or simple recovery mode?

    Author Comment

    There is plenty of space left on the disk.
    I preform a complete backup everyday.

    and the database is in full recovery mode

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    In this article—a derivative of my blog post (—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
    Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
    Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now