SQL Server Performance

Database Autogrow Timeout

Discussion in 'General DBA Questions' started by ddupuis, Apr 25, 2007.

  1. ddupuis New Member

    We started getting the following error today on a server I just rolled out on Sunday.

    Autogrow of file 'CMN_PRD_Data' in database 'CMN_PRD' cancelled or timed out after 15594 ms. Use ALTER DATABASE to set a smaller FILEGROWTH or to set a new size.

    It is set to autogrow 200MB at a time unrestricted. This does not seem like a very large amount to me. There is plenty of room on the disk. Any ideas why this would time out? These databases had been autogrowing on the old server without issue. Have I missed some configuration setting or something?
  2. ghemant Moderator

  3. satya Moderator

    Check if there are any hardware issues on the server to accomodate the SQL process execution, also check Hemant's link.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Share This Page