sql server, databases, auto grow, error log - SQLServer-QA.net

Browse by Tags

Warning: Autogrow of file 'DB File Name' in database 'DB Name' took <number> milliseconds. Consider using ALTER DATABASE to set a smaller FILEGROWTH for this file. Published 21 February 8 6:22 AM | SSQA.net: The message on subject is self-explanatory where your disk subsystem is referring to SQL Server that it is unable to cope up the demand. Having AUTOGROW option enabled on a SQL Server database is a common setup that allows SQL Server automatically expands...

Filed under: sql server, performance, databases, dba, disk space, error log, monitoring, configuration, alter database, auto grow