Post reply

Autogrow file error

  • February 22, 2006 at 6:29 am

    #167208

     

    Hi

    For the past few days I'm getting an error for a few databases.

     

    Autogrow of file 'templog' in database 'tempdb' cancelled or timed out after 0 ms.  Use ALTER DATABASE to set a smaller FILEGROWTH or to set a new size.

    The autogrow option is ticked for this database and the the space allocated to the log file is 1Mb and the growth is set to 10%.

    Could anyone please tell me as to why this error is coming???

  • February 22, 2006 at 7:00 am

    #622599

    This is INFORMATIONAL message added in Service Pack 4.

    There might be some operation going on (which caused file to grow) which was cancelled.

    If you have profiler for same time, you will see attention event captured in Event Class.

     

     

  • February 22, 2006 at 3:31 pm

    #622767

    have you checked your free disk space size lately?

    master..xp_fixeddrives

     

     

  • February 22, 2006 at 3:36 pm

    #622770

    It will good iif u can pre allocate the temp db size to avoid autogrow..and set the autogrow in MB instead of percent..

    -Krishnan

  • February 22, 2006 at 3:40 pm

    #622773

    yes krishnan is right.... preallocate and autogrow by fixed MB is best.....  the way you're set up now will eventually lead to some really nasty filesystem fragmentation.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply